/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

1 vote325 views1 answer
Python escape string for sql
SQL
0 vote341 views1 answer
Power bi union columns
SQL
0 vote322 views2 answers
Sqlite
SQL
0 vote332 views1 answer
Convert .mdf to .bak
SQL
6 votes377 views2 answers
Subtr Oracle ?
SQL
12 votes397 views4 answers
How to drop all tables in postgresql
SQL
0 vote367 views1 answer
Mysql faster delete
SQL
0 vote332 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote313 views1 answer
Metada in sql
SQL
0 vote337 views1 answer
Delete a record from a table sqlite3
SQL

Share