Questions tagged as 'mysql'

Tagged questions
2
answers

How to change the location where MAMP creates the database?

I would like to change the location where the mamp creates the bank of data. The default would be this:    / Applications / MAMP / db / And I would like to create by default the Database on my server that would be:    / Volumes /...
asked by 20.02.2014 / 13:09
3
answers

Filter table before applying a LEFT JOIN

I have two tables and I want all elements of the first one - regardless of the JOIN condition (which characterizes a LEFT JOIN) - but before that I want to filter the second table. For example: Client table: ╔══════════╦═══════╗ ║ C...
asked by 19.02.2014 / 20:48
1
answer

How to work with Foreign Keys in C # ASP .NET Core?

Good night, guys. I'm a beginner in C # ASP .NET Core and I'm having problems with Foreign Key. I need to populate a combobox with data from a database table. The following is my model Seller using System; using System.Collections.Generi...
asked by 21.11.2018 / 22:07
1
answer

MYSQL, How to do SELECT without grouping identical WHERE values?

Good Afternoon SELECT id, descricao FROM Produtos WHERE id IN ('1','1','2', '3','3'); But the result is id / descricao 1 / Caneta 2 / Lapis 3 / Borracha I wanted it to look like the table below id / descricao 1 / Caneta 1 / Caneta...
asked by 20.11.2018 / 18:18
1
answer

INNER JOIN in 4 tables

I have 4 tables: TB_OS_MANUTENCAO: TB_OS_ELETRONICA: TB_OS_MECANICA: ETB_OS_INFORMATICA: As shown in the screenshots, all tables have one field in common, the call_id, and also with a common value, 8. This field is not marked UNIQUE a...
asked by 24.10.2018 / 00:52
1
answer

Query mysql in phpmyadmin

Good afternoon guys, can anyone help me please? I have two tables, Tabela1 and Tabela2 , I would like to insert data from column carro of Tabela2 into column carro of Tabela1 , but in their respective i...
asked by 25.10.2018 / 19:02
2
answers

Error with function $ _GET

My question is the following, I have the page criareditarevento.php that updates information from a registration system, however I need to make the update message open inside the page main.php which is the page where it has the...
asked by 14.06.2014 / 01:32
1
answer

How to group data per week in mysql [closed]

I am extracting some data and want to know some way to group the data by week. I am giving SELECT and it is bringing the data from last month and I am already grouping by day, but I need it to be per week.     
asked by 17.10.2018 / 15:24
1
answer

Error when listing bank data

You are giving the following error:    Notice: Undefined variable: report in C: \ xampp \ htdocs \ nise \ general.php   online 262       Warning: Invalid argument supplied for foreach () in   C: \ xampp \ htdocs \ nise \ general.php on line...
asked by 16.10.2018 / 19:11
2
answers

Changes directly in the database reflect in the managed bean?

I'm developing a simple web application, a form. I did the DAO's, Facades and they are working correctly (at least I think they are) but I will also need to edit some values directly in the bank only these changes are not being reflected in the...
asked by 06.02.2014 / 20:37