CREATE TABLE IF NOT EXISTS 'tbl_category' (
'cat_id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'cat_parent_id' int(11) NOT NULL DEFAULT '0',
'cat_name' varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
'cat_description' varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
'cat_image' varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY ('cat_id'),
KEY 'cat_parent_id' ('cat_parent_id'),
KEY 'cat_name' ('cat_name')
) ENGINE=MyISAM DEFAULT CHARSET=utf8_unicode_ci
AUTO_INCREMENT=27 ;
ฐานข้อมูล ผมใส่โค้ดผิดบรรทัดไหนครับ
'cat_id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'cat_parent_id' int(11) NOT NULL DEFAULT '0',
'cat_name' varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
'cat_description' varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
'cat_image' varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY ('cat_id'),
KEY 'cat_parent_id' ('cat_parent_id'),
KEY 'cat_name' ('cat_name')
) ENGINE=MyISAM DEFAULT CHARSET=utf8_unicode_ci
AUTO_INCREMENT=27 ;