Insert syntax error

Question

I have this sql command in oledbcommand :

insert into tweets(iso_language_code,created_at,id_str,textbody,truncated,in_reply_to_status_id_str,in_reply_to_user_id_str,in_reply_to_screen_name,user,id_str1,username,screen_name,location,description,url,description1,followers_count,friends_count,listed_count,created_at1,favourites_count,utc_offset,time_zone,geo_enabled,verified,statuses_count,lang) values ('en','Tue Nov 05 234107 +0000 2013','397871229903716353','TrophyManager','false','null','null','null','','1401457136','DE-football','football_bot_DE','','Football news in German \/ Fu\u00dfball Nachrichten auf Deutsch\r\n#football #Fussball #German #Germany #Deutsch #Deutschland #Bundesliga #Followback #TeamFollowBack','urlhttp\/\/t.co\/vwBeatWiSO','urls','2948','2866','2','Sat May 04 051820 +0000 2013','0','3600','Berlin','false','false','13074','en')

I get syntax error but when i copy it to access and run, it runs.

"when i copy it to access and run, it runs." Check again. That cannot run without INTO following INSERT — HansUp
– HansUp, Commented Nov 12, 2013 at 15:40

HansUp · Accepted Answer · 2013-11-12 15:50:52Z

2

If you still get an error with INSERT INTO, the problem may then be due to reserved words as field names: user; and description.

Enclose those names in square brackets to avoid confusing the db engine.

in_reply_to_screen_name,[user],id_str1

Reserved words are frustrating. They may not always create trouble for a query run within an Access application session. But queries run from outside Access using OleDb seem less tolerant of reserved words.

answered Nov 12, 2013 at 15:50

HansUp

97.3k11 gold badges80 silver badges139 bronze badges

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

Comments

wvdz · Accepted Answer · 2013-11-12 15:37:26Z

2

It should be:

INSERT INTO Table_Name (column1,colum2,etc) VALUES (value1,value2,etc.);

So you forgot the INTO

answered Nov 12, 2013 at 15:37

wvdz

16.2k4 gold badges60 silver badges97 bronze badges

Comments

Linger · Accepted Answer · 2013-11-12 15:58:01Z

0

Here are the things I see wrong with your SQL statement:

You need to use INSERT INTO tweets instead of insert tweets
I am guessing you really don't want a string of 'null' but rather would like the field to be Null. Don't use '.
You are adding a string of 'false' and I am guessing you really want the field to be False. So you would not put the ' around it.
You also have some numbers that you are adding as strings instead of numbers. If they really should be numbers don't wrap them in '.
The format of your date does not appear to be valid.

So with all of the above changes your query might look like:

INSERT INTO tweets
(
  iso_language_code, created_at, id_str, textbody, 
  truncated, in_reply_to_status_id_str, in_reply_to_user_id_str, 
  in_reply_to_screen_name, [user], id_str1, username, screen_name,
  location, [description], url, description1, followers_count, friends_count,
  listed_count, created_at1, favourites_count, utc_offset, time_zone,
  geo_enabled, verified, statuses_count, lang
) 
VALUES (
  'en', CDATE('2013-11-05 23:41:07'), 397871229903716353,
  'TrophyManager', False, Null, Null, Null, '', 1401457136, 'DE-football',
  'football_bot_DE', '', 
  'Football news in German \/ Fu\u00dfball Nachrichten auf Deutsch\r\n#football #Fussball #German #Germany #Deutsch #Deutschland #Bundesliga #Followback #TeamFollowBack',
  'urlhttp\/\/t.co\/vwBeatWiSO', 'urls', 2948, 2866, 2,
  'Sat May 04 051820 +0000 2013', 0, 3600, 'Berlin', False, False,
  13074, 'en'
)

edited Nov 12, 2013 at 15:58

answered Nov 12, 2013 at 15:46

Linger

15.1k23 gold badges54 silver badges79 bronze badges

2 Comments

LittleBobbyTables - Au Revoir Over a year ago

'Tue Nov 05 234107 +0000 2013' isn't a format I'm familiar with either. If that's a date field, there could be problems.

Linger Over a year ago

@LittleBobbyTables, I updated my answer to reflect your date format issue.

Collectives™ on Stack Overflow

Insert syntax error

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related