MySQL基本用法

1.查库：select  schea_name from information_schema.schemata

2.查表：select table_name from information_scema.tables where table_schema='security'

3.查列：select column_name from information_schema.columns where table_name='users'

4.查字段：select username,password from security.users