Questions tagged as 'mysql'

Tagged questions
1
answer

Mysql Event Scheduler needs super privileges

Good morning, I have a website hosting in a company, I created a very simple system that through an event that runs of a certain time in a certain time and makes changes in the elements of the database (in this case it changes the field "state"...
asked by 30.05.2015 / 14:07
1
answer

How to change the format of a direct column in MySQL LOAD INFILE?

Hello, I have an 'x' table, with the Value column, in DECIMAL, in a MySQL 9 database. I need to import data into csv. I do this using LOAD INFILE. In these CSVs, the value is in a comma-like format, for example, "1938.20". To import in t...
asked by 01.06.2015 / 22:40
1
answer

Problem with select dynamic to show dropdown menu for user

I am building the visualization layer for the clients of a system in my database I have two tables with relationships: Ihaveamethodtoreturntheresultsofthesetables:publicfunctiondropDownCategoria(){$consulta=PDOUtil::getStance()->prepare("SELE...
asked by 14.06.2015 / 20:38
1
answer

MySql - Update for null column unique

Good afternoon guys. I would like to know if it is possible to make a UPDATE to NULL where the field only allows UNIQUE values. I tried this way: update FUNCIONARIO set codigocartao = NULL where situacao = 'DESATIVAD...
asked by 03.06.2015 / 22:53
1
answer

Is it possible to include versioning of the database in commit (GIT)? [duplicate]

I would like to know if it is possible to version the database (in my case MySQL) through the GIT, or if there is any other effective way to do it.     
asked by 06.05.2015 / 14:37
1
answer

Generate php mysql database XML after query

How to generate an xml file from a database after a query and in sequence download it automatically?     
asked by 05.05.2015 / 03:05
2
answers

inner join display last status

I need to get data from 3 tables through a filter in 2 of them using the criteria Date and Status, the date being made in one table and the status in another. It happens that when more than one status with the same name it lists all, I would...
asked by 29.04.2015 / 18:19
1
answer

Display foreign keys from a table in the query

I have a table where every projeto can be related to up to 4 produtos . Main table (foreign keys): IDPRODUTO IDPRODUTO2 IDPRODUTO3 IDPRODUTO4 Table produtos ID N...
asked by 15.04.2015 / 00:36
1
answer

Problem with selection in MySql

I'm starting this business and having difficulty selecting more than one table. My selection command was as follows: Table 01: select * from veiculo; |id_veiculo|modelo|cor|placa|chassi|renavam|combustivel|ano|hp|id_proprietario|id_...
asked by 14.04.2015 / 00:56
1
answer

Check if any line of the Select result in Mysql contains a value

I would like to know how to check the where clause if any of the line has a certain number. For example: If a select returns 1 2 3 4 and in the request clause 4 it returns the values, if it returns 1 2 3 and in request clause 4 it retu...
asked by 16.04.2015 / 23:49