Delete all records in a MySQL database table

As a memorandum for beginners

Execute the following command to sign in

$ mysql -u root -p

Check the database name with the following command

mysql> SHOW databases;

Move to the database of the table you want to delete

mysql> use [Database name]

If you need to check the table name, execute the following command

mysql> SHOW tables;

Execute the following command after confirming the table name

mysql> TRUNCATE TABLE [table name];

In my case, I was able to delete all the records in the table by the above procedure. If you have a better way, I would appreciate it if you could comment.

Reference site https://qiita.com/nanatsu/items/33b57238b0e9ae0a1c78