Fortune Telling Collection - Horoscope - MYSQL knows the date of birth, how to query the age?
MYSQL knows the date of birth, how to query the age?
1, select id, name, salary, year (birthday)-year (now ()) as age, and department from mm;
2. update mm set salary = (select * from (select AVG (salary) from mm) to tmp), where dept =1003;
3. Select left(aa,100) from tbname;
-Entertainment > Constellation/Fortune
The part of your question is wrong.
- Previous article:Protect your lover's personal data
- Next article:Wang Yufeng's name is very meaningful. What about the name Wang Yufeng?
- Related articles
- Jimmy Lin's wife.
- My god, these constellations are so lucky.
- What's the name of the hero in Meng Xueyuan 2?
- Which constellation man is most infatuated with Taurus girls?
- Who in the zodiac can do it by themselves, or like to do everything by themselves?
- These constellations eat with food videos, which are enjoyed by both eyes and mouth.
- Attractive space. Tell me about it.
- Virgo's rising sign ~? Urgent! ! ! ! ! ! ! !
- Gynecological constellation analysis
- The legend of the goddess mending the sky (detailed explanation)