在mysql中怎样选中复制

CREATE TABLE new_table LIKE original_table;
INSERT INTO new_table SELECT * FROM original_table;

CREATE TABLE new_table LIKE original_table;

INSERT INTO new_table (column1, column2, ...)
SELECT column1, column2, ...
FROM original_table
WHERE condition;

mysqldump -u username -p database_name original_table > table_backup.sql
mysql -u username -p database_name < table_backup.sql

INSERT INTO new_table (column1, column2)
SELECT COALESCE(column1, 'default_value'), IFNULL(column2, 'default_value')
FROM original_table;

CREATE TABLE new_table LIKE original_table CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE new_table DROP PRIMARY KEY;
INSERT INTO new_table SELECT * FROM original_table;
ALTER TABLE new_table ADD PRIMARY KEY (primary_key_column);