最新公告
  • 欢迎您光临码农资源网,本站秉承服务宗旨 履行“站长”责任,销售只是起点 服务永无止境!加入我们
  • 从 MySQL 数据库获取约束列表?

    从 mysql 数据库获取约束列表?

    要从 MySQL 数据库获取约束列表,请使用以下语法 –

    select *from information_schema.table_constraints where constraint_schema = 'yourDatabaseName';

    在这里,我们将从数据库“business”中获取约束。以下是列出数据库“business”中所有表的约束的查询 –

    mysql> select *
       −> from information_schema.table_constraints
       −> where constraint_schema = 'business';

    以下是显示所有约束的输出 –

    +--------------------+-------------------+--------------------------+--------------+------------------------------+-----------------+
    | CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME          | TABLE_SCHEMA | TABLE_NAME                   | CONSTRAINT_TYPE |
    +--------------------+-------------------+--------------------------+--------------+------------------------------+-----------------+
    | def                | business          | PRIMARY                  | business     | primarytable                 | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | primarytable1                | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | autoincrementtable           | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | demoauto                     | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | autoincrement                | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | primarytabledemo             | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | sequencedemo                 | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | updtable                     | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | transcationdemo              | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | triggedemo                   | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | usernameandpassworddemo      | PRIMARY KEY     |
    | def                | business          | UserId                   | business     | usernameandpassworddemo      | UNIQUE          |
    | def                | business          | PRIMARY                  | business     | tblp                         | PRIMARY KEY     |
    | def                | business          | name                     | business     | uniquedemo                   | UNIQUE          |
    | def                | business          | name                     | business     | uniqueconstdemo              | UNIQUE          |
    | def                | business          | PRIMARY                  | business     | keydemo                      | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | nextiddemo                   | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | tablepri                     | PRIMARY KEY     |
    | def                | business          | ConstFK                  | business     | tabledemo2                   | UNIQUE          |
    | def                | business          | ConstFK                  | business     | tabledemo3                   | UNIQUE          |
    | def                | business          | PRIMARY                  | business     | college                      | PRIMARY KEY     |
    | def                | business          | id                       | business     | uniquedemo1                  | UNIQUE          |
    | def                | business          | id                       | business     | uniqueautoid                 | UNIQUE          |
    | def                | business          | PRIMARY                  | business     | schemadatabasemethoddemo     | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | employeeinformation          | PRIMARY KEY     |
    | def                | business          | name                     | business     | addingunique                 | UNIQUE          |
    | def                | business          | PRIMARY                  | business     | parentdemo                   | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | lastinsertrecordiddemo       | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | demoindex                    | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | compositeprimarykey          | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | addingautoincrement          | PRIMARY KEY     |   
    | def                | business          | Id                       | business     | uniqueconstrainttable        | UNIQUE          |
    | def                | business          | PRIMARY                  | business     | mergedemo1                   | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | mergedemo2                   | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | foreigntable1                | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | twoprimarykeytabledemo       | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | showconstraintsdemo          | PRIMARY KEY     |
    | def                | business          | BookAuthor               | business     | showconstraintsdemo          | UNIQUE          |
    | def                | business          | PRIMARY                  | business     | autoincrementtozero          | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | altertabletoaddautoincrement | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | addingprimarykeydemo         | PRIMARY KEY     |
    | def                | business          | PRIMARY                  | business     | resetprimarykey              | PRIMARY KEY     |
    | def                | business          | constFKPK                | business     | foreigntable                 | FOREIGN KEY     |
    | def                | business          | FKConst                  | business     | foreigntabledemo             | FOREIGN KEY     |
    | def                | business          | ConstFK                  | business     | tblf                         | FOREIGN KEY     |
    | def                | business          | StudCollegeConst         | business     | studentenrollment            | FOREIGN KEY     |
    | def                | business          | ConstChild               | business     | childdemo                    | FOREIGN KEY     |
    | def                | business          | primarytable1demo_ibfk_1 | business     | primarytable1demo            | FOREIGN KEY     |
    +--------------------+-------------------+--------------------------+--------------+------------------------------+-----------------+
    48 rows in set, 2 warnings (0.24 sec)
    想要了解更多内容,请持续关注码农资源网,一起探索发现编程世界的无限可能!
    本站部分资源来源于网络,仅限用于学习和研究目的,请勿用于其他用途。
    如有侵权请发送邮件至1943759704@qq.com删除

    码农资源网 » 从 MySQL 数据库获取约束列表?
    • 1034会员总数(位)
    • 20140资源总数(个)
    • 1043本周发布(个)
    • 30 今日发布(个)
    • 141稳定运行(天)

    提供最优质的资源集合

    立即查看 了解详情