re: is keys a restricted keyword

2005-06-09 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a db named keys, and when I tried to do grant select,insert,update,delete on keys.* to [EMAIL PROTECTED] I get an error, about SQL syntax near 'keys.*'. Should this work? I am using mysql 5.0.6 and 4.1.7. Thanx. - -- Love is mutual

Re: is keys a restricted keyword

2005-06-09 Thread Terence
wrap it in `` e.g. `keys` James Black wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a db named keys, and when I tried to do grant select,insert,update,delete on keys.* to [EMAIL PROTECTED] I get an error, about SQL syntax near 'keys.*'. Should this work? I am using mysql 5.0.6