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

0 vote271 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote294 views1 answer
SQL Cut part string
SQL
0 vote282 views1 answer
To Create directory
SQL
0 vote267 views1 answer
Compression of dabatase mysqldumo
SQL
2 votes274 views1 answer
Q operator in sql
SQL
0 vote249 views1 answer
Sql random decimal
SQL
0 vote271 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote259 views2 answers
How to find max and min salary in sql
SQL
0 vote286 views1 answer
Get schema of table sql
SQL
1 vote267 views1 answer
Sql server locks
SQL