$sqlmin=select min(birth) as min_birth from person"; $sql = "select * from person where birth = min_birth";
birth如果是date类型的就用唠叨的语句就行
select name from person ORDER BY birth limit 1 ------------------------------------------------ mysql不支持order by和limit合用birth如果是date类型的就用唠叨的语句就行 ------------------------------------------- 其他类型也可以啊
Thank you all. "order by" and "limit" are also supported in mysql.
$smallname=$names[0];都可以.
$sql = "select * from person where birth = min_birth";
------------------------------------------------
mysql不支持order by和limit合用birth如果是date类型的就用唠叨的语句就行
-------------------------------------------
其他类型也可以啊
"order by" and "limit" are also supported in mysql.