seanstuart Posted January 2, 2008 Share Posted January 2, 2008 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', 'support@php-developers.net'); -- -------------------------------------------------------- [code] regards Sean [/code] Quote Link to comment https://forums.phpfreaks.com/topic/84106-solved-syntax-error-can-you-help/ Share on other sites More sharing options...
obsidian Posted January 2, 2008 Share Posted January 2, 2008 There is no "=" required in a charset declaration: ... DEFAULT CHARSET latin1 ... Check out the MySQL manual for details on all your table options. Quote Link to comment https://forums.phpfreaks.com/topic/84106-solved-syntax-error-can-you-help/#findComment-428128 Share on other sites More sharing options...
seanstuart Posted January 2, 2008 Author Share Posted January 2, 2008 my version of mysql did not like .................... ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ; now sorted thanks..... Sean Quote Link to comment https://forums.phpfreaks.com/topic/84106-solved-syntax-error-can-you-help/#findComment-428160 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.