- 查找表名
1
select table_name from information_schema.tables where table_schema='TSCHEMANAME' and table_type='base table'
其中SCHEMANAME为要查的数据库。
python获取表名:
1 |
|
- 查找列名
1
SELECT column_name FROM information_schema.Columns WHERE table_name=%s AND table_schema=%s"
其中第一个变量为表名,第二个变量为数据库名。
python获取列名:
1 |
def get_table_columns(cursor, table_name, schema_name): |
- 拼接全局查找sql
全局查找的sql样式:
1
select * from TABLE where `id` like "%COLUMN%" or `name` like "%COLUMN%" ...
python拼接:
1 |
def get_global_select_sql(table_name, word): |
拼接好的sql如下所示:
1 |
select * from TABLE where `id` like '%WORD%' or `title` like '%WORD%' or `author` like '%WORD%' or `ISBN` like '%WORD%' or `publisher` like '%WORD%' or `publisherDateStr` like '%WORD%' or `publisherDate` like '%WORD%' or `description` like '%WORD%' or `price` like '%WORD%' or `eBookPrice` like '%WORD%' or `currency` like '%WORD%' or `rating` like '%WORD%' or `thumb` like '%WORD%' or `thumb1` like '%WORD%' or `fromlink` like '%WORD%' or `indexTimes` like '%WORD%' or `verify` like '%WORD%' or `isPub` like '%WORD%' or `memo` like '%WORD%' or `status` like '%WORD%' or `createUser` like '%WORD%' or `createDate` like '%WORD%' or `updateUser` like '%WORD%' or `updateDate` like '%WORD%' |
近期评论