Hi
I would like to create a php code that creates a mysql table from another , with preserving indexes and keys.
how should i do this ?
the : "create table select * from oldtable" does not work.
thanks
moshe
Creating a new table from other table in other database in m
Moderator: General Moderators
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
mbaroz. remember to put the database names before table names if they are in different databases.feyd wrote:CREATE TABLE `newTable` LIKE `oldTable`
http://dev.mysql.com/doc/refman/4.1/en/ ... table.html