: Error while importing .sql file in phpMyAdmin Getting error while importing .sql file in phpMyAdmin please help. Error SQL query: CREATE TABLE `sbbleads_admin` ( `sb_id` BIGINT( 20 ) NOT NULL
Getting error while importing .sql file in phpMyAdmin please help.
Error
SQL query:
CREATE TABLE `sbbleads_admin` (
`sb_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
`sb_admin_name` VARCHAR( 255 ) DEFAULT NULL ,
`sb_pwd` VARCHAR( 255 ) DEFAULT NULL ,
PRIMARY KEY ( `sb_id` )
) TYPE = MYISAM ;
MySQL said: Documentation
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 'TYPE=MyISAM' at line 6
More posts by @Goswami781
1 Comments
Sorted by latest first Latest Oldest Best
TYPE should be ENGINE
CREATE TABLE `sbbleads_admin` (
`sb_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
`sb_admin_name` VARCHAR( 255 ) DEFAULT NULL ,
`sb_pwd` VARCHAR( 255 ) DEFAULT NULL ,
PRIMARY KEY ( `sb_id` )
) ENGINE = MYISAM ;
Terms of Use Create Support ticket Your support tickets Stock Market News! © vmapp.org2024 All Rights reserved.