Mysql calcular idade

SELECT * 
FROM alunos a 
INNER JOIN matriculas m ON m.numero_matricula = a.numero_matricula 
WHERE YEAR(FROM_DAYS(TO_DAYS(m.data_matricula) - TO_DAYS(a.alunascimento))) < 17

Mysql calcular idade

SELECT
    YEAR(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(nascimento))) AS idade
FROM
    clientes

Source: pt.stackoverflow.com

Similar codes

37 votes235 views6 answers
Mysql update
SQL
11 votes199 views2 answers
How to import mysql database command line
SQL
0 vote206 views1 answer
Systems sql
SQL
0 vote181 views1 answer
Oracle remove line breaks
SQL
3 votes182 views1 answer
Sql case update
SQL
0 vote194 views1 answer
Mysqldump don't drop table
SQL
14 votes236 views1 answer
Excel is not a database
SQL
0 vote228 views1 answer
Automated psql csv export script on windows
SQL
1 vote189 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote178 views1 answer
Mysql date minus 1 day
SQL