'trigger int(5) default NULL
This is a discussion on 'trigger int(5) default NULL within the MySQL forums, part of the Database Server Software category; --> mysql pdw < pdw.dump ERROR 1064 (42000) at line 1867: You have an error in your SQL syntax; check ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 09:59 AM
| ||||
| ||||
 'trigger int(5) default NULL mysql pdw < pdw.dump ERROR 1064 (42000) at line 1867: 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 'trigger int(5) default NULL, resume_path varchar(80) default NULL, new_resum' at line 102      |
|
02-28-2008, 09:59 AM
| |||
| |||
| Re: 'trigger int(5) default NULL On Fri, 8 Jun 2007 18:28:28 -0700, "nobody" <nobody@nobody.com> wrote: >mysql pdw < pdw.dump > >ERROR 1064 (42000) at line 1867: 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 'trigger int(5) default NULL, > > resume_path varchar(80) default NULL, > > new_resum' at line 102 "trigger" is a reserved word, can't be used as a column name, unless you quote it in backticks like: `trigger`. -- ( Kees ) c[_] Doing nothing makes me tired 'cause I can't take a break. (#228) |
|
02-28-2008, 10:00 AM
| |||
| |||
| Re: 'trigger int(5) default NULL I tried to import a 3.23 databse dump to a mysql 5 database and got thius error. any idea what i should do "Kees Nuyt" <k.nuyt@nospam.demon.nl> wrote in message news:s7sk63598ilqd2mdh9s6vf3ug34238vkaa@dim53.demo n.nl... > On Fri, 8 Jun 2007 18:28:28 -0700, "nobody" <nobody@nobody.com> > wrote: > >>mysql pdw < pdw.dump >> >>ERROR 1064 (42000) at line 1867: 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 'trigger int(5) default NULL, >> >> resume_path varchar(80) default NULL, >> >> new_resum' at line 102 > > "trigger" is a reserved word, can't be used as a column name, > unless you quote it in backticks like: `trigger`. > -- > ( Kees > ) > c[_] Doing nothing makes me tired 'cause I can't take a break. (#228) |
|
02-28-2008, 10:00 AM
| ||||
| ||||
| Re: 'trigger int(5) default NULL > "Kees Nuyt" <k.nuyt@nospam.demon.nl> wrote in message > news:s7sk63598ilqd2mdh9s6vf3ug34238vkaa@dim53.demo n.nl... >> On Fri, 8 Jun 2007 18:28:28 -0700, "nobody" <nobody@nobody.com> >> wrote: >> >>> mysql pdw < pdw.dump >>> >>> ERROR 1064 (42000) at line 1867: 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 'trigger int(5) default NULL, >>> >>> resume_path varchar(80) default NULL, >>> >>> new_resum' at line 102 >> >> "trigger" is a reserved word, can't be used as a column name, >> unless you quote it in backticks like: `trigger`. >> -- >> ( Kees >> ) >> c[_] Doing nothing makes me tired 'cause I can't take a break. (#228) nobody wrote: > I tried to import a 3.23 databse dump to a mysql 5 database and got > thius error. any idea what i should do Please do not top post. What you should do is what Kees told you to do! |
Linear Mode
