Re: Replicating Table Schema

2004-01-03 Thread Tobias Asplund
On Fri, 2 Jan 2004, Roger Baklund wrote: * Gohaku I was just curious if there's a shorthand way of replicating a Table Schema. I use the following to create a new Table with the same schema. create table new_table ( select * from table); delete from new_table; You can avoid the

Replicating Table Schema

2004-01-01 Thread Gohaku
Hi everyone, I was just curious if there's a shorthand way of replicating a Table Schema. I use the following to create a new Table with the same schema. create table new_table ( select * from table); delete from new_table; Thanks in advance, -gohaku -- MySQL General Mailing List For list

Re: Replicating Table Schema

2004-01-01 Thread Chris Elsworth
On Thu, Jan 01, 2004 at 05:42:59PM -0500, Gohaku wrote: Hi everyone, I was just curious if there's a shorthand way of replicating a Table Schema. I use the following to create a new Table with the same schema. create table new_table ( select * from table); delete from new_table; CREATE

Re: Replicating Table Schema

2004-01-01 Thread Roger Baklund
* Gohaku I was just curious if there's a shorthand way of replicating a Table Schema. I use the following to create a new Table with the same schema. create table new_table ( select * from table); delete from new_table; You can avoid the DELETE by specifying a non-true WHERE clause: