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
Recommended Posts