我在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);