Questions tagged as 'mysql'

Tagged questions
1
answer

Ajax is returning an array and now, how to separate?

My Ajax request is returning 3 records from a PHP query (yes, I'm sure), so we have arrays of type: array 1 ["João", "19/05/1986", "masculino", "Programador", "Campo Grande"] array 2 ["Maria", "15/05/1988", "feminino", "Enfermeira", "Londres"]...
asked by 04.08.2014 / 14:31
1
answer

Returning NULL

I'm using this query: SELECT GROUP_CONCAT(coluna1) as valores FROM arquivos WHERE coluna2 IN (21, 22) It returns the values in column1 of rows whose column2 has one of the values specified. The problem is that in this case, the value 21...
asked by 22.07.2014 / 16:23
1
answer

Update with inner query selecting the same table

I have the following query: UPDATE cp_feedback_trabalho as a SET a.visivel = 1 WHERE a.dhEnvio IS NOT NULL AND EXISTS ( SELECT b.id FROM cp_feedback_trabalho as b WHERE b.id_pessoa_que_enviou = a.id_...
asked by 30.07.2014 / 01:32
2
answers

Strange (green) code coming back from the database

I have the following PHP query $mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE); $mysqli-> set_charset("utf8"); $stmt = $mysqli->prepare("select header, title, footer, head from configs"); $stmt -> execute(); $stmt -> bind_...
asked by 29.07.2014 / 14:45
1
answer

How to fill a textbox with a MySQL LIKE?

I'm trying to fill in the textbox, when the client is typing the initials of their name, the select goes into the bank and tries to fetch the information. However, I have no idea how to command I'll show you how my View is and my DAL. View...
asked by 25.09.2014 / 18:44
1
answer

Take action when closing browser

I have a system that marks whether the person is available or unavailable . There is a button called exit . If the person clicks on it when it is available, then it automatically changes the status of the database to unavailable. Only some s...
asked by 25.09.2014 / 17:39
1
answer

SQL help to add daily between dates

I have two tables: company and truck In the table, I have the data entry fields, datasaida, valordiaria I would like to select all the companies, and list it and the total amount that the company spent on daily, only if the datasaida is diffe...
asked by 09.07.2014 / 22:28
1
answer

View [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]

About VIEW in database ... What is the difference between the three algorithms when creating a VIEW with [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] ? What does each one do?     
asked by 18.09.2014 / 15:18
1
answer

Problem with accentuation cURL

I have a code where I send data via cURL to another page inside the server, but I have a problem ... When sending this data to the other page, it inserts into MySQL only when viewing the record inserted in the MySQL all words after any ac...
asked by 31.08.2014 / 23:48
1
answer

Implementation relationship n for n in Delphi

Maybe it's simple for most, but I would like to know how to implement a n-to-n relationship between Mysql tables using Delphi. I created the diagram of my DB in MySQL Workbench, I created the DB, all right. My question is: do the tables creat...
asked by 30.08.2014 / 13:23