mysql 查詢字段匹配,mysql怎么查詢最新一條的數(shù)據(jù)?
題主未給出數(shù)據(jù)庫(kù)結(jié)構(gòu),寫一個(gè)通用的,根據(jù)實(shí)際結(jié)構(gòu)套用。
select [字段名列表] from [數(shù)據(jù)表名] where [條件] order by [id] desc limit 1
題主未給出數(shù)據(jù)庫(kù)結(jié)構(gòu),寫一個(gè)通用的,根據(jù)實(shí)際結(jié)構(gòu)套用。
select [字段名列表] from [數(shù)據(jù)表名] where [條件] order by [id] desc limit 1