current position：Home>Database to query the quantity of books lent in this month. If it is higher than 10, it will display "more than 10 books lent in this month". Otherwise, it will display "less than 10 books lent in this month"
Database to query the quantity of books lent in this month. If it is higher than 10, it will display "more than 10 books lent in this month". Otherwise, it will display "less than 10 books lent in this month"
2022-06-24 08:48:29【CSDN Q & A】
database ,MySQL, The book management system
problem ： Query the quantity of books lent this month , If it is higher than 10 Ben Shi , Show “ The number of books lent this month is greater than 10 Ben ”, Otherwise, it will show “ Books lent this month are less than 10 Ben ”.
My code can already query the number of books lent this month ,
But the following display is greater than or less than 10 This statement will not write .
select b_id, (borrow.number) from borrow where (bodate)= (now()) group by b_id;
Thank you for your answer .
borrow： Table name
b_id： Book number
number： Number of books lent
bodate： Borrowing date
author[CSDN Q & A],Please bring the original link to reprint, thank you.
The sidebar is recommended
- Learn from your experience. PHP programming, especially urgent for beginners before 1:30
- The child container changes with the height of the parent container
- Prove the correctness of Dijkstra algorithm and analyze the time complexity
- How to sort the fields of TP withattr
- Why should numbers be underlined?
- Maximum coverage problem and location problem matlab
- Is there anyone who can help to simplify the procedure? It has been completed. Make it easier to understand?
- How to solve the database connection failure of Java eclipse
- Interface related problems of Java
- When HTML accesses the parent directory, the file content cannot be displayed normally in the browser after reading
guess what you like
Page Jump and database connection of student management system
VB listview does not display children
Mockito test case
The scrapy framework only gets a set of results. I don't know why (Language Python)
After the win10 computer turns on the hotspot, the mobile phone can access the Internet, but the computer can't.
How to embed tabelau in the front page of react
Code problems in Python
No pointer, structure, linked list to write student achievement management system
Linux CentOS process text management
Vue component communication data does not update rendering
- Python automation framework
- If you change K to *p in the fiind function, there will be no output. Why
- How to create a DLL.; '
- Program error, I don't know how to change it
- After setting the exchange mailbox in outlook2021, you can send and receive emails normally, but you often pop up to log in to Microsoft
- _ What are the application scenarios in Python
- Springcloud has problems using ribbon
- Excel VBA: how to save multiple worksheets to the same workbook
- Is the pre here a global variable?
- I'd like to ask you to look at the fault and how to return to normal.
- On object injection by spring5 framework
- About creating text files in the root directory
- Yolov5-5.0/6.0 how to change the video detection frame rate?
- Matlab encountered an infinite or non numeric value
- Automatic shutdown after Tomcat startup
- C language, about the macro parameter conversion of ＃ operator, a C language exercise
- Why is this problem caused by the bubbling method written in function? It can be run without function writing
- Python writing yaml file
- Please write down the following introduction to the router configuration interface and its implementation purpose: (this question needs to describe 3 screenshots) answer:
- Go operation SQLite code error
- What is the usage of:... In testcase() of unittest? What does any mean?
- main. c: (.Text+0xee): undefined reference to 'pop' collect2: error: LD returned 1 exit status
- C language! The run page will flash out when running!! Let's have a look!
- How to solve the problem of white screen flickering? Even if the transparent background is set
- What do the exponential forms E and e here mean
- Solving integral equations with variables
- What should I do if yanzhao.com can't get the link to the school website?
- A c++ question (multi school joint examination)
- How does the structure of Android project package into app?
- How does webstorm set the bootstrap auto prompt
- Why can't Kali start the machine
- missing operate system
- Luogu p1098 solution, sample can pass
- Although object f is an object created by the parent class, it is a constant and does not use the parent class to reference the child class object. Why can the override method value of the child class be output
- Wechat applet development error: do not use empty rulesets
- About C language: if an error occurs after deleting ch=getchar() in the first for loop
- How to solve the problem of Java?
- Why the 8-core 8g win7 32 virtual machine fails to recognize 4G memory after connecting to the virtual machine?
- Uni app calling interface click login operation does not take effect on the mobile terminal
- How to solve the problem of error 5321 in the mixed programming call of C ＃ and Halcon?