Questions tagged as 'mysql'

Tagged questions
4
answers

Get checkbox values in an array

How do I get the value of the checkbox in the code below? It is a presence list and this code I modified for one that I use a little different and this way I do not know how to get the values of checked checkboxes in order to be able to in ea...
asked by 18.10.2015 / 21:02
2
answers

Mysql, doubt about variables

Mysql allows you to use various types of syntax in the declaration of variables eg: declare i int unsigned default 0; set @str = "select "; Do you have any advantage in using one type or another, or some disadvantage or even some recommenda...
asked by 12.06.2015 / 21:07
2
answers

Problem to mount query

I can not mount a query, the logic is: Select produtos with categorias different, being the products with more points, thus I will have a product of more points of category X, another of category Y. I tried to use DISTINCT...
asked by 10.06.2015 / 19:53
1
answer

mysql + PHP - use or not use mysqli_close ()

I noticed now that I'm not using the mysqli_close() function indicated on the PHP.NET site I monitor the connections through Workbench client conections and do not get open connections, my question is if this way that I'm programmi...
asked by 02.09.2015 / 16:35
1
answer

Creating tables with PHP

Expensive; I have a problem and I need a little help. I have a page in html that contains some radio buttons. By clicking on a radio button and then the submit button, it redirects to a page in PHP that captures the value of the radio and wit...
asked by 14.09.2016 / 21:36
1
answer

How to remove the UNIQUE KEY attribute from a column in MySQL?

I created a table in MySQl that uses a column named loja_num with the unique key attribute UNIQUE KEY loja_num (loja_num, But now, I'd like to remove this attribute from this column. I've done some research without success. Does an...
asked by 18.09.2016 / 02:46
3
answers

Compare day and month of a date?

In MySQL I have saved the date of birth of a person, I need to set up a query to return the birthdays of the week, those that make today's birthday until today + 7 days. p> I'm trying like this: //Metodo da tela de listagem public fu...
asked by 28.10.2016 / 16:22
1
answer

MySQL is duplicating search result

I'm having a hard time putting up a query. I have a Database more or less in this structure. Table 1 Table 2 Table 3 Table 4 I need to set up a query that takes the results in the 4 tables, for this I used the LEFT JOIN, because in tabl...
asked by 28.10.2016 / 02:27
2
answers

Firedac: GetFieldNames without quotation marks

I'm retrieving the Firebird and Mysql tables by Firedac Connection through the command line GetFieldNames , however some fields in the list are returned with quotation marks. I have tried to insert the MetaDefCatalog=MySql...
asked by 15.12.2015 / 14:50
1
answer

How to group subtraction of equal fields in MySQL?

I need to make an appointment that returns the employee's current balance. Being that in my modeling I separate the debts and credits of the employee by the fields type 1 for credits and 2 for debits. My query is not bringing the t...
asked by 10.12.2015 / 21:56