TypechoJoeTheme

EYblog - Powered by Eyblog

统计
登录
用户名
密码

郑先森灬

世上没有偶然,有的只是必然,正面面对困难,才能迈向成功。
网站页面

【技术解读】MYSQL查询每年每月每日总量


sql 语句解析

  1. date(create_date): 将日期格式化为 2000-01-01这种格式
  2. curdate() :获取当前日期 2020-06-30 等同于 date(now())
  3. date_sub(curdate(), interval 7 day): 获取7天前的日期

统计每年的订单量

SELECT YEAR(create_date) as year,COUNT(1) as count FROM orders  GROUP BY year;

统计今年每个月的订单量

SELECT MONTH(create_date) as month,COUNT(1) as count FROM orders WHERE YEAR(create_date) = YEAR(NOW()) GROUP BY month ORDER BY month;

统计今年每周的订单量

SELECT WEEK(create_date) as week,COUNT(1) as count FROM orders WHERE YEAR(create_date) = YEAR(NOW()) GROUP BY week ORDER BY week;

统计今年每日的订单量

select DATE_FORMAT(createtime,'%Y-%m-%d') as days,count(*) count from ibt_shop_order group by days;
赞(0)
版权属于:

EYblog - Powered by Eyblog

本文链接:

https://akxdz.com/index.php/archives/90/(转载时请注明本文出处及文章链接)

评论 (67)
  1. Richardheest 作者
    Windows 8 · Google Chrome

    finasteride without doctor buy propecia finasteride where to buy propecia online

    2022-05-16 回复
  2. Richardheest 作者
    Windows 7 · Google Chrome

    buy prescription drugs from india prescription drugs without doctor approval prescription drugs

    2022-05-14 回复
  3. Richardheest 作者
    Windows 10 · Google Chrome

    generic ed drugs ed medications best ed medication

    2022-05-12 回复
  4. Nathannus 作者
    Windows 7 · Google Chrome

    generic over the counter prednisone prednisone for sale prednisone cost in india

    2022-05-10 回复
  5. Nathannus 作者
    Windows 10 · Google Chrome

    stromectol buy online uk stromectol price uk buy stromectol online uk

    2022-05-09 回复
  6. Nathannus 作者
    Windows 10 · Google Chrome

    buy cialis without prescription cialis usa prescription is there a generic cialis available in the us

    2022-05-07 回复
  7. Nathannus 作者
    Windows 8 · Google Chrome

    stromectol drops stromectol covid 19 stromectol tablets 3 mg

    2022-05-06 回复
  8. RobertUSELS 作者
    Windows 8 · Google Chrome

    buy stromectol 6 mg online buy stromectol 6 mg online stromectol lotion

    2022-05-02 回复
  9. RobertUSELS 作者
    Windows 10 · Google Chrome

    stromectol tablets for humans stromectol tablets uk buy stromectol canada

    2022-05-01 回复
  10. RobertUSELS 作者
    Windows 7 · Google Chrome

    erectial disfunction medicine for ed best erectile dysfunction pills

    2022-04-30 回复
  11. RobertUSELS 作者
    Windows 10 · Google Chrome

    canada drugs cialis get cialis to work mail order and cialis

    2022-04-28 回复
  12. Victortoisa 作者
    Windows 10 · Google Chrome

    do i have ed erectile dysfunction medicines medicine for ed

    2022-04-25 回复
  13. Victortoisa 作者
    Windows 7 · Google Chrome

    online ed pills pharmacy online what causes ed

    2022-04-24 回复
  14. Victortoisa 作者
    Windows 7 · Google Chrome

    cheap ed medication canadian drug prices best ed treatment

    2022-04-22 回复
  15. JasonDaync 作者
    Windows 7 · Google Chrome

    buy generic doxycycline 40mg buying doxycycline online cost doxycycline tablets uk

    2022-04-21 回复
  16. JasonDaync 作者
    Windows 10 · Google Chrome

    prescription without a doctor's prescription ed treatments that really work erection problems

    2022-04-20 回复
  17. JasonDaync 作者
    Windows 7 · Google Chrome

    50 mg clomid capsules clomid online order no script 75 mg clomid

    2022-04-18 回复
  18. Josephboime 作者
    Windows 8 · Google Chrome

    doxycyline 40mg doxycycline online online doxycycline

    2022-04-17 回复
  19. Josephboime 作者
    Windows 10 · Google Chrome

    prednisone over the counter south africa prednisone 10 mg canada buy prednisone online canada

    2022-04-15 回复
  20. Josephboime 作者
    Windows 8.1 · Google Chrome

    prednisone 50 mg tablet cost prednisone 50 mg canada buy 10 mg prednisone

    2022-04-14 回复
  21. Josephboime 作者
    Windows 10 · Google Chrome

    how to get doxycycline without prescription doxycycline buy online india doxycycline medication

    2022-04-13 回复
  22. RichardVen 作者
    Windows 8.1 · Google Chrome

    when to take cialis 20mg generic cialis available in canada cheap real cialis

    2022-04-09 回复
  23. Dadhar 作者
    Windows 8.1 · Google Chrome

    stromectol online ivermectin purchase traitement gale stromectol

    2022-04-06 回复
  24. JaDiAl 作者
    Windows 8.1 · Google Chrome

    whats better cialis viagra or levitra tadafil cialis generic cialis 200 mg

    2022-04-03 回复
  25. Jasonbof 作者
    Windows 7 · Google Chrome

    how long is viagra effective what does viagra do to women how much does viagra cost at walmart?

    2022-03-29 回复
  26. Jasonbof 作者
    Windows 10 · Google Chrome

    buy clomid 50mg online uk buy generic clomid cheap can i buy clomid online in australia

    2022-03-27 回复
  27. Daviddum 作者
    Windows 7 · Google Chrome

    prescription for amoxicillin amoxicillin 30 capsules price buy amoxicillin 500mg canada

    2022-03-25 回复
  28. Daviddum 作者
    Windows 8.1 · Google Chrome

    can i buy doxycycline over the counter in europe doxycycline vibramycin can i purchase doxycycline over the counter

    2022-03-23 回复
  29. Daviddum 作者
    Windows 8.1 · Google Chrome

    clomid 25mg order clomid online india clomid nz

    2022-03-21 回复
  30. Marcusthake 作者
    Windows 10 · Google Chrome

    how much is ivermectin ivermectin safety ivermectin overdose in cats

    2022-03-19 回复
  31. Marcusthake 作者
    Windows 10 · Google Chrome

    trial site news ivermectin ivermectin bed bugs ivermectin for alpacas

    2022-03-18 回复
  32. Marcusthake 作者
    Windows 7 · Google Chrome

    does oral ivermectin kill demodex mites ivermectin for snake mites buy ivermectin tablets

    2022-03-16 回复
  33. Jameselirl 作者
    Windows 8 · Google Chrome

    buy original cialis online viagra cialis viagra no prescription cialis

    2022-03-13 回复
  34. Jameselirl 作者
    Windows 8.1 · Google Chrome

    cialis no prescriptuin cialis online cheap bye cialis online from usa

    2022-03-12 回复
  35. Russellepife 作者
    Windows 7 · Google Chrome

    stromectol tablets uk buy ivermectin pills stromectol for humans

    2022-03-10 回复
  36. Russellepife 作者
    Windows 7 · Google Chrome

    paxlovid drug interactions list molnupiravir brand name paxlovid ingredients

    2022-03-09 回复
  37. Russellepife 作者
    Windows 8.1 · Google Chrome

    molnupiravir generic monulpiravir molnupiravir delta

    2022-03-08 回复
  38. Russellepife 作者
    Windows 7 · Google Chrome

    molnupiravir price in india molnupiravir drug price new covid drug

    2022-03-07 回复
  39. Russellepife 作者
    Windows 7 · Google Chrome

    molnupiravir delta molnupiravir capsules 200 mg price in india molnupiravir price in usa

    2022-03-06 回复
  40. Stevenprish 作者
    Windows 10 · Google Chrome

    is cialis better than viagra viagra experiences first time how long does it take for viagra to work

    2022-03-03 回复
  41. Stevenprish 作者
    Windows 8.1 · Google Chrome

    is viagra covered by health insurance does viagra make you last longer how much does viagra cost at walgreens

    2022-03-02 回复
  42. MathewMiz 作者
    Windows 10 · Google Chrome

    doxycycline hyc buy doxycycline 100mg - doxycycline order online
    https://doxycyline1st.com/# buy cheap doxycycline online

    2022-03-01 回复
  43. MathewMiz 作者
    Windows 7 · Google Chrome

    online doxycycline how to order doxycycline - generic doxycycline
    https://doxycyline1st.com/# doxycycline online

    2022-02-28 回复
  44. MathewMiz 作者
    Windows 8.1 · Google Chrome

    doxycycline 50 mg doxycycline vibramycin - buy doxycycline online without prescription
    https://doxycyline1st.com/# doxycycline vibramycin

    2022-02-26 回复
  45. Jamesdor 作者
    Windows 7 · Google Chrome

    clomid treats clomid alcohol - generic for clomid
    https://clomiphene1st.com/# purchase clomid

    2022-02-25 回复
  46. Stevenvap 作者
    Windows 10 · Google Chrome

    https://stromectolis.com/# stromectol covid 19

    2022-02-22 回复
  47. Stevenvap 作者
    Windows 7 · Google Chrome

    https://stromectolis.com/# ivermectin 3 mg

    2022-02-22 回复
  48. Stevenvap 作者
    Windows 10 · Google Chrome

    https://stromectolis.com/# ivermectin 6mg dosage

    2022-02-21 回复
  49. Stevenvap 作者
    Windows 10 · Google Chrome

    https://stromectolis.com/# buy stromectol online uk

    2022-02-21 回复
  50. Stevenvap 作者
    Windows 8.1 · Google Chrome

    https://stromectolis.com/# ivermectin 5 mg price

    2022-02-21 回复
  51. Stevenvap 作者
    Windows 7 · Google Chrome

    https://stromectolis.com/# ivermectin brand

    2022-02-21 回复
  52. Stevenvap 作者
    Windows 10 · Google Chrome

    https://stromectolis.com/# stromectol 3mg cost

    2022-02-20 回复
  53. Stevenvap 作者
    Windows 10 · Google Chrome

    https://stromectolis.com/# buy ivermectin uk

    2022-02-20 回复
  54. Chrisskelf 作者
    Windows 7 · Google Chrome

    stromectol nz: buy stromectol - stromectol
    https://stromectolst.com/# cost of ivermectin cream
    generic stromectol ivermectin how much does ivermectin cost

    2022-02-18 回复
  55. Chrisskelf 作者
    Windows 7 · Google Chrome

    ivermectin 3 mg tabs: buy ivermectin - ivermectin 80 mg
    http://stromectolst.com/# ivermectin buy
    ivermectin otc stromectol for sale stromectol coronavirus

    2022-02-17 回复
  56. Georgelajow 作者
    Windows 10 · Google Chrome

    where can i buy paxlovid cheap paxlovid buy paxlovid
    https://myalliancehealthcare.online/ movfor
    buy molnupiravir buy molnupiravir movfor

    2022-02-16 回复
  57. Georgelajow 作者
    Windows 10 · Google Chrome

    movfor buy molnupiravir online where to get molnupiravir
    https://apollobgshospitalsmysore.online/ paxlovid price
    paxlovid price cheap paxlovid paxlovid cost

    2022-02-16 回复
  58. Georgelajow 作者
    Windows 10 · Google Chrome

    paxlovid price where can i buy paxlovid cheap paxlovid
    https://apollobgshospitalsmysore.online/ buy paxlovid
    molnupiravir india buy molnupiravir where can i get molnupiravir

    2022-02-16 回复
  59. Georgelajow 作者
    Windows 7 · Google Chrome

    where can i get paxlovid cheap paxlovid paxlovid for sale
    https://apollobgshospitalsmysore.online/ buy paxlovid online
    molnupiravir for sale where to get molnupiravir molnupiravir

    2022-02-15 回复
  60. JamesAmand 作者
    Windows 7 · Google Chrome

    best canadian pharmacy online cvs prescription prices without insurance prescription drugs
    https://without-prescription-online.online/ how to get prescription drugs without doctor
    non prescription ed drugs ed meds online without doctor prescription prescription drugs online without doctor

    2022-02-12 回复
  61. JamesAmand 作者
    Windows 7 · Google Chrome

    comfortis without vet prescription legal to buy prescription drugs from canada carprofen without vet prescription
    https://without-prescription-online.com/ buy canadian drugs
    buy prescription drugs without doctor mexican pharmacy without prescription buy canadian drugs

    2022-02-12 回复
  62. JamesAmand 作者
    Windows 10 · Google Chrome

    pet meds without vet prescription canada prescription drugs online amoxicillin without a doctor's prescription
    https://without-prescription-online.online/ pain meds without written prescription
    canada ed drugs canada ed drugs prescription drugs online without

    2022-02-11 回复
  63. GrantTOT 作者
    Windows 10 · Google Chrome

    where can i get zithromax zithromax online pharmacy canada zithromax online pharmacy canada
    https://azithromycin1st.com/ where can i get zithromax over the counter
    buy zithromax online cheap how much is zithromax 250 mg zithromax generic cost

    2022-02-10 回复
  64. GrantTOT 作者
    Windows 10 · Google Chrome

    zithromax for sale online zithromax order online uk buy zithromax 1000 mg online
    https://azithromycin1st.com/ can you buy zithromax over the counter in australia
    buy zithromax canada zithromax cost zithromax 500 mg lowest price online

    2022-02-10 回复
  65. GrantTOT 作者
    Windows 10 · Google Chrome

    zithromax online pharmacy canada generic zithromax medicine zithromax online usa no prescription
    https://azithromycin1st.com/ zithromax generic price
    zithromax 250mg buy zithromax without prescription online order zithromax over the counter

    2022-02-09 回复
  66. GrantTOT 作者
    Windows 10 · Google Chrome

    zithromax online usa zithromax 250 mg buy zithromax 500mg online
    https://azithromycin1st.com/ zithromax cost australia
    zithromax antibiotic without prescription zithromax 500mg zithromax prescription online

    2022-02-09 回复
  67. AaronSoivy 作者
    Windows 7 · Google Chrome

    where to buy ivermectin pills stromectol ivermectin for humans - ivermectin 12
    http://stromectolabc.com/ buy stromectol canada
    ivermectin over the counter canada stromectol ivermectin for humans stromectol 3 mg price

    2022-02-06 回复
郑先森灬
世上没有偶然,有的只是必然,正面面对困难,才能迈向成功。
24 文章数
25,899 评论量

人生倒计时

今日已经过去小时
这周已经过去
本月已经过去
今年已经过去个月