mysql - SQL查询找不到错误

Question

我有这个查询:

DECLARE @i int = 0
WHILE @i < 100 BEGIN
    SET @i = @i + 1
    INSERT INTO lottery (ticket, bought) VALUES (@i, false)
END

MySQL服务器

Error: Error Code: 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 'DECLARE @i int = 0 WHILE @i < 100 BEGIN
SET @i = @i + 1 INSERT INTO lott' at line 1

但是它说其中有错误，但没有说错误在哪里。我做错了什么？

Answer 1

你应该像这样放置第一行:

DECLARE @i int DEFAULT 0;