RE: [PHP] copying the structure of a blank table in mysql
Anyone have a link (or the code) to copy the structure of a blank table to a new table using mysql? ? function change_table_name($old_name, $new_name) { $result = mysql_query(show create table $old_name); $create = mysql_result($result,0,1); str_replace(TABLE `$old_name`,TABLE `$new_name`,$create); $result = mysql_query($create); return; } ? Untested, add in some error checking and validate the $old and $new names, and adapt to your needs... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] copying the structure of a blank table in mysql
Anyone have a link (or the code) to copy the structure of a blank table to a new table using mysql? Thanks!!
Re: [PHP] copying the structure of a blank table in mysql
Phil: On Sun, Jun 23, 2002 at 11:14:22PM -0400, Phil Schwarzmann wrote: Anyone have a link (or the code) to copy the structure of a blank table to a new table using mysql? It's far simpler to do this from a command line on the system using the utilities of the database vendor, such as mysqldump, and then importing the stuff into the database, again from the command line. Look at the documentation of the database you're using. --Dan -- PHP classes that make web design easier SQL Solution | Layout Solution | Form Solution sqlsolution.info | layoutsolution.info | formsolution.info T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php