truncate和delete對於復原的區別

標籤：truncate和delete對於復原的區別

         （1）delete在事務中可以復原

mysql>select * from t;

+----+

| id |

+----+

|  1 |

|  2 |

+----+

2 rows inset (0.00 sec)

 

mysql>begin;

Query OK,0 rows affected (0.00 sec)

 

mysql>delete from t where id=2;

Query OK,1 row affected (0.04 sec)

 

mysql>select * from t;

+----+

| id |

+----+

|  1 |

+----+

1 row inset (0.00 sec)

 

mysql>rollback;

Query OK,0 rows affected (0.01 sec)

 

mysql>select * from t;

+----+

| id |

+----+

|  1 |

|  2 |

+----+

2 rows inset (0.00 sec)

 

         （2）truncate在事務中不能復原

mysql>begin;

Query OK,0 rows affected (0.00 sec)

 

mysql>truncate table t;

Query OK,0 rows affected (0.03 sec)

 

mysql>rollback;

Query OK,0 rows affected (0.00 sec)

 

mysql>select * from t;

Empty set(0.00 sec)

 

mysql>

truncate和delete對於復原的區別