[SOLVED] syntax error can you help

[seanstuart]

I get a #1064 sytax error:::::

 

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 'collate latin1_general_ci NOT NULL default '',

 `admin_passwo

 

-- 
-- Table structure for table `tdm_admin`
-- 

CREATE TABLE `tdm_admin` (
 `admin_id` int(10) NOT NULL auto_increment,
 `admin_username` varchar(100) collate latin1_general_ci NOT NULL default '',
 `admin_password` varchar(32) collate latin1_general_ci NOT NULL default '',
 `admin_email` varchar(255) collate latin1_general_ci NOT NULL default '',
 PRIMARY KEY  (`admin_id`),
 KEY `admin_username` (`admin_username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `tdm_admin`
-- 

INSERT INTO `tdm_admin` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '[email protected]');

-- --------------------------------------------------------

[code]


regards Sean

[/code]

[obsidian]

There is no "=" required in a charset declaration:

 

...
DEFAULT CHARSET latin1
...

 

Check out the MySQL manual for details on all your table options.

[seanstuart]

my version of mysql did not like ....................

ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

 

now sorted thanks..... Sean