MYSQL 查看语句001

最新推荐文章于 2023-12-07 10:12:49 发布

yelenn1115

最新推荐文章于 2023-12-07 10:12:49 发布

阅读量275

点赞数

分类专栏： SQL 綜合類文章标签： mysql

本文链接：https://blog.youkuaiyun.com/yelenn1115/article/details/118941836

版权

綜合類同时被 2 个专栏收录

5 篇文章

订阅专栏

SQL

1 篇文章

订阅专栏

SELECT COUNT(1) AS `ACTIVITY记录数`    FROM `ACTIVITY`;
SELECT COUNT(1) AS `VESSEL记录数`        FROM `VESSEL`;
SELECT COUNT(1) AS `CALL_PORT记录数`    FROM `CALL_PORT`;
SELECT COUNT(1) AS `EQP_CLASS记录数`    FROM `EQP_CLASS`;
SELECT COUNT(1) AS `EQP_STA_REF记录数`    FROM `EQP_STA_REF`;
SELECT COUNT(1) AS `EQP_TYPE_REF记录数` FROM `EQP_TYPE_REF`;

SELECT @rowno:=@rowno+1 AS `ACTIVITY记录数`,r.*    FROM `ACTIVITY` r ,(SELECT @rowno:=0) t;
SELECT @rowno:=@rowno+1 AS `VESSEL记录数`,r.*        FROM `VESSEL` r ,(SELECT @rowno:=0) t;
SELECT @rowno:=@rowno+1 AS `CALL_PORT记录数`,r.*    FROM `CALL_PORT` r ,(SELECT @rowno:=0) t;
SELECT @rowno:=@rowno+1 AS `EQP_CLASS记录数`,r.*    FROM `EQP_CLASS` r ,(SELECT @rowno:=0) t;
SELECT @rowno:=@rowno+1 AS `EQP_STA_REF记录数`,r.*    FROM `EQP_STA_REF` r ,(SELECT @rowno:=0) t;
SELECT @rowno:=@rowno+1 AS `EQP_TYPE_REF记录数`,r.* FROM `EQP_TYPE_REF` r ,(SELECT @rowno:=0) t;