FreeKB - mySQL / MariaDB SHOW COLUMNS statement
mySQL / MariaDB - SHOW COLUMNS statement

This assume you are able to connect to MariaDB

The SHOW COLUMNS command is used to display the columns of a table. In this example,

SHOW COLUMNS from my_table;

 

Something like this should be displayed.

+-------------------+------------+------+-----+---------+-------+
| Field             | Type       | Null | Key | Default | Extra |
+-------------------+------------+------+-----+---------+-------+
| id                | int(11)    | YES  | PRI | NULL    |       |
| column1           | varchar(10)| NO   |     | NULL    |       |
| column2           | varchar(10)| NO   |     | NULL    |       |
| column3           | varchar(10)| NO   |     | NULL    |       |
+-------------------+------------+------+-----+---------+-------+

 



Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter ec345 in the box below so that we can be sure you are a human.




Comments

Web design by yours truely - me, myself, and I   |   jeremy.canfield@freekb.net   |