Error creating table: Key column doesn't exist

Question

I tried create these tables:

$sql = "CREATE TABLE IF NOT EXISTS Articls (
            id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,     
            name VARCHAR(254) COLLATE utf8_persian_ci NOT NULL      
) DEFAULT COLLATE utf8_persian_ci";



$sql = "CREATE TABLE IF NOT EXISTS Tags (
            id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,  
            id_articls INT(10) UNSIGNED NOT NULL,   
            name VARCHAR(256) COLLATE utf8_persian_ci NOT NULL,           
            FOREIGN KEY (`Tags.id_articls`) REFERENCES Articls(`Articls.id`)
) DEFAULT COLLATE utf8_persian_ci"

;

First table create successfully but secnond I get this error:

Error creating table: Key column 'Tags.id_articls' doesn't exist in table

If I remove Tags. in Tags.id_articls and Tags.id_articls I get errno: 150

Also If I try

   $sql = "CREATE TABLE IF NOT EXISTS Tags (
                id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,  
                id_articls INT(10) UNSIGNED NOT NULL,   
                name VARCHAR(256) COLLATE utf8_persian_ci NOT NULL,           
                FOREIGN KEY (Tags.id_articls) REFERENCES Articls(Articls.id)
    ) DEFAULT COLLATE utf8_persian_ci"

I get this error:

Error creating table: 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 '.id_articls) REFERENCES Articls(Articls.id) ) DEFAULT COLLATE utf8_persian_ci' at line 5

I think you just have to write: `FOREIGN KEY (id_articls) REFERENCES Articls(id)` — Rizier123, Dec 28 '14 at 21:14
@Rizier123 is right, use id_articles instead of Tags.id_articles, since the Tags table doesn't exist yet — Pieter De Clercq, Dec 28 '14 at 21:21
@MrBr1ghtSide If I use id_articles instead of Tags.id_articles, I get (errno: 150) — ali raha, Dec 28 '14 at 21:23

score 1 · Accepted Answer · answered Dec 28 '14 at 21:13

1

The foreign key in your Tags table should be id_articls and not Tags.id_articls

answered Dec 28 '14 at 21:13

Yes I wrote in question...I get (errno: 150) – ali raha Dec 28 '14 at 21:16
It still says `Tags.id_articls`. You need to put the single-quotes back and make it just `id_articls` in single-quotes. – Dec 28 '14 at 21:44

Error creating table: Key column doesn't exist

1 Answers1