Import problem

[joe2]

Hi,

I have exported all tables with data from MySql front. When i tried to import the data from exported sql. It is throwing error in simple create table syntax.

Create table name(name varchar(250) NOT NULL default ) TYPE=MyISAM;

Mysql front and phpmyadmin throwing error near 'TYPE=MyISAM'. If i remove TYPE=MyISAM. Mysql front and phpmyadmin creates table.

What may be the possible cause of the error ?

Thanks in advance.
Joe

[pete_bisby]

One thing I've noticed is that you haven't specified a default value for the field, because you've defined it as NOT NULL.

Try the following, and this should work:

CREATE TABLE name (
  `name` varchar(250) NOT NULL default '?'
)
TYPE=MyISAM;

[joe2]

Thanks for the reply.

In actual Default value is set. here it was a typo mistake.

Thanks again.