Re: Migrating MySQL Table Data
| From: | John McCreesh | Date: | Sun, 04 Feb 2001 22:29:28 +0000 |
| Subject: | Re: Migrating MySQL Table Data | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6369@lists.php.net to get a copy of this message | ||
In article <000401c08e92$84cf2030$0100a8c0@phobo>, phobo
<antiphobo@paradise.net.nz> writes
>I am in the process of improving a database scheme considerably in MySQL, by
>breaking tables into smaller tables and so one. I am wondering if there is a
>simple SQL statement to take ALL ROWS of fields 'f1', 'f2', 'f3',
>and copy
>them to the another table.... Then I can remove the fields in the original
>table.
Suggest you get yourself a copy of PHPMyAdmin. One of the dozens of
brilliant features in it is the ability to generate from a table (or a
complete database) all the SQL necessary to recreate the table from
scratch (CREATE TABLE ... INSERT ...).
John