Data Type MySQL

  1. Home
  2. MySQL
  3. Data Type
  4. Preserve column attributes such as AUTO_INCREMENT and columns default value during table copying
CREATE TABLE dst_tbl (PRIMARY KEY (id)) SELECT * FROM src_tbl;
ALTER TABLE dst_tbl MODIFY id INT UNSIGNED NOT NULL AUTO_INCREMENT;