CREATE TABLE temp_table ( PRIMARY KEY (tid), KEY forum(forum,last)) SELECT * FROM table WHERE 1 = 0
想建立一个和已有的table一样的表。
但是tid在table中是AUTO_INCREMENT，这样建立的temp_table的tid却不是的，请问该如何写，才能让tid在temp_table中也是AUTO_INCREMENT？
---------------------------------------------------------------
呵呵,只能再加一条
ALTER TABLE temp_table CHANGE tid tid int(3) unsigned AUTO_INCREMENT
---------------------------------------------------------------
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)]
[table_options] [select_statement]
table_options:
TYPE = {BDB ¦ HEAP ¦ ISAM ¦ InnoDB ¦ MERGE ¦ MYISAM }
or AUTO_INCREMENT = #
or AVG_ROW_LENGTH = #
or CHECKSUM = {0 ¦ 1}
or COMMENT = "string"
or MAX_ROWS = #
or MIN_ROWS = #
or PACK_KEYS = {0 ¦ 1}
or PASSWORD = "string"
or DELAY_KEY_WRITE = {0 ¦ 1}
or ROW_FORMAT= { default ¦ dynamic ¦ fixed ¦ compressed }
or RAID_TYPE= {1 ¦ STRIPED ¦ RAID0 } RAID_CHUNKS=# RAID_CHUNKSIZE=#
or UNION = (table_name,[table_name...])
or DATA DIRECTORY="directory"
or INDEX DIRECTORY="directory"
select_statement:
[IGNORE ¦ REPLACE] SELECT ... (Some legal select statement)
table_options 中是有AUTO_INCREMENT 的，但是怎么加也不可以。
-------------------------------------------------------------
CREATE TABLE 中的AUTO_INCREMENT是指AUTO_INCREMENT列的下一个自增值