mysql里面 如何通过SQL语句为某个已有字段添加自增属性 如上面题目。。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql> alter table tt change id id int default null;Query OK, 1 row affected (0.23 sec)Records: 1 Duplicates: 0 Warnings: 0mysql> show create table tt;+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+| Table | Create Table |+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+| tt | CREATE TABLE `tt` ( `id` int(11) NOT NULL DEFAULT '0', `Field1` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 |+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+1 row in set (0.02 sec)mysql> alter table tt modify id int not null auto_increment;Query OK, 1 row affected (0.20 sec)Records: 1 Duplicates: 0 Warnings: 0mysql> select * from tt;+----+--------+| id | Field1 |+----+--------+| 1 | 中国人 |+----+--------+ 随机问题 为什么count(*)就是统计记录数呢? 求个SQL~~~~ 请教mysql语言执行的问题 mysql的连接问题 MySQL安装路径 用java如何根据一个数据库表名取得它的主键和所有其他列名??(MYSql) mysql 注册用户的存储过程? 远程数据库与远程表的区别 mysql两个表联合查询 mysql用load导入数据时没有完全正确提示: Data truncated for column 'cno' at row 1 Mysql中多个条件用or连接
Query OK, 1 row affected (0.23 sec)
Records: 1 Duplicates: 0 Warnings: 0mysql> show create table tt;
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+
| tt | CREATE TABLE `tt` (
`id` int(11) NOT NULL DEFAULT '0',
`Field1` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.02 sec)mysql> alter table tt modify id int not null auto_increment;
Query OK, 1 row affected (0.20 sec)
Records: 1 Duplicates: 0 Warnings: 0mysql> select * from tt;
+----+--------+
| id | Field1 |
+----+--------+
| 1 | 中国人 |
+----+--------+