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..
Answer / 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 |
How many rows can be inserted in mysql at a time?
How to upload a large file through phpmyadmin in mysql?
Is number a datatype in mysql?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
How do you login to MySql using Unix shell?
What is root password?
What is tee command in mysql?
What is the difference between procedure and function in mysql?
How do I assign a variable in mysql?
What is ISAM?
What is query design?