Hello.
> Question 1: How do I check my syntax against the version and distribution > that I am > running? In manual it is usually said which features are available as of which version. Use the special form of comments to adopt your queries to corresponding version. See: http://dev.mysql.com/doc/mysql/en/comments.html In your case CHARSET is not supported because you run 4.0.23 version. > Question 2: I thought on update was a reference definition and required a >reference to a parent table and I did think CURRENT_STAMP was a reference >action? You're right, both statements don't work at 4.0.24 and 5.0.4-beta. >running: mysql Ver 12.22 Distrib 4.0.23, for Win95/Win98(i32) downloaded >from >www.devside.net/web/servers/free/download. > >When I run a script with the following commands I get sql syntax errors: > >Create table 'test' ( 'helper' varchar(22) ) > ENGINE=MYISAM DEFAULT CHARSET=latin1; > > I get a sql error telling me to check the syntax for this version. > > I modified the line to > ENGINE=MYISAM CHARSET=latin1; > > > no sql errors. > > Next snytax error I get is: > Create table 'testime' ( 'teatime' timestamp NOT NULL default > CURRENT_TIMESTAMP on update > CURRENT_TIMESTAMP, > 'val' char(22) NOT Null); > > I modified the line to > Create table 'testime' ( 'teatime' timestamp NOT NULL default > 'CURRENT_TIMESTAMP on update > CURRENT_TIMESTAMP', > 'val' char(22) NOT Null); > > no sql errors. > > Question 1: How do I check my syntax against the version and > distribution that I am > running? > > Question 2: I thought on update was a reference definition and > required a reference to a > parent table > and I did think CURRENT_STAMP was a reference action? > > Thank you, > Raymond > > > "Jacob, Raymond A Jr" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]