介绍 <李> mysql>, select *,得到students_bak;
+ - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +
| |,sid sname , |, gender | dept_id |
+ - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +
|,101,|,zhangsan |, male , |,,, 10 |
|,,1,|,aa ,,, |, 1,,, |,,,, 1 |
+ - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +
2,rows set 拷贝;(0.00,sec)
mysql>, truncate table students_bak;
Query 好吧,,0,rows affected (0.16,秒)
mysql>, select *,得到students_bak;
Empty set (0.00, sec)
mysql>, set =关闭自动提交功能;
Query 好吧,,0,rows affected (0.01,秒)
mysql>, select *,得到students3;
+ - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +
| |,sid sname |, gender |, dept_id | sname2 |
+ - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +
|,100,|,NULL |, 1,,, |,,,, 1, |, NULL |
+ - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +
1,row set 拷贝;(0.01,sec)
mysql>, truncate table students3;
Query 好吧,,0,rows affected (0.06,秒)
mysql>,回滚;
Query 好吧,,0,rows affected (0.00,秒)
mysql>, select *,得到students3;
Empty set (0.00, sec)
mysql>, delete 得到;学生;
Query 好吧,,5,rows affected (0.00,秒)
mysql>, select *,得到学生;
Empty set (0.00, sec)
mysql>,回滚;
Query 好吧,,0,rows affected (0.07,秒)
mysql>, select *,得到学生;
+ - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +
| |,sid sname |, gender | dept_id |
+ - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +
|,,1,|,aa , |, 3,,, |,,,, 1 |
|,,4,|,cc , |, 3,,, |,,,, 1 |
|,,5,|,dd , |, 1,,, |,,,, 2 |
|,,6,|,aac , |, 1,,, |,,,, 1 |
|,10,|,a ,, |, 1,,, |,,,, 1 |
+ - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +
5,rows set 拷贝;(0.00,sec)
如何在MySQL中使用截断表语句?针对这个问题,这篇文章详细介绍了相对应的分析和解答,希望可以帮助更多想解决这个问题的小伙伴找到更简单易行的方法。
截断表语句用来删除/截断表里的所有数据
和删除删除所有表数据在逻辑上含义相同,但性能更快
<李>类似执行了删除表和创建表两个语句
关于如何在MySQL中使用截断表语句问题的解答就分享到这里了,希望以上内容可以对大家有一定的帮助,如果你还有很多疑惑没有解开,可以关注行业资讯频道了解更多相关知识。
