out dated .sql table file help

[dwhswebhosting]

Hello,

Any help is very appreciated. 🙁

I have a outdated .sql file that I am trying to import in to MySQL

I get this error when I try to import:

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 'default0 PRIMARY KEY auto_increment, username varchar( 15 ) ,

I think the file just needs a small tweak to work.

Here is the .sql file:

create table freecounters(id int(10)unsigned not null default 0 primary key auto_increment,username varchar(15),email varchar(100), url varchar(150), password varchar(16), counter int(10), counter_style varchar(10), last_access int(15), site_list int(1));

Can someone edit the code above so it will import into MySQL 4.0.12

Hope this isn't too much to ask.

Thanks, Charles

[jweissig]

This should work... it worked for me on mysql 4.0.12

CREATE TABLE freecounters (
id int(10) unsigned NOT NULL auto_increment,
username varchar(15),
email varchar(100),
url varchar(150),
password varchar(16),
counter int(10),
counter_style varchar(10),
last_access int(15),
site_list int(1),
primary key (id)
); 

thanks,
- Justin

[dwhswebhosting]

That works...

Great 🙂