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 :). http://www.strw.leidenuniv.nl/cgi-bin/info2html?(mysql)Reserved%20words yes, change is a reserved word. is the software open source? can you go through the source code and just modify all references to the change table (and change.<column_name> if any) to some other table name? modifying the app is probably easier than modifying mysql (or mysql's parser or yacc files) to allow tables to be named "change". on the other hand, i don't have the mysql sources on hand (installed from RPM) so i don't know how hard it would be to modify the parser to let you create tables named "change". it's not something i'd try to do though, just offhand. modify the app, not the server, if you can. was the original RDBMS the app was developed for mysql? if yes, what version of mysql (must have been an older version that, back then, still allowed "change" as a table name)? maybe you could run that version? if it wasn't designed for mysql at the beginning, is it supposed to work out of the box with mysql at all? or will you have to hack it (or mysql) to get it to work correctly? e.g., does the app use subselects? http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html, version 4.1 has subselects, i haven't looked at that, just pointing out the claim older versions didn't have subselects does it use transactions? use InnoDB or BDB (the manual says InnoDB provides full ACID compliance, so use InnoDB if you need transactions. does it need anything that mysql doesn't do? stored procedures? (http://www.mysql.com/doc/en/ANSI_diff_Triggers.html, so they're not yet in the current version, they'll be in the next version). views? (not yet in 4.x, it'll be in the next version, 5.x). tiger -- Gerald Timothy Quimpo gquimpo*hotmail.com tiger*sni*ph http://bopolissimus.sni.ph Public Key: "gpg --keyserver pgp.mit.edu --recv-keys 672F4C78" The difficult we do today. The impossible takes a little longer. -- 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
