Copy table structure

SQL Server:
Select * into table_new from table_old; copy structure and data
Select * into table_new from table_old where 1 = 2; only copy the structure
ORACLE:
Create Table table_new as select * From table_old; copy structure and data
Create Table table_new as select * From table_old where 1 = 0; copy only the structure
DB2:
-- Copy table structure
Create Table table_name_new as (select * From table_name_old) definition only;

-- Insert data
Insert into table_name_new (select * From table_name_old );
MySQL:
----- Copy the table structure and data to the new table
Create Table new table select * from old table

----- Only copy the table structure to the new table
Create Table new table select * from old table where 1 = 2