???Mysql?????????????????
???????????? ???????[ 2016/3/21 10:32:30 ] ????????????? MySQL
????????mysql????????????????????????????????????????У??????????????????????????????ò?????????????????????????????????Щ?????????????????????????????????????????????
???????????????????????????????????????£??????????????Щ?£?
????1. ???????Сд(?????)
????mysql????????????????Сд??????????????????????Сд???????????????????????????Сд??????????????磺
????SELECT uid??v_state FROM all_user WHERE username = 'sunyue';
????SELECT uid??v_state FROM all_user WHERE USERNAME = 'sunyue'; //???????????????????β?????
????SELECT uid??v_state FROM all_user WHERE USERNAME = 'SUNYUE'; //?鯔?????????????????Сд
????2. ??????([_]??????????)
??????????????е????????????????????????????????????????????????????????????????????????????????sphinx??
????SELECT uid??v_state FROM all_user WHERE USERNAME LIKE 'su_yue'; //?????[_]????????????
????SELECT uid??v_state FROM all_user WHERE USERNAME LIKE 'su%yue'; //%????????????
????SELECT uid??v_state FROM all_user WHERE USERNAME NOT LIKE 'su%'; //not like????????????
????3. ?????2????????
????mysql????????????????????????????????????????о???????????????????????????????????????????????????????μó?????????????????????????????3??????????????????????????????mysql??????????????????????????????????????????д????????2??????????????????????????????????
????4. replace into ??
????replace into ???????????????????????????????????????б??????????Щ????????????д??????????????replace?? ????????Щ????????????????????????????????????ID???????????????????replace.
????5. insert into on dumplicate key update
???????д????????????????????????????????????????mysql?????????????????????????????ж????????????????????????????????????
????6. explain ??
????????????????Ч??????Ч??????????????????????????????????????????????????????????????????????????????????????????????????ж????д????????????????????????????????????????????????????????????????????????e??
????7. ????????
????myisam????????????1000????innodb????????????767???????????????????Χ???????????
????8. ??????
????1. ???????mysql??????????????????2. ?????????????????????????????????????3. ??ù???????????????о????????????
????9. ????
?????????Щ????????????????з??????????????????????????????????????????????????????????????????????????????????????
????10. ?????
????????????????????????????????????????????????????????????????????????????????????°?????
????11. binlog
????binlog?????????????????????????????????????????к????????
????12. ???????????????????洢????????...
?????????????????Щ?????Щ???????????????????????????????????????????????????????????漰?????漰????????????????????????????????????????????????
????13. ?????????
????phpMyAdmin?? ???????????????????????????????????????????????????????е????sqlyog?? ???????壬??????????????navicat?? ???????????????????????????????????????У???????ò??????????????????н??в?????????????????в?????????
????????????????????????????????????????????
??????
???·???
??????????????????
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