----- Original Message ----- From: "Bopolissimus Platypus" <[EMAIL PROTECTED]> To: "Philippine Linux Users Group Mailing List" <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 11:21 AM Subject: Re: [plug] mysql problem
> On Monday 17 November 2003 10:33, Ako Ito wrote: > > mysql gurus.. i am running mysql 4.0.15 on my redhat 9 server.. how can i > > create a table named 'change' on mysql.. it keeps giving me the statement > > error.. but when i create a table named 'changes' it successfully creates > > it.. my hint is this is a reserved table name since they have a command > > change on their mysql statement.. any ideas on how can i create it.. coz we > > bought a software that uses the change table name. > > i am not a guru. just taking a stab :). im not a mysql guru too but ill give you the trick :-> CREATE TABLE ako_ito (....); RENAME TABLE ako_ito TO change; fooler. -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
