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