当我在Spring引导中尝试在资源data.sql文件中创建值并将其插入表时,我得到以下错误:
"Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "SWISSFRANC" not found; SQL statement:
INSERT INTO conversion_value(id,currency_from,currency_to,Conversion_factor,port) VALUES (10001,swissfranc,INR,65,0) [42122-200]"
my data.sql file contains:
INSERT INTO conversion_value(id,currency_from,currency_to,Conversion_factor,port)
VALUES (10001,swissfranc,INR,65,0);
INSERT INTO conversion_value(id,currency_from,currency_to,Conversion_factor,port)
VALUES (10002,euro,INR,75,0);
INSERT INTO conversion_value(id,currency_from,currency_to,Conversion_factor,port)
VALUES (10003,australiandollar,INR,25,0);
在插入的值周围使用引号:'euro'
或'swissfranc'
等。这是data.sql
文件中的语法错误。固定示例:
INSERT INTO conversion_value(id,currency_from,currency_to,Conversion_factor,port) VALUES (10001,'swissfranc','INR',65,0);