2018-05-22 postgre-CRUD

2018-05-22  本文已影响0人  lucasdada

参考:
PostgreSQL 9.3.1 中文手册

查询:

select a,b,c from table_name where a=1

统计特定字段的总行数

select count(spec),spec from table_name where spec='dida' group by spec;

示例结果:

+-------+------------------+
| count | spec|
+-------+------------------+
| 8 | dida |
+-------+------------------+
1 row in set

上一篇下一篇

猜你喜欢

热点阅读