Błąd tworzenia tablicy #1064, #1064 Opcje

[saperek25]

kod zapytania:

[SQL] pobierz, plaintext 
CREATE TABLE `bloglm_article` (
`article_id' int(11) NOT NULL auto_increment,
`article_title` varchar(150) collate utf8_unicode_ci NOT NULL,
`article_intro` varchar(255) collate utf8_unicode_ci NOT NULL,
`article_cont` text collate utf8_unicode_ci NOT NULL,
`article_autor` varchar(25) collate utf8_unicode_ci NOT NULL,
`article_howmany` int(11) NOT NULL default '0',
`article_keyword` varchar(255) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=51;
[SQL] pobierz, plaintext 

błąd:

#1064 - 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 'article_title` varchar(150) collate utf8_unicode_ci NOT NULL, `article_intro` va' at line 2

ok już nie ważne

Ten post edytował saperek25 19.05.2012, 08:21:59

[trafas]

Powinno być:

[PHP] pobierz, plaintext 
`article_id` int(11) NOT NULL auto_increment,
[PHP] pobierz, plaintext 

a jest

[SQL] pobierz, plaintext 
`article_id' int(11) NOT NULL auto_increment,
[SQL] pobierz, plaintext 

chodzi o znak za article_id.