Search
 
SCRIPT & CODE EXAMPLE
 

SQL

MySql get fields of table

SELECT COLUMN_NAME
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME = 'my_table';
Comment

PREVIOUS NEXT
Code Example
Sql :: use cases condition in sql query laravel 
Sql :: import database through command line 
Sql :: list all permissions on a table in postgres 
Sql :: sql eliminare un record 
Sql :: sql pick random row 
Sql :: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement 
Sql :: mysql get yesterday 
Sql :: drop db syntax 
Sql :: how to check database engine in mysql 
Sql :: how to delete view in sql 
Sql :: postgresql format date dd/mm/yyyy 
Sql :: how to check database username and password in postgresql 
Sql :: mysql check if string contains comma separated 
Sql :: sql throw error 
Sql :: yii2 mysql ping 
Sql :: mysql random number between 1 and 100 
Sql :: mysql on terminal mac 
Sql :: mysql reset auto increment 
Sql :: t sql remove last character from string 
Sql :: mysql drop column 
Sql :: create policy in sql 
Sql :: how to delete duplicate rows in oracle 
Sql :: mysql return if it contains 
Sql :: mssql int max value 
Sql :: ssh mysql port forwarding 
Sql :: mysql select utc time in eastern time 
Sql :: sql fillna 
Sql :: oracle create program if not exists 
Sql :: backup mysql data only 
Sql :: find logged in users mysql 
ADD CONTENT
Topic
Content
Source link
Name
3+9 =