Questions tagged as 'mysql'

Tagged questions
1
answer

How to make a query in the database 10 days ahead and 10 days behind the current date?

Today I can do the query 10 days ago as shown in the query below, I just can not deploy the 10 days ahead of the current date. SELECT 'vw_saldobancario'.'contaApelido', 'vw_saldobancario'.'tipoMovimento', 'vw_saldobancario'.'hist...
asked by 29.11.2018 / 15:09
1
answer

Repair on Checked Tables

Follow the code: status := DataModule1.ZQuery2.FieldByName('Msg_text').AsString; while not DataModule1.ZQuery1.Eof do begin if status <> 'OK' then begin DataModule1.ZQuery3.Close; DataModule1.ZQuery3.SQL.Clear;...
asked by 21.05.2014 / 15:57
2
answers

Query MySQL in PHP only works locally

It's as follows: the system I'm servicing was using two query types (do not ask me why) and locally (localhost) work perfectly. When I uploaded the project to the server, the queries declared like this: <?php $sql = mysql_query("INSERT INTO...
asked by 11.02.2014 / 18:21
1
answer

MySQL Execution Error - XAMPP

I'm trying to create a localhost with xampp , but MySQL does not start. Give this log mysql_error.log: 2015-11-10 15:26:56 10fc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in fu...
asked by 05.09.2018 / 23:29
1
answer

Database does not accept single quotes' when sending [duplicate]

I'm having a little problem where if on the form I type only a quotation mark 'it does not add to the database. Could someone tell me why and how could I fix this?    OBS¹: just with a quotation mark, if I close it with another quotation ma...
asked by 14.05.2018 / 19:07
1
answer

Error Netbeans 8.2 "java.sql.SQLException: Unknown system variable 'query_cache_size'"

I can not connect to a MySql database through the Netbeans IDE, the following error is reported: java.sql.SQLException: Unknown system variable 'query_cache_size'     
asked by 05.06.2018 / 18:04
0
answers

Detecting slow queries in Rackspace MySQL

Is there an easy way to see the slow queries in Rackspace's MySQL? I've tried these instructions , but they are very complicated ... Original post in English     
asked by 13.08.2014 / 01:49
1
answer

Error Entity Framework WPF Client

I installed my application in the client environment, but I'm getting the following error: Nome do Evento de Problema: CLR20r3 Assinatura do Problema 01: eLogBook.exe Assinatura do Problema 02: 1.0.0.0 Assinatura do Problema 03:...
asked by 10.02.2018 / 01:17
1
answer

DataStudio does not connect with restricted user Mysql

I created a new user in Mysql with restricted permissions for only one VIEW. (GRANT ALL ON banco.view TO 'user' @ 'localhost') When I try to connect to this user in DataStudio I get access denied. However, using the same user in any other too...
asked by 16.02.2018 / 18:45
2
answers

Update in database table

I have this code to make updat and field estad o as completed and be the only field that can be edited: <?php $servername = "xxx.xxx.x.xx"; $username = "xxxxx"; $password = "xxxxxxx"; $dbname = "xxxxxxxx";...
asked by 09.02.2018 / 16:20