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 |
|
hefinw
Starting Member
2 Posts |
 Posted - 2009-11-22 : 12:01:28
|
| Hi, I am having the following error message when dumping a text file in order to create tables in my database:ErrorSQL query:# MySQL dump for vertical.pl#--------------------------------------------------------CREATE TABLE EVENTS (frfrom time,tto time,datumet varchar( 7 ) ,dag varchar( 4 ) ,user varchar( 20 ) ,event text,untill varchar( 7 ) ,repeat varchar( 7 ) ,id int( 11 ) DEFAULT '' NOT NULL AUTO_INCREMENT ,home varchar( 255 ) ,email varchar( 255 ) ,PRIMARY KEY ( id ));MySQL said: Documentation#1064 - 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 'repeat varchar(7) , id int(11) DEFAULT '' NOT NULL auto_increment, hom' at line 9This is for an events calendar script and I am only following instructions here and do not really have any experience of using SQL. I would appreciate any advice as this is very frustratingRegardsTony |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-22 : 12:13:17
|
This is not a MySQL forum, it is only for MS SQL Server.But I have tested your create table on a MySQL Server without any errors...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-22 : 12:27:46
|
| didnt understand reason for giving default value for an autoincrement field? |
|
|
|
hefinw
Starting Member
2 Posts |
Posted - 2009-11-22 : 14:46:21
|
| Apologies for using the wrong forum, very limited knowledge where this is concerned. This error keeps coming up, I am assured by the developer that the script is ok but if you have managed to run the script without errors then I will have to look into it further.RegardsTony |
|
|
|
|
|
|
|
|
Error message on install