Hi!
I’m doing one Project in vb.net 2008 using mysql .In that
Project have the following Issues..
1.if one Employee getting Salary 1.2 lacs / annum means ..
After he getting 1st month Salary i want to show remaining
11 month salary.. How can i Create Trigger for this Problem
& How can i use it..
- 1 Answers
- 2483 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram gopal verma
select * from employee where empdate BETWEEN DATE_FORMAT(NOW(), '%Y-01-%d') AND DATE_FORMAT(NOW() ,'%Y-05-%d')
Note- I u want (%Y-01-%d) means show February month to (%Y-05-%d) June months.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are programming functions?
What does blob mean in mysql?
How do you backup a database in mysql?
What are the differences between binary and varbinary?
Can mysql handle big data?
What is pdo connection?
What is procedure in mysql?
What does mysql flush hosts do?
What are the other commands to know the structure of a table using mysql commands except explain command?
What is mysql data directory? How to determine the location of the data directory?
What is mysql server?
How do I start mysql database?
Why MySQL is used?
How to show certain selected rows with the value "pcds".
How large can a mysql table be?
