Mega Code Archive

 

Categories / MySQL / Table Index

 

To create columns in a different order than that in which they appear in the source table

CREATE TABLE dst_tbl SELECT c, a, b FROM src_tbl;