sql常用语句

1、查询表有多少字段:select count(*) from information_schema.`COLUMNS` where table_schema='db_master_fyd' and table_name='t_reg_loanaccounttitle'

posted @ 2016-09-28 19:05  成风魄郎  阅读(103)  评论(0编辑  收藏  举报