just use create table `change` and this will certainly work (i.e. back tick). No need to create/rename table change or modify source code.
On 11/17/2003 10:33 AM, 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.
thanks,
allan
------------------------------------------------------------------------
-- 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
-- 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
