Question

如果在我sql的表格中有一栏名/外地名称,是否有办法查询数据库?

Answer 1

利用信息数据库及其表格。

例:

    SELECT *
FROM   information_schema.columns
WHERE  table_schema =  MY_DATABASE 
       AND column_name IN (  MY_COLUMN_NAME  );

Answer 2

如果你想在整个数据库中搜寻,那么你应尝试尝试。

SELECT * 
FROM information_schema.COLUMNS 
WHERE 
    TABLE_SCHEMA =  db_name  
AND COLUMN_NAME =  column_name

如果你想在某个桌旁搜寻,那么你就应当尝试。

SELECT * 
FROM information_schema.COLUMNS 
WHERE 
    TABLE_SCHEMA =  db_name  
AND TABLE_NAME =  table_name  
AND COLUMN_NAME =  column_name

Answer 3

SHOW COLUMNS FROM tablename LIKE  columnname

have!

www.un.org/spanish/ga/president

如评论意见所述,这一查询仅提供一个表格,而不是整个数据库(每张表格)。在这种情况下,请参看DhruvPathak的答复。

Answer 4

如果你想在以下电线之后再搜索两栏或两栏以上。

 SELECT DISTINCT TABLE_NAME 
        FROM INFORMATION_SCHEMA.COLUMNS
        WHERE COLUMN_NAME IN ( columnA , ColumnB )
            AND TABLE_SCHEMA= YourDatabase ;

友情链接