+ 1

How to write sql query?

to comparing date and month for selecting upcoming birthday list in the only current month using substring for fetching in the gridview......share me..who knows related queries please https://www.sololearn.com/discuss/1390307/?ref=app

7th Jul 2018, 5:34 AM
DODDABASAPPA
DODDABASAPPA - avatar
16 Antworten
+ 7
date, month means if date_column and month_column . If the column is enlisted as birthday as a whole, use date (birthday) and month (birthday)
16th Jul 2018, 4:12 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 9
mark first one as the answer
16th Jul 2018, 5:25 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 9
shene What do you mean
17th Jul 2018, 2:11 PM
Siddharth Golecha
Siddharth Golecha - avatar
+ 6
do you want to compare date and month of today with the date and month provided in the database for birthdays. And if both match return Happy birthday as a message?
16th Jul 2018, 3:52 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 6
do you want to show this message in java or in mysql or other language?
16th Jul 2018, 4:00 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 6
use this link to connect your asp.net to mysql https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-asp-roles.html and query for mysql is select date, month from database_name where date=date(curdate())&&month=month(curdate()); Edit : date, month means if date_column and month_column . If the column is enlisted as birthday as a whole, use date (birthday) and month (birthday)
16th Jul 2018, 4:08 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 6
Welcome
16th Jul 2018, 5:23 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 6
And mark my post as the answer
16th Jul 2018, 5:23 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 5
are you working in MySQL?
16th Jul 2018, 3:59 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 1
tysm 😣
16th Jul 2018, 4:24 AM
DODDABASAPPA
DODDABASAPPA - avatar
+ 1
👍
16th Jul 2018, 5:24 AM
DODDABASAPPA
DODDABASAPPA - avatar
0
yes
16th Jul 2018, 3:58 AM
DODDABASAPPA
DODDABASAPPA - avatar
0
yes
16th Jul 2018, 3:59 AM
DODDABASAPPA
DODDABASAPPA - avatar
0
asp.net
16th Jul 2018, 4:01 AM
DODDABASAPPA
DODDABASAPPA - avatar
0
i dont know
17th Jul 2018, 2:10 PM
shene
- 1
do you know any related queries ....?
16th Jul 2018, 3:59 AM
DODDABASAPPA
DODDABASAPPA - avatar