/SQL/Mysql show table fields

Mysql show table fields

Mysql show table structure

DESCRIBE table_name; # To show table structure...

4

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

3 votes170 views1 answer
Oracle nextval
SQL
0 vote195 views1 answer
How to make case insensitive in sql
SQL
7 votes161 views2 answers
Create mysql user
SQL
0 vote359 views1 answer
How to connect .sql data set to powerbi
SQL
1 vote174 views1 answer
Check constraint to check if date greater than todays date
SQL
2 votes171 views2 answers
Postgresql date at timezone
SQL
0 vote186 views1 answer
Test sql query
SQL
0 vote197 views1 answer
T-sql email validation
SQL
0 vote181 views1 answer
How to Remove milliseconds from Date time
SQL
1 vote180 views1 answer
Stop mysql server mac
SQL

Share