insert into是mysql中最常用的插入语句,它有6种写法。下面让我们一起来看一看吧:
mysql中insert into语句的6种写法(下)
http://blog.csdn.net/number1killer/article/details/77842472
1向原表中某些字段中插入一条记录。
语法:insert into +表名(表中的字段,,)value(字段所对应的记录,,);
mysql> select * from joke;
+------+-----------+-------+------+
| gid | name | sex | age |
+------+-----------+-------+------+
| 3 | xiaowan2 | male | 22 |
| 3 | xiaowan2 | male | 22 |
| 3 | xiaowan2 | male | 22 |
| 3 | xiaowan22 | 1male | 22 |
+------+-----------+-------+------+
4 rows in set (0.02 sec)
mysql> insert into joke (gid,name)value(0,"joker");
Query