记录一些有用的SQL

https://www.cnblogs.com/Alwaysbecoding/p/6959262.html
//查询所有表的所有字段：
select * from information_schema.columns where table_name='sys_users'

//查询指定表的所有字段：
select * from information_schema.columns where table_name='sys_users' and TABLE_SCHEMA='taoke'

//查询所有含有此字段名的表：
SELECT * FROM information_schema.columns WHERE column_name='name';

//查询指定数据库含有此字段名的表：
SELECT * FROM information_schema.columns WHERE column_name='name' and TABLE_SCHEMA='wljdb';

//查询指定表数据库指定表的所有字段
select column_name from information_schema.COLUMNS where table_name='sys_users' and TABLE_SCHEMA='taoke';

//查询指定表数据库指定表的第二个字段名：
select column_name from information_schema.COLUMNS where table_name='sys_users' and TABLE_SCHEMA='taoke' LIMIT 1,1

TRANSLATE with x

English

Arabic	Hebrew	Polish
Bulgarian	Hindi	Portuguese
Catalan	Hmong Daw	Romanian
Chinese Simplified	Hungarian	Russian
Chinese Traditional	Indonesian	Slovak
Czech	Italian	Slovenian
Danish	Japanese	Spanish
Dutch	Klingon	Swedish
English	Korean	Thai
Estonian	Latvian	Turkish
Finnish	Lithuanian	Ukrainian
French	Malay	Urdu
German	Maltese	Vietnamese
Greek	Norwegian	Welsh
Haitian Creole	Persian

 

TRANSLATE with

COPY THE URL BELOW

Back

EMBED THE SNIPPET BELOW IN YOUR SITE

Enable collaborative features and customize widget: Bing Webmaster Portal

Back