Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql, how to query the table comments?

SELECT a.COLUMN_NAME, a.COLUMN_COMMENT
FROM  information_schema.COLUMNS a 
WHERE a.TABLE_NAME = 'YOUR_TABLE_NAME'
Comment

PREVIOUS NEXT
Code Example
Sql :: SQL Greater Than Operator 
Sql :: sql and or 
Sql :: what is ssrs and ssis in sql server 
Sql :: select limit ms sql 
Sql :: Create table if not exist with exceptions 
Sql :: SQL SELECT-Klausel 
Sql :: jsonb 
Sql :: union all in sql 
Sql :: ring MySQL commit updates to the database 
Sql :: set identity_insert off 
Sql :: mssql xml 
Sql :: salesforce soql get parents without children 
Sql :: mysql create link between tablesdatabase 
Sql :: mysql coonect sample code 
Sql :: cube oracle 
Sql :: oracle apex call duration 
Sql :: sqlalchemy core in clause 
Sql :: python sqlalcahmey compare datetime 
Sql :: disadvantages of stored procedures sql 
Sql :: eneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields. 
Sql :: postgresql not in alternative 
Sql :: sql select random procentage from rows 
Sql :: if new such record in where condition in sql so what is return 
Sql :: sql server select query datatype 
Sql :: merge query using linked server 
Sql :: synapse sql table set pk 
Sql :: vbscript create ADODB.Connection 
Sql :: change authentication plugin from auth_sock to mysql_native_password for a specific user 
Sql :: mysql workbench cannot find password 
Sql :: 9999 
ADD CONTENT
Topic
Content
Source link
Name
1+1 =