Duplicating a table

[Anon]

Hi,

I need to duplicate a table that has data in it to a new table, but I don't want the data to be put into the new table.

What's the best way to do this?

Thanks,
Greg

[tomhath]

Some databases allow you to do a SELECT INTO, but I don't think mysql supports it. Just give it where clause that never matches any records. If that doesn't work you'll probably have to do a CREATE TABLE

SELECT * INTO newtab FROM oldtab WHERE oldtab.ID < -9999