MySQL：删除表、清空表内容操作

• 使用环境

  • MySQL：8.0.12
  • 测试表：test_table

• 删除数据表

  # 测试表：test_table
  
  # 语法：DROP TABLE <table_name>;
  DROP TABLE test_table;
  

• 清空数据表内容

  # 测试表：test_table
  """
  mysql> select * from test_table;
  +------+------+
  | ID   | Name |
  +------+------+
  |    1 | test |
  |    1 | test |
  +------+------+
  2 rows in set (0.00 sec)
  """
  
  # 方法一：delete
  # 语法：delete from <table_name>;
  delete from test_table;
  """
  mysql> delete from test_table;
  Query OK, 2 rows affected (0.00 sec)
  """
  
  # 方法二：truncate
  # 语法：truncate table <table_name>;
  truncate table test_table;
  """
  mysql> truncate table test_table;
  Query OK, 0 rows affected (0.00 sec)
  """
  
  # 语法：truncate <table_name>;
  truncate test_table;
  """
  mysql> truncate test_table;
  Query OK, 0 rows affected (0.00 sec)
  """