设置了auto_increment怎么添加数据? 设置了auto_increment的列怎么添加数据? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql> create table t_Fire1949(id int auto_increment primary key, col int);Query OK, 0 rows affected (0.44 sec)mysql> -- 方法一,不指定:mysql> insert into t_Fire1949(col) values (100);Query OK, 1 row affected (0.06 sec)mysql> select * from t_Fire1949;+----+------+| id | col |+----+------+| 1 | 100 |+----+------+1 row in set (0.00 sec)mysql> -- 方法二,用 Null:mysql> insert into t_Fire1949(id,col) values (null,200);Query OK, 1 row affected (0.05 sec)mysql> select * from t_Fire1949;+----+------+| id | col |+----+------+| 1 | 100 || 2 | 200 |+----+------+2 rows in set (0.00 sec)mysql> -- 方法三, 用0:mysql> insert into t_Fire1949(id,col) values (0,200);Query OK, 1 row affected (0.05 sec)mysql> select * from t_Fire1949;+----+------+| id | col |+----+------+| 1 | 100 || 2 | 200 || 3 | 200 |+----+------+3 rows in set (0.00 sec)mysql> -- 方法四, 自行指定:mysql> insert into t_Fire1949(id,col) values (100,200);Query OK, 1 row affected (0.03 sec)mysql> select * from t_Fire1949;+-----+------+| id | col |+-----+------+| 1 | 100 || 2 | 200 || 3 | 200 || 100 | 200 |+-----+------+4 rows in set (0.00 sec)mysql> 当您的问题得到解答后请及时结贴.http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html 请问有什么方法把MyISAM 类型的表转换为InnoDB类型的吗 mysql的数据类型问题 在存储过程中使用事务 mysql query browser输入汉字重叠 MySQL插入大量数据太慢的问题 关于My SQL存储过程的问题,创建不了存储过程啊!!!急 MySQL中如何实现字段的自动增长? 急急急!如何把MYSQL的数据导出到TXT文本中啊! 请问以下,我现在要对mysql数据库中的多个表进行初始化数据,该怎么办? 关于自动生成字段序列的问题 会分析MYSQL错误日志的老大进来,帮帮我,求求你们! 求助mysql数据库定期自动数据转移
Query OK, 0 rows affected (0.44 sec)mysql> -- 方法一,不指定:
mysql> insert into t_Fire1949(col) values (100);
Query OK, 1 row affected (0.06 sec)mysql> select * from t_Fire1949;
+----+------+
| id | col |
+----+------+
| 1 | 100 |
+----+------+
1 row in set (0.00 sec)mysql> -- 方法二,用 Null:
mysql> insert into t_Fire1949(id,col) values (null,200);
Query OK, 1 row affected (0.05 sec)mysql> select * from t_Fire1949;
+----+------+
| id | col |
+----+------+
| 1 | 100 |
| 2 | 200 |
+----+------+
2 rows in set (0.00 sec)mysql> -- 方法三, 用0:
mysql> insert into t_Fire1949(id,col) values (0,200);
Query OK, 1 row affected (0.05 sec)mysql> select * from t_Fire1949;
+----+------+
| id | col |
+----+------+
| 1 | 100 |
| 2 | 200 |
| 3 | 200 |
+----+------+
3 rows in set (0.00 sec)mysql> -- 方法四, 自行指定:
mysql> insert into t_Fire1949(id,col) values (100,200);
Query OK, 1 row affected (0.03 sec)mysql> select * from t_Fire1949;
+-----+------+
| id | col |
+-----+------+
| 1 | 100 |
| 2 | 200 |
| 3 | 200 |
| 100 | 200 |
+-----+------+
4 rows in set (0.00 sec)mysql>
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html