MySQL 删除表内部触发器

Question

CREATE TRIGGER trg_alis AFTER INSERT ON alis_acik_emirler
FOR EACH ROW
BEGIN

    DROP TABLE alis2;

    CREATE TABLE alis2 (
        emirID int NOT NULL AUTO_INCREMENT,
        userID int,
        fiyat int,
        adet int,
        doldurulan_adet int,
        kalan_adet int,
        market_tipi int,
        PRIMARY KEY(emirID)
    );

END;

1064 - 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 ''DROP TABLE alis2'' at line 6

我无法删除触发器内的表。我该怎么做？

DROP TABLE IF EXISTS alis2;

我试过了，但没用。

Answer 1

我无法找出您想要在触发器中删除表的充分理由。但是您正在删除并重新创建该表。也许您只想截断表/删除所有行:

delete a from alis2 a;

这将删除表中的所有行。