获取mysql所有表中的字段
#!/bin/bash db_name="zabbix"mysql_user="root"
mysql_passwd="zabbix"
table_name=`mysql -u$mysql_user -p$mysql_passwd -e "select table_name from information_schema.tables where table_schema='$db_name' and table_type='base table';"|grep -v table_name`
for a in $table_name
do
#列显示
#mysql_char=`mysql -u$mysql_user -p$mysql_passwd -e "select * from $db_name.$alimit 1;"|sed -n "1p"|awk '{for(i=1;i
页:
[1]