no SuRpRiSe18
si has hecho un borrado de la siguiente forma,
Código sql:
Ver originalmysql> SELECT *FROM usuarios;
+----------+------------+
| nombre | fecha_nac |
+----------+------------+
| diego | 1976-01-03 |
| jj | 1976-05-22 |
| jj | 1945-05-23 |
| jj | 1986-05-14 |
| daniel | 1984-11-12 |
| ruben | 2000-05-12 |
| arley | 1950-05-22 |
| maria | 1963-06-01 |
| mariaisa | 1978-06-01 |
| diana | 1984-06-01 |
| | 2009-06-01 |
| | 2009-06-01 |
| NULL | 2009-06-01 |
+----------+------------+
13 ROWS IN SET (0.05 sec)
mysql> DELETE FROM usuarios;
Query OK, 13 ROWS affected (0.02 sec)
No hay nada que hacer. (Eso creo)
Si lo haces así:
Código sql:
Ver originalmysql> SELECT *FROM usuarios;
+----------+------------+
| nombre | fecha_nac |
+----------+------------+
| diego | 1976-01-03 |
| jj | 1976-05-22 |
| jj | 1945-05-23 |
| jj | 1986-05-14 |
| daniel | 1984-11-12 |
| ruben | 2000-05-12 |
| arley | 1950-05-22 |
| maria | 1963-06-01 |
| mariaisa | 1978-06-01 |
| diana | 1984-06-01 |
| | 2009-06-01 |
| | 2009-06-01 |
| NULL | 2009-06-01 |
+----------+------------+
13 ROWS IN SET (0.05 sec)
mysql> START TRANSACTION;
Query OK, 0 ROWS affected (0.00 sec)
mysql> DELETE FROM usuarios;
Query OK, 13 ROWS affected (0.02 sec)
mysql> SELECT *FROM usuarios;
Empty SET (0.00 sec)
mysql> ROLLBACK;
Query OK, 0 ROWS affected (0.02 sec)
mysql> SELECT *FROM usuarios;
+----------+------------+
| nombre | fecha_nac |
+----------+------------+
| diego | 1976-01-03 |
| jj | 1976-05-22 |
| jj | 1945-05-23 |
| jj | 1986-05-14 |
| daniel | 1984-11-12 |
| ruben | 2000-05-12 |
| arley | 1950-05-22 |
| maria | 1963-06-01 |
| mariaisa | 1978-06-01 |
| diana | 1984-06-01 |
| | 2009-06-01 |
| | 2009-06-01 |
| NULL | 2009-06-01 |
+----------+------------+
13 ROWS IN SET (0.00 sec)
mysql>
Con
rollback se puede recuperar como se muestra en el ejemplo.
saludos