Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
columbo1977a
Starting Member
2 Posts |
Posted - 2006-06-08 : 10:53:20
|
HiI am transfering the table from my computer to my control panel on the website but when i try to create it it comes up with the following errorYou have an error in your SQL syntax near '-Enter Password varchar(20) NOT NULL default '', House No_Name varchar(20) defa' at line 1.Query: CREATE TABLE users ( MemberId int(8) NOT NULL auto_increment, Forname varchar(20) NOT NULL default '', Surname varchar(20) NOT NULL default '', Username varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', Re-Enter Password varchar(20) NOT NULL default '', House No_Name varchar(20) default NULL, Street varchar(20) default NULL, Village varchar(20) default NULL, Town varchar(20) default NULL, County varchar(20) default NULL, Postcode varchar(10) default NULL, Telephone varchar(13) default NULL, Mobile varchar(15) default NULL, Fax varchar(15) default NULL, Email varchar(25) NOT NULL default '', Web Address varchar(50) default NULL, Date Joined date NOT NULL default '0000-00-00', Level Of Knowledge varchar(15) default NULL, Interests varchar(30) default NULL, Comments text, PRIMARY KEY (MemberId) ) TYPE=MyISAMthe code that i pasted into the sql window is below :You have an error in your SQL syntax near '-Enter Password varchar(20) NOT NULL default '', House No_Name varchar(20) defa' at line 1.Query: CREATE TABLE users ( MemberId int(8) NOT NULL auto_increment, Forname varchar(20) NOT NULL default '', Surname varchar(20) NOT NULL default '', Username varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', Re-Enter Password varchar(20) NOT NULL default '', House No_Name varchar(20) default NULL, Street varchar(20) default NULL, Village varchar(20) default NULL, Town varchar(20) default NULL, County varchar(20) default NULL, Postcode varchar(10) default NULL, Telephone varchar(13) default NULL, Mobile varchar(15) default NULL, Fax varchar(15) default NULL, Email varchar(25) NOT NULL default '', Web Address varchar(50) default NULL, Date Joined date NOT NULL default '0000-00-00', Level Of Knowledge varchar(15) default NULL, Interests varchar(30) default NULL, Comments text, PRIMARY KEY (MemberId) ) TYPE=MyISAMCan someone please tell me why i cant get this working?Columbo1977 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-06-08 : 10:57:43
|
don't use '-' and space in the column name. If you want to you have to enclose in [][Re-Enter Password] varchar(20) NOT NULL default KH |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-08 : 10:58:50
|
>>MemberId int(8) NOT NULL auto_increment, Are you using MS SQL Server?MadhivananFailing to plan is Planning to fail |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-06-08 : 11:13:15
|
Oh.. did not see that and this "TYPE=MyISAM". Looks like MySQL.Please post your question over at MySQL in dbforums.com KH |
|
|
columbo1977a
Starting Member
2 Posts |
Posted - 2006-06-08 : 11:34:47
|
quote: Originally posted by khtan Oh.. did not see that and this "TYPE=MyISAM". Looks like MySQL.Please post your question over at MySQL in dbforums.com KH
It was the spaces i replaced them with underscores.thanks anywaycolumbo1977 |
|
|
|
|
|
|
|