????2.3 ??????

?????????????????Query?????????????????????????洢????????е????????????????е????????????????????Щ??????????????д??????????к???AUTO_INCREMENT????Σ???????????д??????????????????ж?????Щ?????

??????????????

insert into i_node(name??value) values("sql"??"copy");

????????????????????????

| master-bin.000004 | 451 | Intvar      |         1 |         479 | INSERT_ID=12                                                                |
| master-bin.000004 | 479 | Query       |         1 |         596 | use `db_info`; insert into i_node(name??value) values("sql"??"copy")          |
+-------------------+-----+-------------+-----------+-------------+-----------------------------------------------------------------------------+

??????????????????????????Щ???????????????????д?????????????Щ????MySQL?????????????????????磺

????1??????????????????????insert???????????use db_info???????????????????????????????????????????????MYSQL???????????????????????

????2???????????????????????????????????????

mysql> set @value = 'copy-on-write';
Query OK?? 0 rows affected (0.00 sec)

mysql> insert into i_node(name??value) values("sql"??@value);
Query OK?? 1 row affected (0.00 sec)

?????????????????????????£?

| master-bin.000004 | 596 | Intvar      |         1 |         624 | INSERT_ID=13                                                                |
| master-bin.000004 | 624 | User var    |         1 |         675 | @`value`=_latin1 0x636F70792D6F6E2D7772697465 COLLATE latin1_swedish_ci     |
| master-bin.000004 | 675 | Query       |         1 |         792 | use `db_info`; insert into i_node(name??value) values("sql"??@value)          |

???????????????????????????????User var

????3??RAND()?????????????????????????????????????????????????????

????4????????

????5??AUTO_INCREMENT??ε????????????????????????????????????й??

????6??LAST_INSERT_ID??????

????7?????ID??????CORRENT_ID??????