我在Spring Boot应用程序上的import.sql文件有问题,但我不知道错误在哪里。我在控制台上收到以下错误:

2017-12-28 18:31:24.496[0;39m [31mERROR[0;39m [35m10866[0;39m [2m--
-[0;39m [2m[  restartedMain][0;39m
[36morg.hibernate.tool.hbm2ddl.SchemaExport [0;39m [2m:[0;39m HHH000388:
Unsuccessful: insert into convidado (id, nome, quantidade_acompanhantes)
[2m2017-12-28 18:31:24.496[0;39m [31mERROR[0;39m [35m10866[0;39m [2m--
-[0;39m [2m[  restartedMain][0;39m
[36morg.hibernate.tool.hbm2ddl.SchemaExport [0;39m [2m:[0;39m Syntax
error in SQL statement "INSERT INTO CONVIDADO (ID, NOME,
QUANTIDADE_ACOMPANHANTES) [*]"; expected "DIRECT, SORTED, DEFAULT, VALUES,
SET, (, WITH, SELECT, FROM"; SQL statement:
insert into convidado (id, nome, quantidade_acompanhantes) [42001-196]

最佳答案

INSERT语句用于将新行添加到数据库表中。

句法:

INSERT INTO table_name (Column 1, column 2)
VALUES (value 1, value2)


INSERT的示例:

INSERT INTO student (id, name, age)
VALUES (1, 'harry', 22);

10-06 04:53