??????????????????SQL????????
???????????? ???????[ 2016/2/29 11:39:43 ] ?????????????
?????????????ν??????
??????????????????????????????????????????????????????????????????????????Щ??????????ο?????????????????????????????????????????????????????????
????1. ?????[2002] ??????????????????????????????????????????????????????????????????????????????????????????????? ??????????б?????????????????????????????????????????
????2. ?????[1146] Table ‘bbbq’ doesn’t exist????????????????????飬???????????????б??????????????????д????? ??????????????????????????д?????
????3. ?????[1054] Unknown column ‘column_x’ in ‘field list’??????????????в??????????????У???д????????飡 ????? ????
????4. ?????[1366] Incorrect string value: ‘xA9x96′ for column ‘x_name’ at row 1??????????????????????gbk?????????????gb2312?????????????????????????????????????utf-8?????????????????
????5. ?????[1364] Field ‘pid’ doesn’t have a default value?????????????????????????????????????????δ???????null????Щ?????????????????????? ????? ??????????????????????not null ??????????????????Ч??
????6. ?????[1366] Incorrect integer value: ” for column ‘townId’ at row 1????????????????????????????????????????????????????????????????????????????? ??????Щ?汾??mysql??????????????????????????????????????????????????
????7. LOAD DATA INFILE ???????????????????????
????7.1. ?????[2] File ‘D:/wamp/www/a/area.csv’ not found (Errcode: 2)??????????????????csv??????????λ????????????????????????????????????????????δ???ɡ? ?????С????
????7.2. ?????[13] Can’t get stat of ‘/opt/app/mysql5/var/D:/wamp/www/a/area.csv’ (Errcode: 2)??????????????????????????????????web??????????????????????????LOCAL???????web??????????? ?????LOCAL?????????????????????????LOCAL????????????????????
????7.3. ?????[1366] Incorrect integer value: ‘????’ for column ‘provinceId’ at row 1??????????????ò??????ε???????????????????csv???????????????????????????????????к????????????????????????????????????????????и??????????????????????????????????????????????д??csv????????????Σ? ??????????1366 ??????1366 ?????????????
????7.4. ???LOAD?? LOAD DATA LOCAL INFILE ‘D:/wamp/www/a/area.csv’ REPLACE INTO TABLE `address` CHARACTER SET utf8 FIELDS TERMINATED BY ‘??’ (`provinceId`?? `provinceName`?? `cityId`?? `cityName`?? `areaId`?? `areaName`?? `townId`?? `townName`); ?????????????ζ???????????????????????’??'??
????8. [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LIMIT 0?? 1000′ at line 1?????????e??????????????????????????д????????? where a_id= order by id desc;??????????????????ID?????????????????ID????????????????????????????????????????????????????????????????????????????????????????????’='????”????????????intval()???????????????
????9. ????REPLACE??INSERT ?????????????????????????????REPLACE??????????д?????????????????????????ID???????????????????????????????????INSERT????????????????????UPDATE????????????????????????????
????…
??????????????У????????????????????????????????????????????????????????????·???????????????????????????????ο???
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
???????????SQL???SQL??й????е????????????mysql?????????????SQL??????????????mysql????? distinct?÷?MySQL?н???????????з??Mysql????????????????sql server 2000??????????????MySQL Cluster??δ??????????????SQL Server???????????????????λ?????PHP??SQL????????????????????????????SQL??????????SQLд?????SQL Server????????????????????????????????????SQL?????Pythonд???NoSQL?????
???·???
??????????????????
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????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????