/SQL/Mysql all columns

Mysql all columns

Get the mysql table columns data type mysql

SHOW COLUMNS FROM mydb.mytable;

2

Mysql all columns

-- MySQL
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS;

0

Similar codes

1 vote128 views1 answer
Mysql get max value and id
SQL
0 vote131 views1 answer
Sql count null values in all columns
SQL
0 vote141 views1 answer
Postgresql replace html tags from string
SQL
0 vote141 views1 answer
Sql server python connection
SQL
1 vote203 views1 answer
Primary key reset in SQL database
SQL
3 votes186 views1 answer
Apex call duration
SQL
0 vote125 views1 answer
Postgresql create table many-to-many
SQL
0 vote135 views1 answer
Get db connection detail from sql developer profile
SQL
2 votes130 views1 answer
Oracle list duplicates
SQL
0 vote119 views1 answer
Show specific events on mysql
SQL

Share