Phpmyadmin Mysql import error

i´m trying to import XML file to MYSQL using PHPMYADMIN.
But I´m receiving this error :

CREATE TABLE IF NOT EXISTS  `xpsbahq`.(

) ENGINE = MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Mensagens do MySQL :

#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 '() ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1
Jose BredariolPMPAsked:
Who is Participating?
 
F PCommented:
Remove the . before your parentheses after the table name.

You can't create tables with no columns. Just change/add to this:

CREATE TABLE IF NOT EXISTS  `xpsbahq`(
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY
) ENGINE = MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
0
 
Dave BaldwinFixer of ProblemsCommented:
Maybe because there is nothing there?  You can't create a table out of nothing.  ??
0
 
Jose BredariolPMPAuthor Commented:
The file is full (about 10000 lines), but the table is empty. Any problem with that ?
0
 
Dave BaldwinFixer of ProblemsCommented:
Besides an extra period in `xpsbahq`.( , you're not showing any columns defined.  Is that the whole table creation section?
0
 
Jose BredariolPMPAuthor Commented:
thanks all
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.