Questions tagged as 'mysql'

Tagged questions
0
answers

Trigger in MYSQL to delete record when it exceeds a date

Hello, how could I create a Trigger that excludes database records that exceed the current system date?     
asked by 20.11.2017 / 20:20
1
answer

Clustering of Customers with LIMIT 10 per Store

Good morning, I have the following query for MYSQL 8: With Empresa as (Select aurea.oi, aurea.razao, aurea.fantasia From aurea Where aurea.id in ( 1302, 791, 2496, 1681, 1203 )), CapaPedido as (Select cpd.oi, cpd.cp_tipo, cpd.cp_codi, cp...
asked by 11.09.2017 / 18:02
1
answer

How to do an update on a table by traversing another table in Mysql? [closed]

I have a schematic according to the picture below: The goal is to update the values of the seller_comission column in the tbl_history table. The tbl_history table already has a few thousand records. The seller's commission is different for...
asked by 11.09.2017 / 14:48
2
answers

PHP / MySQL Select products below a value in the table

I need to select products with a value below 300 reais in which the situacao column is equal to 2 : Example: in the shopping table I have 8 products registered: 1 sapato valor 25 situacao 1 2 calça valor 50 situacao 2 3...
asked by 11.09.2017 / 19:09
0
answers

Unrecognized keyword. (near "ON" at position 25) in MySQL

I'm trying to import 13,000 records into my MySQL Database and I'm not getting it. Now it gives big file error that even reducing, continues without matter. I'm trying now from OpenDocument worksheets but is returning the error    Unrecogn...
asked by 11.09.2017 / 19:49
1
answer

Uncaught Error: Call to undefined function mysql_query () [duplicate]

I'm doing my login system and giving the following error when signing in:    Fatal error: Uncaught Error: Call to undefined function mysql_query () thrown in D: \ xampp \ htdocs \ login.php on line 41 if (isset($_POST['entrar']) &&am...
asked by 03.09.2017 / 00:44
1
answer

Error after 100 AJAX requests

I have the function below that makes a request every second to the MySQL database and updates a DIV on the page. But after more or less 100 requests the "I ACHIEVE" database blocks and returns "An error occurred in the ajax request". What could...
asked by 03.09.2017 / 02:59
2
answers

Get date-ref of different buttons

I've created a system where it displays data from a mysql table via the datable plugin. One of the data is a modal. The javascript code takes data-ref , which contains id . This id will be used in future% queries...
asked by 31.08.2017 / 22:59
0
answers

Display image stored in blob with PDO? [duplicate]

I have stored an image using the BLOB field of MySQL ( LONGBLOB ), but I can not display it in html : //Instanciando minha classe com PDO e fazendo um //SELECT de todos os dados da tabela, inclusive a imagem <?php $...
asked by 31.08.2017 / 22:29
1
answer

Problem executing SELECT on a table in phpmyadmin

I have several tables in my database, and until recently, there was no problem in any of them. I was able to quietly manage the whole bank by phpmyadmin. However, suddenly in one of the tables the query SELECT * stopped executing properly in php...
asked by 01.09.2017 / 15:57