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
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
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
* 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: