The Truncate table statement is used to delete/truncate all data in the table.
Executing Code mysql> select * from students_bak; +-----+----------+--------+---------+ | sid | sname | gender | dept_id | +-----+----------+--------+---------+ | 101 | zhangsan | male | 10 | | 1 | aa | 1 | 1 | +-----+----------+--------+---------+ 2 rows in set (0.00 sec) mysql> truncate table students_bak; Query OK, 0 rows affected (0.16 sec) mysql> select * from students_bak; Empty set (0.00 sec) mysql> set autocommit=off; Query OK, 0 rows affected (0.01 sec) mysql> select * from students3; +-----+-------+--------+---------+--------+ | sid | sname | gender | dept_id | sname2 | +-----+-------+--------+---------+--------+ | 100 | NULL | 1 | 1 | NULL | +-----+-------+--------+---------+--------+ 1 row in set (0.01 sec) mysql> truncate table students3; Query OK, 0 rows affected (0.06 sec) mysql> rollback; Query OK, 0 rows affected (0.00 sec) mysql> select * from students3; Empty set (0.00 sec) mysql> delete from students; Query OK, 5 rows affected (0.00 sec) mysql> select * from students; Empty set (0.00 sec) mysql> rollback; Query OK, 0 rows affected (0.07 sec) mysql> select * from students; +-----+-------+--------+---------+ | 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 in set (0.00 sec) What permissions does truncate need?The execution of truncate is drop first and then create, so truncate includes drop and create, which is a compound action. You don't need to grant create permission, so you only need to grant drop permission. This is the end of this article about the use of MySQL truncate table statement. For more relevant MySQL truncate table content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future! You may also be interested in:
|
>>: Detailed explanation of eight methods to achieve CSS page bottom fixed
How to recursively select all child elements usin...
1: Check the PHP version after entering the termi...
Table of contents Preface Introduction ngram full...
Table of contents 1. Decoupled assignment of arra...
Everyone has played the pinball and brick-breakin...
While working on a Linux server, assigning static...
Docker Installation There is no need to talk abou...
For .net development, I am more familiar with Mic...
Table of contents background Provide / Inject Ext...
Method 1: Use lsof command We can use the lsof co...
1. Window -> preferences to open the eclipse p...
It took me half an hour to write the code, and th...
What products do you want to mention? Recently, t...
view: Views in MySQL have many similarities with ...
Every time I design a web page or a form, I am tr...