Mega Code Archive

 

Categories / MySQL / Table Index

 

To copy only some of the columns, name the ones you want in the SELECT part of the statement

CREATE TABLE dst_tbl SELECT b, d FROM src_tbl;