Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql get only the field names in a table

SELECT column_name
FROM information_schema.columns
WHERE  table_name = 'your_table'
   AND table_schema = 'database_name'
Comment

PREVIOUS NEXT
Code Example
Sql :: print boolean in plsql 
Sql :: setval in postgres 
Sql :: r write csv without index 
Sql :: sql row having max 
Sql :: change schema of all tables postgres 
Sql :: mysql if statement in where clause 
Sql :: graphql 
Sql :: sql composite key 
Sql :: SQL order by string split length 
Sql :: select other columns with distinct 
Sql :: java sql insert return id 
Sql :: insert to postgres table 
Sql :: sql select 
Sql :: microsoft sql server python connection 
Sql :: select indexes postgres 
Sql :: partition-by 
Sql :: mysql count 
Sql :: run stored procedure sql 
Sql :: operator in sql 
Sql :: sql trying to delete database in use 
Sql :: mql5 list all available symbols 
Sql :: group by sql not ordering issues 
Sql :: Search In the Database using Text 
Sql :: How to take sum of column with same id and different table in SQL? 
Sql :: one to one and one to many relationship 
Sql :: homebrew mysql service not starting 
Sql :: .env pgsql 
Sql :: concatenation in sql 
Sql :: drop procedure postgres 
Sql :: sql searching via key word 
ADD CONTENT
Topic
Content
Source link
Name
7+6 =