MySql 5.0 SELECT INTO的替代

MySql 5.0 尚不支持 SELECT INTO，通过CREATE TABLE t1 SELECT c1, c2 FROM t2 替代。

示例：

CREATE TABLE accounts SELECT users.id, users.username, users.password, UNIX_TIMESTAMP(users.starttime) AS createTime, 0 AS expireTime, 0 AS tag FROM users WHERE users.id > 10000;

之后检查表格字段名称及类型定义，做相应调整：

ALTER TABLE accounts ADD PRIMARY KEY (id);