/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 vote328 views2 answers
Mssql show database size
SQL
0 vote370 views1 answer
How to compile a function in oracle
SQL
0 vote325 views2 answers
How to create a table from another table in sql derby
SQL
0 vote362 views1 answer
MySQL - Enabling the Event Scheduler
SQL
14 votes341 views1 answer
Oracle new column
SQL
0 vote343 views1 answer
How to make case insensitive in sql
SQL
2 votes318 views2 answers
Mysql date range
SQL
3 votes515 views6 answers
Sql unique select
SQL
0 vote323 views2 answers
Sql query for getting details by id
SQL
0 vote267 views1 answer
Mysql collation for all languages
SQL

Share