MySql Import not successful

[solidariti]

Can someone please tell me why this isn't being imported?


-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`mID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`username` varchar( 32 ) default NOT NULL ,
`displayname` varchar( 40 ) NULL default '',
`nickname` varchar( 20 ) NULL default '',
`password` varchar( 32 ) default NOT NULL ,
`newPassword` varchar( 32 ) default '',
`uniadres` varchar( 100 ) default NOT NULL ,
`mailadres` varchar( 100 ) default NOT NULL ,
`termadres` text NOT NULL ,
`actnum` varchar( 20 ) default NULL ,
`userlevel` tinyint( 4 ) default NULL ,
`signupdate` varchar( 16 ) default NULL ,
`lastlogin` varchar( 16 ) default NULL ,
`lastloginfail` bigint( 20 ) default NULL ,
`numloginfail` tinyint( 4 ) default NULL ,
`warnlevel` tinyint( 4 ) NOT NULL default '0',
`sessionID` varchar( 32 ) default '',
`location` varchar( 100 ) NOT NULL default '',
`lastClick` INT default '0',
`uIP` varchar( 100 ) NOT NULL default '',
`rember` varchar( 32 ) default NULL ,
`interests` text NOT NULL ,
`clubs` text NOT NULL ,
`profile` text NOT NULL ,
`msn` varchar( 40 ) NULL default '',
`icq` varchar( 10 ) NULL default '',
`aim` varchar( 40 ) NULL default '',
`yim` varchar( 50 ) NULL default '',
`tel` varchar( 20 ) NULL default '',
`mobile` varchar( 12 ) NOT NULL default '',
`position` varchar( 20 ) NOT NULL default '',
`role` varchar( 20 ) NOT NULL default '',
`age` int( 3 ) default NULL ,
`website` varchar( 150 ) default NULL ,
`show_email` int( 2 ) default '0',
`avatar` varchar( 30 ) NOT NULL default 'no_pic.gif',
`player` char( 3 ) NOT NULL default '',
`selected` char( 3 ) NOT NULL default 'no',
PRIMARY KEY ( `mID` ) ,
UNIQUE KEY `username` ( `username` ) ,
UNIQUE KEY `displayname` ( `displayname` )
) TYPE = MYISAM PACK_KEYS =0 AUTO_INCREMENT =124;

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 'NOT NULL,
`displayname` varchar(40) NULL default '',
`nickname` varchar(' at line 3

[chazzy]

`username` varchar( 32 ) default NOT NULL ,
`displayname` varchar( 40 ) NULL default '',


take out the default keyword for NOT NULL columns.

[solidariti]

Ok thank you I will try it, but instead of me going and just doing this, would you mind me telling me why this throws up errors please, thank you.

Do you have any tips for database programming?

[chazzy]

it's improper syntax, as per mysql.com