MySQL:如果存在...截断

Question

想要截断一个存在的表:

IF EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'mytable') TRUNCATE mytable

错误:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'mytable') ' at line 1

我也尝试在 ) 之后添加 THEN，但问题似乎出在 IF 处。

Answer 1

您需要以下两个语句来执行此操作:

create table if not exists <mytable>;

truncate table <mytable>;