Rank: Newbie Groups: Member
Joined: 5/25/2011 Posts: 0 Points: 6 Location: africa
|
i tried to create table and this error display Error -2147217900 i am new to mylittleadmin help see the error and table below
Incorrect syntax near '`'.
CREATE TABLE `subscribers` ( `id` int(11) NOT NULL auto_increment, `firstname` varchar(50) NOT NULL default '', `email` varchar(50) NOT NULL default '', `verified` tinyint(4) NOT NULL default '0', `ip` varchar(30) NOT NULL default '', `code` varchar(30) NOT NULL default '', `joindate` date NOT NULL default '0000-00-00', `nmailout` varchar(11) NOT NULL default '-1', KEY `index` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
-- -- Dumping data for table `subscribers` --
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
You try to execute a mySQL script on a MS SQL Server. It cannot work. Write your script in correct T-SQL
|