Re: copying a mysql table within a database

here's the mysql syntax: http://www.mysql.com/doc/en/CREATE_TABLE.html create table SPORTLASER select * from MICROLIGHT just call that from PHP... Frank Tudor wrote:

I know this is not the right group but the mysql group is very quite. how do I copy a table and rename it inside a database Like if database = microlight table = microlight copy table microlight to table called sportlaser Please help. Frank __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com

-- Leo G. Divinagracia III ldivinag@csuhayward.edu zzzzz