what is the following error in H2 database? And how to resolve the error?

Question

When I am creating a table in H2 database, as following:

CREATE TABLE data2 (end_lat DOUBLE, end_lng DOUBLE, member_casual CHAR(7) unique, 
                    month INTEGER, week INTEGER, day INTEGER, Year INTEGER,
                    day_of_week CHAR(10), tod TIME, ride_length INTEGER);

Then I am getting the error as below,

Syntax error in SQL statement "CREATE TABLE data2 (end_lat DOUBLE, end_lng DOUBLE, member_casual CHAR(7) unique, \000d\000a\0009\0009\0009\0009\0009[*]month INTEGER, week INTEGER, day INTEGER, Year INTEGER,\000d\000a\0009\0009\0009\0009\0009day_of_week CHAR(10), tod TIME, ride_length INTEGER)"; expected "identifier"; SQL statement:
CREATE TABLE data2 (end_lat DOUBLE, end_lng DOUBLE, member_casual CHAR(7) unique,
                    month INTEGER, week INTEGER, day INTEGER, Year INTEGER,
                    day_of_week CHAR(10), tod TIME, ride_length INTEGER) [42001-214] 42001/42001 (Help)

When I tried to create a table as following,


CREATE TABLE data2 (end_lat DOUBLE, end_lng DOUBLE, member_casual CHAR(7) unique, 
                    month INTEGER, week INTEGER, day INTEGER, Year INTEGER,
                    day_of_week CHAR(10), tod TIME, ride_length INTEGER);

I was expecting it to create a table as it worked for me when I tried it in MySQL.

Appreciate it, if anyone can help me resolve this.

Remove excess CR/LF/TAB characters before day_of_week column definition. — Akina
– Akina, Commented Nov 3, 2022 at 6:11

Rahul Garigipati · Accepted Answer · 2022-11-03 06:37:48Z

1

Answering to my own question

After changing the names of the column definition's to the following:

CREATE TABLE data2 (end_lat DOUBLE, end_lng DOUBLE, member_casual CHAR(7) not null unique, month_is INTEGER, week_is INT, day_is INTEGER, year_is INTEGER, day_of_week CHAR(10), tod TIME, ride_length INTEGER);

It Helped me resolve the error.

answered Nov 3, 2022 at 6:37

Rahul Garigipati

213 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Maurice Perry Over a year ago

Yes. Or

CREATE TABLE data2 ( 	end_lat DOUBLE PRECISION, 	end_lng DOUBLE PRECISION, 	member_casual CHAR(7), 	"month" INTEGER, 	week INTEGER, 	"day" INTEGER, 	"year" INTEGER,      day_of_week CHAR(10),      tod TIME,      ride_length INTEGER);

vs777 Over a year ago

So what was the error?

Collectives™ on Stack Overflow

what is the following error in H2 database? And how to resolve the error?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related