RE: [PHP] copying the structure of a blank table in mysql

2002-06-24 Thread John Holmes
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

[PHP] copying the structure of a blank table in mysql

2002-06-23 Thread Phil Schwarzmann
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

2002-06-23 Thread Analysis Solutions
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