Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How to remove the MYSQL records that were created more than 3 minutes ago?

J
jules last edited by
I'm not strong on dates. The table contains a field with a recording date (mydate) in TIMESTAMP.
Should we remove the records that were created more than 3 minutes (180 seconds) ago?
```
DELETE FROM table WHERE NOW() - mydate > 180
```
It doesn't work. ♪ ♪
Reply Quote 0
1 Reply Last reply
Z
zymir last edited by
This should solve the problem:
```
DELETE FROM table WHERE  mydate < (NOW()  - INTERVAL 3 MINUTE) 
```
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

N

Remove from MySQL as json's mass
Software Programming • php mysql json • • nishika

2

0
Votes

2
Posts

0
Views

C

What's the problem?$array = array( 'akk' => array( array(1, 'Dmitry', 'Novickov'), array(2, 'Evgenuy', 'Novickov') ) ); echo json_encode($array); //Выведет: {"akk":[[1,"Dmitry","Novickov"],[2,"Evgenuy","Novickov"]]}
T

Total confusion with SQL in Builder C++
Software Programming • sql c+++ c++builder • • tahishae

2

0
Votes

2
Posts

0
Views

O

Query1->SQL->Add("SELECT * FROM Table1 WHERE \"Tip pribora\" LIKE 'Не пройдена' ORDER BY Ceh"); or whatever it is that C screens the skirts.
Remove the duplicate OBD records from mySQL
Software Programming • php mysql • • morde

2

0
Votes

2
Posts

0
Views

C

On the pole name, find all the matching names, and remove the extra ones, leaving only one last in the id, the record. And write the results into a new table.It's smarter to do it back.-- записать желаемое в новую таблицу INSERT INTO table2 (id, name, ...) SELECT t1.id, t1.name, ... FROM table1 t1 JOIN ( SELECT MAX(t11.id) id, t11.name FROM table1 t11 GROUP BY t11.name ) sq ON t1.id=sq.id AND t1.name=sq.name; -- очистить старую таблицу TRUNCATE table1; -- скопировать в неё только нужные записи INSERT INTO table1 (id, name, ...) SELECT id, name, ... FROM table2;
MySQL = MariaDB?
Software Programming • mysql mariadb databank • • irl

2

0
Votes

2
Posts

0
Views

Your teacher is wrong, MariaDB is compatible in many things with MySql, but it is nothing renamed, it is another bank anyway, can be even considered a fork of mysql, since it was created by the same developer of mysql.That is projects the part, both receive updates, improvements and corrections independent of each other.Most simple bank structures created for Mysql can work on MariaDB and vice versa (with one or other adjustments sometimes being required). O MariaDB if I am not mistaken have support for innoDB and myIsam, same engines used in mysql, but also has a motor called https://mariadb.com/kb/en/library/xtradb-and-innodb/ (note that although it is not standard in Mysql it is possible to use it on it too, but this is another story).MySql now belongs to company https://www.oracle.com/ and is still maintained and continues to be developed and has evolved a lot since it turned a product of it, already mariaDB is maintained by companies MariaDB Corporation Ab and MariaDB Foundation (as per wikipedia).The following link contains the incompatibilities between both (from MariaDB 5.1 and MySQL 5.1): https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ Incompatibility in MariaDB 10.2 and MySQL 5.7 versions (which are the latest ones): https://mariadb.com/kb/en/library/incompatibilities-and-feature-differences-between-mariadb-102-and-mysql-57/ A brief summary of the story of why MariaDB was bornMysql was created by Michael "Monty" Widenius and David Axmark, a https://en.wikipedia.org/wiki/Sun_Microsystems acquired the company https://en.wikipedia.org/wiki/MySQL_AB , thus acquiring the product mysql, Michael. initially worked for them, but was dissatisfied, I do not know whether it was with the result of the project or with the company itself, and so left the Sun.A Sun which was founded in 1982 then was absorbed by the company https://www.oracle.com/ between 2009 and 2010, thus leaving existence and the products that belonged to it, as Java and Mysql, they belonged to https://www.oracle.com/ .In 2009 even Monty (Michael) created a fork (Copy.) of Mysql giving this system the name of his daughter, Mary, and so was born MariaDB.In mid 2012 Monty (Michael) together with David created the company https://en.wikipedia.org/wiki/MariaDB FinishingMysql and MariaDB can be compatible in almost everything, but have several incompatibilities currently.Mysql is maintained and continues to evolve by the "hands" of Oracle.MariaDB is maintained and continues to evolve by the "hands" of MariaDB Corporation Ab and MariaDB Foundation.Both are currently developed by different companies without any connection and I believe that we can consider both competing systems.
K

Create Table with 3 rows then create another table with 3 more rows
Software Programming • php html mysql • • kalena

2

0
Votes

2
Posts

0
Views

D

Perform a query in your bank using distinct ( https://www.w3schools.com/sql/sql_distinct.asp ) to pull all groups.SELECT DISTINCT NOME_CHAVE FROM Grupos_Sorteados We'll have an array with all the championship groups, just play it inside a foreach and within it perform a select looking for teams from that group. You can take advantage of this SQL command by adding in the end:WHERE G.NOME_CHAVE = {{ aqui vem a variavel com nome do grupo do foreach }} I think there'd be something like that:<?php foreach($grupos as $grupo): ?> <p>Grupo: <?php echo $grupo["NOME_CHAVE"] ?> </p> <table id="tabelaEquipe" class="table table-borderless table-striped table-earning"> <thead> <tr> <th>Equipe</th> </tr> </thead> <tbody> <?php $sql = "SELECT E.ID_EQUIPE, E.NOME FROM Grupos_Sorteados AS G INNER JOIN Equipe AS E ON G.ID_EQUIPE = E.ID_EQUIPE WHERE G.NOME_CHAVE = {$grupos}"; $resultado = mysqli_query($conn, $sql); while($dados = mysqli_fetch_array($resultado)): ?> <tr> <td><?= $dados['NOME'] ?></td> </tr> <?php endwhile; ?> </tbody> </table> <?php endforeach; ?> A suggestion is then to place the points on the side of the team name.
automatic insert in table B when a record is inserted in table A if the number field exists and table c
Software Programming • mysql trigger base de datos • • Analeea

2

0
Votes

2
Posts

0
Views

K

your problem can be solved with a triggerThis contains x instructions and is called when a update, create or delete is done in the table we choose.CREATE TRIGGER Nombre_trigger ON Tabla A AFTER INSERT AS IF EXISTS(select * from Tabla C where patente == INSERTED.patente ) BEGIN INSERT INTO Tabla B (patente, salida, numero) VALUES (INSERTED.patente, INSERTED.salida, INSERTED.numero) END already only add the condition that it exists in Table C to be inserted in Table BThe table inserted from where it took the data to insert them in Table B is a temporary table that contains the values that are inserted (INSERTED), update (DELETED + INSERTED) or delete (DELETED).Updating consists of 2 tables since in the update process you have to remove the existing then insert the updated data.As for the word "AFTER" indicates when the trigger was executed, the most common being "AFTER" and "BEFORE".
N

How to remove a record from a collector?
Software Programming • laravel eloquent • • nishika

2

0
Votes

2
Posts

0
Views

J

The error could be in the variable $colonia (you can't see the value in the example presented)As if $colonia is null, or has a value not contained in any condition, all promotions will be eliminated.
O

Difference beetween mysql 5.5 and 5.6
SQL, Database Testing • mysql database rec languageomme • • Oba22

2

0
Votes

2
Posts

0
Views

K

EXPLAIN the SELECT subquery. (This will workaround the point that jynus brought up.) Your KEY vigi_unique can be made somewhat better by adding id onto the end of it. This will change the EXPLAIN to say "Using index" because it will be a "covering index". But the real reason for 5.6 to be faster is ... The subquery is after "LEFT JOIN", so 5.5 evaluates it over and over (I think), and 5.6 will create an INDEX (on the fly) for the subquery. Suggest using EXPLAIN FORMAT=JSON SELECT ... on 5.6 to see a little more. You should consider moving to InnoDB. Another way to "dedup" is to create a new table (with a UNIQUE index to prevent future dups), populate it with INSERT ... SELECT DISTINCT ..., then RENAME TABLE to move it into place.
C

Optimal Hardware for > 30K Requests / min?
SQL, Database Testing • mysql performance optimization memory mysql 5.7 • • Cleofas

2

0
Votes

2
Posts

0
Views

N

500 inserts per second is definitely into the area where out-of-the-box MySQL begins to have trouble. Some things to do: Don't trust benchmarks; use your code. Combine one-row INSERTs into transactions. (Much of what is limiting you to 500qps is the transaction overhead. "Batch" inserts -- 100-1000 rows per INSERT statement gives you 10x performance improvement. Use LOAD DATA -- also 10x (maybe more). Switch to SSDs -- perhaps 10x faster than spinning drives. innodb_flush_log_at_trx_commit=2 -- much faster, but less secure in a crash. Decrease the number of indexes, especially UNIQUE, on the table. Do not use UUIDs. Gather data some other way (eg, MyISAM table with no indexes), then batch INSERT...SELECT.... This has the added advantage of giving you a change to efficiently do ETL transformations. My High Speed Ingestion technique. It involves ping-ponging between two staging tables and handles various variations (multiple connections, etc)
T

Two Select Condition within the same query
Software Programming • mysql sql • • tahishae

2

0
Votes

2
Posts

0
Views

R

What you want cannot be done, what you have to get is a list with all the phones and next to the field where you see if the prize has been used or not. You'd have to do that.SELECT User.Telefono, Premio.utilizado FROM User LEFT JOIN `Premio` ON `User`.id = Premio.user_id WHERE Premio.utilizado = 1;
Relating one table to another 5
Software Programming • sql • • emmalee

2

0
Votes

2
Posts

0
Views

P

According to what I understand from your question, what you have to do is create a seat and relate it to the other tables, being able to filter by some label or type:Asientos (id, debe, haber, descripcion, etiqueta ) tipo (id, nombre, codigo, saldo, asiento) grupo (id, nombre, codigo, saldo, asiento, id_tipo) cuenta (id, nombre, codigo, saldo, asiento, id_grupo) sub_cuenta (id, nombre, codigo, saldo, asiento, id_cuenta) auxiliar (id, nombre, codigo, saldo, asiento, id_sub_cuenta) where seat is your foreign keyNow if you can't modify those tables for any particularity, you can create a table that relationshipsasientos_relaciones( asiento, codigo_foraneo, etiqueta)
Duplica records in mysql
Software Programming • php mysql • • Analeea

2

0
Votes

2
Posts

0
Views

You need to return the result of your query in the "connect_bd" function. If the INSERT was a success, you deploy the message of success, but you unload another message saying what the error was.function conectar_bd($query) { $DB_SERVER = "serverdb.cfe.mx"; $DB_USER = "jair"; $DB_DATABASE = "dbIPs"; $DB_PWD = "123"; $conn=mysqli_connect($DB_SERVER, $DB_USER,$DB_PWD, $DB_DATABASE); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n" , mysqli_connect_error()); exit(); } $result=mysqli_query($conn,$query); if ($result) return 'Success'; } else { return 'Failure' } } You also have to change these lines: conectar_bd($insert) ; echo "<center><br>Dirección IP dada de alta corectamente<br></center>"; This is why: $result = conectar_bd($insert) ; if ($result == 'Success') { echo "<center><br>Dirección IP dada de alta corectamente<br></center>"; } else { echo "<center><br>Dirección IP dada ya existe<br></center>"; }
SQL SERVER Syntax error in command set I have confusion between the simple and the double quote
Software Programming • sql server sql • • Marcee

2

0
Votes

2
Posts

0
Views

R

Try it the following way: SET @Script = 'INSERT INTO base.dbo.otroarchivo SELECT ''campo título''+ , COUNT (*) AS [campo1] FROM base.[dbo].[archivo2], ''+ archivo + ''WHERE ((Cantidad_del campo > 0) AND (TIPO = ''J''))'
S

Can I use blob data with Bundle on Android?
Software Programming • mysql android ec languagelipse • • simrah

2

0
Votes

2
Posts

0
Views

S

You can do it the way you indicate, but you should preferably https://es.stackoverflow.com/questions/18296/para-enviar-una-imagen-a-un-webservices-debo-codificarla-a-base64/18332#18332 :String imagenCodificada = Base64.encodeToString(byteArrayImage, Base64.DEFAULT); Personally to avoid memory problems or corrupt data, I prefer to send in Intent the image url, or even save in database the url.
F

Removal of line from MySQL table
Software Programming • php mysql • • fbio

2

0
Votes

2
Posts

0
Views

$res = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}tasks` WHERE user NOT IN ($user_id) AND status=1 AND ORDER BY RAND() LIMIT 1 ;", ARRAY_A); // select id from, а не select * from зачем тбе лишние поля??? foreach($res as $key) $idZad = $key['id']; // зачем здесь foreach? если ты тащишь всего одо значение? Выведет строку с уникальным id. Нужно проверить есть ли в другой таблице $pr = $wpdb->get_results("SELECT progress FROM `{$wpdb->prefix}completed` WHERE id_user=$user_id AND id_task=$idZad", ARRAY_A); foreach($pr as $progress) $progress = $progress['progress']; // зацикливается наверно тут? $progress потом опять ты ему присваиваешь значение его же, что за бред-то? Тут условие срабатывает? хоть как нибудь? первое или после else? if ($progress!=1) { //выполняем скрипт дальше. } else { //нужно следующую запись проверить }// ну проверил ты запись, и где дальше код который проверяет далее идти или не идти? There's something here with a logic of churo and a pasmoorno, I don't understand. Too much code for such a simple thing.

How to remove the MYSQL records that were created more than 3 minutes ago?

Suggested Topics

Remove from MySQL as json's mass Software Programming • php mysql json • • nishika

Total confusion with SQL in Builder C++ Software Programming • sql c+++ c++builder • • tahishae

Remove the duplicate OBD records from mySQL Software Programming • php mysql • • morde

MySQL = MariaDB? Software Programming • mysql mariadb databank • • irl

Create Table with 3 rows then create another table with 3 more rows Software Programming • php html mysql • • kalena

automatic insert in table B when a record is inserted in table A if the number field exists and table c Software Programming • mysql trigger base de datos • • Analeea

How to remove a record from a collector? Software Programming • laravel eloquent • • nishika

Difference beetween mysql 5.5 and 5.6 SQL, Database Testing • mysql database rec languageomme • • Oba22

Optimal Hardware for > 30K Requests / min? SQL, Database Testing • mysql performance optimization memory mysql 5.7 • • Cleofas

Two Select Condition within the same query Software Programming • mysql sql • • tahishae

Relating one table to another 5 Software Programming • sql • • emmalee

Duplica records in mysql Software Programming • php mysql • • Analeea

SQL SERVER Syntax error in command set I have confusion between the simple and the double quote Software Programming • sql server sql • • Marcee

Can I use blob data with Bundle on Android? Software Programming • mysql android ec languagelipse • • simrah

Removal of line from MySQL table Software Programming • php mysql • • fbio

Remove from MySQL as json's mass
Software Programming • php mysql json • • nishika

Total confusion with SQL in Builder C++
Software Programming • sql c+++ c++builder • • tahishae

Remove the duplicate OBD records from mySQL
Software Programming • php mysql • • morde

MySQL = MariaDB?
Software Programming • mysql mariadb databank • • irl

Create Table with 3 rows then create another table with 3 more rows
Software Programming • php html mysql • • kalena

automatic insert in table B when a record is inserted in table A if the number field exists and table c
Software Programming • mysql trigger base de datos • • Analeea

How to remove a record from a collector?
Software Programming • laravel eloquent • • nishika

Difference beetween mysql 5.5 and 5.6
SQL, Database Testing • mysql database rec languageomme • • Oba22

Optimal Hardware for > 30K Requests / min?
SQL, Database Testing • mysql performance optimization memory mysql 5.7 • • Cleofas

Two Select Condition within the same query
Software Programming • mysql sql • • tahishae

Relating one table to another 5
Software Programming • sql • • emmalee

Duplica records in mysql
Software Programming • php mysql • • Analeea

SQL SERVER Syntax error in command set I have confusion between the simple and the double quote
Software Programming • sql server sql • • Marcee

Can I use blob data with Bundle on Android?
Software Programming • mysql android ec languagelipse • • simrah

Removal of line from MySQL table
Software Programming • php mysql • • fbio