Question

mysql查询表中一共多少条数据

Answer 1

select
count(表中任意属性名，如name)
from
[table_name];
比如说我有一张state的表，它由姓名年龄构成
select
count(name)
from
state;
希望能帮到你