Mega Code Archive

 

Categories / MySQL / Table Index

 

Copying Only Selected Columns from a Table

CREATE TABLE <new_table_name> SELECT <column_name1>, <column_name2> FROM <old_table_name>;