December 15, 2022H2 Schema Initialisation Syntax Error in Sql StatementApplication Startup error:But I got ‘Syntax error in SQL statement’ on application startup:Error:19:08:45.642 6474 [main] INFO o.h.tool.hbm2ddl.SchemaExport - HHH000476: Executing import script '/import.sql' 19:08:45.643 6475 [main] ERROR o.h.tool.hbm2ddl.SchemaExport - HHH000388: Unsuccessful: CREATE TABLE Person ( 19:08:45.643 6475 [main] ERROR o.h.tool.hbm2ddl.SchemaExport - Syntax error in SQL statement "CREATE TABLE PERSON ( [*]"; expected "identifier" Syntax error in SQL statement "CREATE TABLE PERSON ( [*]"; expected "identifier"; SQL statement:Solution:CREATE TABLE IF NOT EXISTS `Person` ( `id` INTEGER PRIMARY KEY AUTO_INCREMENT, `first_name` VARCHAR(50) NOT NULL, `age` INTEGER NOT NULL ); Like this:Like Loading...Related Exceptions h2-schema-initialization-syntax-error-in-sql-statementjavajava exceptionSQL