Syntax error in sqlite insert query when trying to insert data with quote symbol

Question

I'm pretty new to the world of Databases. And I'm trying to fill a local database with my local music library. Here's what the table looks like (the string I used to create it)

string sql = ("CREATE TABLE music (searchpaths VARCHAR(20), artists VARCHAR(20), album VARCHAR(20), track VARCHAR(20), year INT, duration INT, tracknumber INT)");

But I'm getting this error (see title of question) when trying to fill the database.

I always seem to get it on the same song. Here's what that "INSERT" string looks like:

"INSERT INTO music (searchpaths, artists, album, track, year, duration, tracknumber) values ('E:\\Music\\01 I Don't Deserve You (Seven Lions Remix) [Radio Edit].mp3', 'Paul van Dyk', 'I Don't Deserve You Remixes', 'I Don't Deserve You (Seven Lions Remix) [Radio Edit]', 2012, 226, 7)"

If there's any more info you need, please tell me. Thanks

You have ' in your file name (and other fields too). It denotes end of SQL string. Escape it. Moreover you don't need to escape backslash. Don't you want to care about these stuff? Use parameters. — Adriano Repetti
– Adriano Repetti, Commented Jan 4, 2014 at 19:15
Ah!! Thanks! The backslashes seem to do that on their own, I don't know why, but it still works.. :P Is there any page where you can see the characters which you can't use in a string for SQL? That'd be great. :) — Tokfrans
– Tokfrans, Commented Jan 4, 2014 at 19:18

Travis · Accepted Answer · 2014-01-04 19:15:59Z

1

Since your content also contains single quotes, it's getting jammed up. You can do '' two quotes to escape words like don't.

Though the better answer is to use queries with parameters instead of raw SQL strings.

answered Jan 4, 2014 at 19:15

Travis

10.6k2 gold badges30 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Syntax error in sqlite insert query when trying to insert data with quote symbol

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related