----- Original Message ----- From: "Bopolissimus Platypus" <[EMAIL PROTECTED]> To: "Philippine Linux Users Group Mailing List" <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 2:13 PM Subject: Re: [plug] mysql problem
> 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. yes it is a bad parser logic of mysql... tsk tsk tsk.... i realized that you dont even need to RENAME it.. just simply CREATE TABLE ako_ito.change directly :-> 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
