Shell脚本中的MySQL查询

     sql1="select id,name from test where day = '2019-08-05'"

1.   result=`mysql -h ip -uroot -proot db_test -e "${sql1}"`

      echo "${result}"

查询结果出现id,name列名，并遍历结果

2.   增加 -N

     result=`mysql -h ip -uroot -proot db_test -N -e "${sql1}"`

     echo "${result}"

查询结果无列名，遍历结果

3.   查询mysql表字段名、字段类型、字段注释

select column_name,data_type,column_comment from information_schema.columns where table_name='test'

4.   查询mysql表主键

SELECT column_name FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE table_name='test'