Mobile app version of vmapp.org
Login or Join
Goswami781

: 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

@Goswami781

Posted in: #Database #Mysql #Phpmyadmin

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

10.01% popularity Vote Up Vote Down


Login to follow query

More posts by @Goswami781

1 Comments

Sorted by latest first Latest Oldest Best

 

@Pope3001725

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 ;

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme