On Monday 17 November 2003 14:06, fooler wrote:
> CREATE DATABASE ako_ito;
> CREATE TABLE ako_ito.pogi (name varchar(32));
> RENAME TABLE ako_ito.pogi TO ako_ito.change;
>
> SELECT * FROM ako_ito.change;
oo nga. i noticed that select * from change doesn't work.
it's still that lexer/parser thing. so you have to specify the
whole database.table thing when referring to change.
but since the original question had to do with an application
that required that table, the questions still remain.
1. is the source available?
2. if not, does the program use database.table syntax
consistently? or does it refer to just the table name
(in which case, you'll have parser/lexer problems with
the change keyword still).
if the answers to both are no, then it's still going to be a mess
trying to get the application to work with the database.table
requirement.
tiger
--
Gerald Timothy Quimpo gquimpo*hotmail.com tiger*sni*ph
http://bopolissimus.sni.ph
Public Key: "gpg --keyserver pgp.mit.edu --recv-keys 672F4C78"
They that wait upon the Lord, shall renew their strength;
they shall mount up their wings as eagles;
they shall run, and not be weary;
and they shall walk, and not faint.
Isaiah 40:31
--
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
