Getting an error when I try to insert data into my .db file

Question

I haven't done much on databases ever but I am now required to do so for University. I have built a schema which can be found below and also made a data.sql file to inset so data. I'm getting the error "Error: near line 1: Near NULL: Syntax error", but I can't see what the issue is, I know it will be something simple which I have done wrong but I would appreciate the help. Thank you.

Schema.sql

DROP TABLE users;
CREATE TABLE users(id integer primary key, username varchar(30), password varchar(30), email varchar(50), receive_email blob, gender varchar(6));

DROP TABLE lists;
CREATE TABLE lists(id integer primary key, user_id integer, list_id integer, name varchar(50), creation_date datetime, importance integer, completed blob);

DROP TABLE list_item;
CREATE TABLE list_item(id integer primary key, list_id integer, name varchar(50), creation_date datetime, completed blob);

data.sql

INSERT INTO users(NULL, "kieran", "password", "[email protected]", "1", "male");
INSERT INTO users(NULL, "test", "testpassword", "test_email", "0", "female");

Thank you in advance.

laalto · Accepted Answer · 2015-01-27 11:02:37Z

1

Looks like you want to have VALUES there, e.g.

INSERT INTO users VALUES(NULL, ...

Otherwise you'd be specifying the columns to insert into, and NULL is not a valid column name.

answered Jan 27, 2015 at 11:02

laalto

153k68 gold badges293 silver badges306 bronze badges

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

1 Comment

Kieran Lavelle Over a year ago

Thank you, I knew it would be something simple like that. I'll accept as soon as I can.

Collectives™ on Stack Overflow

Getting an error when I try to insert data into my .db file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related