Questions tagged as 'mysql'

Tagged questions
3
answers

Use reference in MYSQL query condition

I am doing a query to calculate the balance and after calculated I want it to only bring the products whose balance is equal to 0 so I tried to assign the total value using AS only when I went to make the condition in WHERE...
asked by 15.05.2015 / 15:21
1
answer

Import .csv files to MySql WorkBench

I have a .csv file that in column A I have:    Product1    Product2    ...    In column B I have:    1    2    ...    If you want to, for example, insert column 1 in line 1 of Produt1 as I proceed in the script? And what kind...
asked by 13.06.2015 / 01:47
4
answers

Error in SQL like

I'm trying to do a select where I want all the data from a person who has the same ip and date equals today's date. The reason is that I need to restrict how many times a person sends contact to my system. below my code. $ip = $_SER...
asked by 23.06.2015 / 19:55
2
answers

Search PHP / MySQL (show only result exactly the same as typed)

php collects input data using POST method. He is connected right, he is searching, but when typing the UF and Municipality he does not only show me exactly what I typed, but also the related ! I did not know what to do, but I did not know what...
asked by 30.03.2016 / 02:09
1
answer

Problem with join query with 5 tables

Good evening, I'm trying to do a join to 5 tables to get me the information so that it is not returning any data to me. Code SELECT * FROM estabelecimentos INNER JOIN estabelecimentos_anexos ON estabelecimentos_anexos.id_mae = estab...
asked by 24.03.2015 / 23:57
2
answers

How to write multiple records to a table at the same time MySQL [duplicate]

I need to write multiple records at once in MySQL for example. I have the PRODUTOS , CATEGORIAS tables and a third table that lists the two and also a form where I select the category and mark all the checkboxes of the products...
asked by 15.03.2015 / 15:51
1
answer

How to organize BDados results

Hello, I'm doing a movie site and would like some help on that part. After getting connection to DB, I want every record to appear within the grid I made. I'll explain it better with photos. Eachmoviehasitsrecordcontainingeveryinforma...
asked by 25.02.2015 / 13:37
1
answer

MySQL table clause or alias

I have a table in MySQL that has a wrong name, this table is already used by many applications, so it would not be very easy to rename it. Is there any way to create a alias for this table or a clone so that everything do...
asked by 20.01.2016 / 11:38
1
answer

Correctly insert data into table

I'm having serious problems with INSERT of PDO , I can not add values correctly to banco de dados , how do I do this? Problem Image: Ilookforwardtohelpingyou.<?phpif(isset($_POST['btn-send-ticket'])){$name=filter_input(...
asked by 28.01.2016 / 22:19
3
answers

Create a trigger that is executed whenever a product is deleted

How to create a trigger that is executed whenever a product is deleted by performing the deletion action on all batches related to the deleted product. Here's my SQL code: create database provafinal; use provafinal; create table prod...
asked by 26.11.2014 / 17:36