/SQL/MySql get fields of table

MySql get fields of table

Get the mysql table columns data type mysql

SHOW COLUMNS FROM mydb.mytable;

2

Mysql show table fields

DESCRIBE my_table;

2

Source: stackoverflow.com

MySql get fields of table

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

1

Source: stackoverflow.com

Similar codes

0 vote315 views1 answer
Site:av.ru "files"
SQL
17 votes198 views3 answers
Cast in sql server
SQL
0 vote186 views1 answer
Drop all tables in azure sql database
SQL
2 votes241 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote239 views1 answer
Ms sql print more than 1 variable
SQL
0 vote254 views1 answer
Postgres foreign key multiple columns
SQL
0 vote235 views2 answers
SQL Server Standard
SQL
1 vote200 views1 answer
Where date = max(date) in sql
SQL
13 votes296 views2 answers
Sqlite rename table
SQL
0 vote230 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL

Share