mysql - 查询数据库的表字段

本文主要是介绍mysql - 查询数据库的表字段，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

1. 

-- mysql
select column_name from information_schema.columns where table_schema='SH_ERP' and TABLE_NAME = 'stock_quant'
select * from information_schema.columns where table_schema='SH_ERP' and TABLE_NAME = 'stock_quant';

-- pg
SELECT 
array_to_string(array_agg(a.attname),',')
FROM pg_class as c,pg_attribute as a where c.relname = 'stock_quant' and a.attrelid = c.oid and a.attnum>0

这篇关于mysql - 查询数据库的表字段的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！