Sqlite3 database Create Table Error

Question

Well Hello guys, I'm working on an android app with an sqlite3 database, can you please help me to debug this code, because it says syntax error and I can't find the error.

"CREATE TABLE cancion(id INTEGER PRIMARY KEY, name TEXT, genre_id INTEGER, singer_id INTEGER," +
            " FOREING KEY (genre_id) REFERENCES genre(id)," +
            " FOREING KEY (singer_id) REFERENCES singer(id));";
    String queryGenero = "CREATE TABLE genre(id INTEGER PRIMARY KEY, name TEXT);";
    String querySinger = "CREATE TABLE singer(id INTEGER PRIMARY KEY, name TEXT);";

in which sequence your queries are fired is the queryGenero and querySinger are fired before your firs statement executed? — Swapnil
– Swapnil, Commented Oct 18, 2013 at 5:41

Szymon · Accepted Answer · 2013-10-18 05:45:18Z

4

You have a typo in: FOREING should be FOREIGN

answered Oct 18, 2013 at 5:45

Szymon

43k16 gold badges99 silver badges115 bronze badges

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

Collectives™ on Stack Overflow

Sqlite3 database Create Table Error

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