myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Error -2147217900 Incorrect syntax near '`'. Options · View
omiyehan
Posted: Wednesday, May 25, 2011 6:05:10 AM
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`
--
elian
Posted: Wednesday, May 25, 2011 1:54:11 PM

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
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.