MySQL数据导入两个问题解决

SQL 错误 [3750] [HY000]: Unable to create or change a table without a primary key, 
when the system variable 'sql_require_primary_key' is set. 
Add a primary key to the table or unset this variable to avoid 
this message. Note that tables without a primary key can 
cause performance problems in row-based replication, 
so please consult your DBA before changing this setting.

复制表结构，包括索引、约束等，但不复制数据
CREATE TABLE 新表名 LIKE 原表名;
示例，CREATE TABLE users_copy LIKE users;

复制表结构，但不会复制索引和约束
CREATE TABLE 新表名 AS SELECT * FROM 原表名 WHERE 1=0;
示例，CREATE TABLE users_copy AS SELECT * FROM users WHERE 1=0;

复制表结构+数据
CREATE TABLE 新表名 AS SELECT * FROM 原表名;
示例，CREATE TABLE users_copy AS SELECT * FROM users;

1. 查看原表的创建语句
SHOW CREATE TABLE 原表名;

2. 修改表名后执行创建语句
示例输出：
CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,   
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

3. 修改表名后创建新表
CREATE TABLE users_copy (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

几种方案的对比，

复制到另一个数据库
CREATE TABLE 目标数据库.新表名 LIKE 源数据库.原表名;

示例
CREATE TABLE db2.users_copy LIKE db1.users;