create table的问题 呵呵,只能再加一条ALTER TABLE `temp_table` CHANGE `tid` `tid` int(3) unsigned AUTO_INCREMENT 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 哦。看MYSQL的手册说CREATE TALBE的语法是: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 的,但是怎么加也不可以。 错误:table_options 中是有AUTO_INCREMENT和这个没有关系:) 呵呵,CREATE TABLE 中的AUTO_INCREMENT是指AUTO_INCREMENT列的下一个自增值:》 MYSQL 海量数据 【索引创建方案】征集,恳请大牛现身 MYSQL高版本切换到低版本 my.ini中的用户名和密码有什么用呀? mysql字段接触发器 为什么order by 不起作用 菜鸟请教 求助:现在有表A,表B,2个表都有字段id,请用左联方法写出一句sql,从2个表中找出id相等的纪录 如何将sqlsever的备份文件,还原到别的机子上,在线等待ing 一个一直困扰我的问题(更新) HP-UX想装个Mysql,应该选择哪个版本 初级的问题,mysql怎样导入一个数据库文件 About mySQL install(online hold)
看MYSQL的手册说CREATE TALBE的语法是:
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列的下一个自增值:》