3.4. INFORMATION_SCHEMA

简介:


3.4.1. 查询表字段

			
SELECT 
    GROUP_CONCAT(COLUMN_NAME) AS fields
FROM
    INFORMATION_SCHEMA.Columns
WHERE
    table_name = 'mytable'
        AND table_schema = 'test';
			
			




原文出处:Netkiller 系列 手札
本文作者:陈景峯
转载请与作者联系,同时请务必标明文章原始出处和作者信息及本声明。

目录
相关文章
|
11天前
|
SQL 关系型数据库 MySQL
|
6月前
|
SQL
Auditing SQL Statements, Privileges, and Other General Activities
Auditing SQL Statements, Privileges, and Other General Activities
36 0
|
关系型数据库 MySQL
MySQL的INFORMATION_SCHEMA使用
MySQL的INFORMATION_SCHEMA使用
|
SQL 关系型数据库 MySQL
关于mysql中information_schema.tables
项目中出现这样一个SQL语句,现记录如下: @Select("select table_name tableName, engine, table_comment tableComment, create_time createTime from information_schema.
1817 0
|
C++ 数据库管理 vr&ar
Create schema error (unknown database schema '')
Andrey Devyatka 4 years ago Permalink Raw Message Hi,Please tell me, can I use the static library in the following case:library.
1437 0
|
C++
[odb-users] Create schema error (unknown database schema '')
Boris Kolpackov boris at codesynthesis.com Fri May 31 11:13:02 EDT 2013   Previous message: [odb-users] Create schema error (unknown database schem...
1440 0