ÕªÒª£º HAVING COUNT(×Ö¶Î)ͳ¼Æ±íÖÐijһ×ֶγöÏֵĴÎÊý SELECT ×ֶΠFROM ±í GROUP BY ×ֶΠHAVING COUNT(×Ö¶Î) > 1 SELECT * FROM ±í WHERE ×ֶΠIN(SELECT ×ֶΠFROM ±í GROUP BY ×ֶΠHAVING COUNT( ÔĶÁÈ«ÎÄ
posted @ 2021-07-02 09:15 Camillezxl ÔĶÁ(1565) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º product ±í product_name¡¢spu¡¢create_datetime ÏëÒª²éÕÒÉÌÆ·Ãû³ÆÖаüº­¶ÌÐäµÄÉÌÆ·Ò»¹²ÓжàÉÙ¸ö select count£¨*£© from product where product_name like "%¶ÌÐä%" shop ±í ÖÐÓÐshop_name¡¢chann ÔĶÁÈ«ÎÄ
posted @ 2021-07-01 13:43 Camillezxl ÔĶÁ(31) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º #coding:utf-8 tuple_a = (1,2,3,4,3,2,1)#ÕÒ³ö²»Öظ´µÄÊý£¬²¢´òÓ¡³öÀ´ for i in range(len(tuple_a)):#°´³¤¶È±éÀúÁбí if tuple_a.count(tuple_a[i])==1:#²éÕÒtupleÖгöÏÖÒ»´ÎµÄÊý print(tupl ÔĶÁÈ«ÎÄ
posted @ 2021-07-01 13:30 Camillezxl ÔĶÁ(75) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º MYSQLÖпÉÒÔͨ¹ýÄÚÍâ¼üÁ´½Ó,½«ÓйØϵµÄ±íÖÐÊý¾ÝºÏ²¢µ½Ò»Æð½øÐÐÌõ¼þɸѡ: Ê×ÏÈ´´½¨Á½¸öбí,Êý¾ÝÈçÏÂ: student ±íÊý¾Ý: score ±íÊý¾Ý: ¿ÉÒÔ¿´µ½students±íÖÐstu_idΪ16048008µÄ¼Ç¼¶ÔÓ¦score±íûÓÐÊý¾Ý; 1.µ±½øÐÐÄÚÁ¬½Óʱ,ϵͳ»á×Ô¶¯ºöÂÔÁ½¸ö±íÖжÔÓ¦²»ÆðÀ´µÄ ÔĶÁÈ«ÎÄ
posted @ 2021-06-30 11:57 Camillezxl ÔĶÁ(160) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º #coding:utf-8 from bs4 import BeautifulSoup html = open("F:\\pythonScript\\jiashicang(1)\\jiashicang\\reports\\¼ÝÊ»²Õ½Ó¿Ú×Ô¶¯»¯²âÊÔ±¨¸æ2021-06-28.html", 'r', enco ÔĶÁÈ«ÎÄ
posted @ 2021-06-29 09:46 Camillezxl ÔĶÁ(63) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º 1. ÏÂÔØjdbcÇý¶¯£ºmysql-connector-java-8.0.25.jar 2. ½«ÏÂÔصÄÇý¶¯·Åµ½binĿ¼Ï£ºD:\apache-jmeter-5.3\apache-jmeter-5.3\bin 3. Ìí¼ÓjdbcÅäÖùÜÀíÆ÷ 4. ÉèÖñäÁ¿Ãû³Æ£ºaaa 5. Ìí¼ÓÊý¾Ý¿âÖ÷»úÃû¡¢¶Ë¿ÚºÅ¡¢ ÔĶÁÈ«ÎÄ
posted @ 2021-06-24 17:32 Camillezxl ÔĶÁ(94) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º 1. ´¦Àí²½Ö裬 µÚÒ»²½£¬Ìí¼Ó£ºHTTPÐÅϢͷ¹ÜÀíÆ÷£º µÚ¶þ²½£¬ÔÚHTTPÐÅϢͷ¹ÜÀíÆ÷ÖÐÌí¼Ó£º Content-Type£ºapplication/json;charset=UTF-8 µÚÈý²½£¬ÔÚÇëÇóÏûÏ¢Ìå²ÎÊýÖÐÌí¼Ó£º["PRODUCT_CATEGORY"] µÚËIJ½£¬Ôٴγ¢ÊÔÔËÐУº ºÃÀ²£¬½Ó¿ÚÇëÇó³É¹¦ ÔĶÁÈ«ÎÄ
posted @ 2021-06-24 14:42 Camillezxl ÔĶÁ(1445) ÆÀÂÛ(1) ÍƼö(0) ±à¼­
ÕªÒª£º 1. CSVÊý¾ÝÎļþÉèÖà 2. ÎļþÏêϸÄÚÈÝ 3. CSVÎÄ»¯ÄÚÈÝ CSVÅäÖÃÔª¼þµÄ×÷Ó㺴ÓÎļþÖжÁÈ¡±äÁ¿Öµ£¬ÓÃÓÚ±äÁ¿µÄ²ÎÊý»¯£¬¿ÉÉèÖöàÖÖ¶ÁÈ¡·½Ê½ ¸÷ÌîдÏî˵Ã÷£º 1. Ãû³Æ¡¢×¢ÊÍ£ºÔª¼þµÄÃû³Æ¼°×¢ÊÍ£¬¿É×Ô¶¨Òå 2. CSVÊý¾ÝÎļþÉèÖà 2.1. ÎļþÃû³Æ£º ×¢Ò⣺ÕâÀïÒª°üÀ¨ÎļþµÄ·¾¶£¬ÔÚ4.0°æ±¾ÖÐ ÔĶÁÈ«ÎÄ
posted @ 2021-06-24 14:19 Camillezxl ÔĶÁ(144) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º <!DOCTYPE html> <html> <head> <meta charset='utf-8'/> <meta name='description' content=''/> <meta name='robots' content='noodp, noydir'/> <meta name=' ÔĶÁÈ«ÎÄ
posted @ 2021-06-18 17:58 Camillezxl ÔĶÁ(40) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º #coding:utf-8 import pymysql#µ¼Èëmysql°ü import pymongo#µ¼ÈëMongoDB°ü #´ò¿ªMySQLÊý¾Ý¿âÁ´½Ó #»ñÈ¡Ò»¸öÊý¾Ý¿âÁ¬½Ó£¬×¢ÒâÈç¹ûÊÇUTF-8ÀàÐ͵ģ¬ÐèÒªÖƶ¨Êý¾Ý¿â #port ±ØÐëÊÇÊý×Ö²»ÄÜΪ×Ö·û´® db = pymysql.connect( ÔĶÁÈ«ÎÄ
posted @ 2021-06-15 09:46 Camillezxl ÔĶÁ(1297) ÆÀÂÛ(0) ÍƼö(0) ±à¼­