??????MySQL insert????
???????????? ???????[ 2012/10/24 10:40:36 ] ????????
?????????Щ??????????????????????????????Ч????£???????????????????????????????????????????????????????????4-5???????????????????????з??????????????????????????????????????????顣??????????????????MySQL insertЧ??????б?????
??????????MySQL???????????Щ???????insertЧ?????????????ο??ο???
????1?????SQL??????????????
????????????????磺
INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`) VALUES ('0'?? 'userid_0'?? 'content_0'?? 0);
INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`) VALUES ('1'?? 'userid_1'?? 'content_1'?? 1);
?????????
INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`) VALUES ('0'?? 'userid_0'?? 'content_0'?? 0)?? ('1'?? 'userid_1'?? 'content_1'?? 1);
????????????????????????????Ч???????????SQL???Ч????????????????????????SQL??????????????????????????????????????????????SQL????????????????紫???IO??
???????????Щ??????????????????е?????????????????????SQL?????е?????????1???1???1????????????
????2?????????н??в??????
??????????????
START TRANSACTION;
INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`) VALUES ('0'?? 'userid_0'?? 'content_0'?? 0);
INSERT INTO `insert_table` (`datetime`?? `uid`?? `content`?? `type`) VALUES ('1'?? 'userid_1'?? 'content_1'?? 1);
...
COMMIT;
?????????????????????????Ч?????????????????INSERT???????MySQL????????????????????????????????????????????????????????????????????в???????к?????????????
????????????????????????????????????????????????1???1???1????????
????????????
????????????????????????????????INSERTЧ????????????????????????????SQL?????????????н??в???
????????????????????insert??Ч??????50????????????????????????
???????????
????1??SQL??????г???????????????????????SQL???????????SQL????????????max_allowed_packe????????????????1M??
????2??????????????С??????????????????е?Ч???MySQL??innodb_log_buffer_size?????????????????????????????????????Ч??????????????????????????????????С??????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11