---- Original Message ----- From: "fooler" <[EMAIL PROTECTED]> To: "Philippine Linux Users Group Mailing List" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 1:56 PM Subject: Re: [plug] mysql problem
> ----- Original Message ----- > From: "fooler" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; "Philippine Linux Users Group Mailing List" > <[EMAIL PROTECTED]> > Sent: Monday, November 17, 2003 1:54 PM > Subject: Re: [plug] mysql problem > > > > im not a mysql guru too but ill give you the trick :-> > > > > CREATE TABLE ako_ito (....); > > RENAME TABLE ako_ito TO change; > > oops.... i forgot something... > > RENAME TABLE databasename.ako_ito TO databasename.change; sorry for the mess.... im in hurry because im accessing in saipan mysql server to test it (dont ask why im accessing in saipan because i dont have any mysql server here :->)... here is the complete command: 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; 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
