mysql foreign key creating table

Question

String query = "CREATE TABLE IF NOT EXISTS platforms ( " +
                   "id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " +
                   "sites_id INTEGER UNSIGNED NOT NULL, " +
                   "baseline BLOB NULL, " +
                   "platform BLOB NULL, " +
                   "siteinfo BLOB NULL, " +
                   "databases BLOB NULL, " +
                   "PRIMARY KEY(id), " +
                   "INDEX (sites_id), " +
                   "FOREIGN KEY (sites_id) " +
                     "REFERENCES sites (id) " +
                        "ON DELETE NO ACTION " +
                        "ON UPDATE NO ACTION " +
                   ")ENGINE=InnoDB;";

this is the SQL query for a MySQL database I'm trying to create. However, I don't know why, I'm getting the following error:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'databases BLOB NULL, PRIMARY KEY(id), INDEX (sites_id), FOREIGN KEY (sites_id) R' at line 1"

Could someone please point out for what is the problem?

eggyal · Accepted Answer · 2012-05-30 23:21:51Z

3

DATABASES is a reserved word. Quote it by using the backtick ` character:

`databases` BLOB NULL

answered May 30, 2012 at 23:21

eggyal

127k18 gold badges221 silver badges245 bronze badges

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

Collectives™ on Stack Overflow

mysql foreign key creating table

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