HINT: Visually view a mysql table

[litewarez]

There's a small peice of mysql syntax that will create a visual form of a table ok soo lets say we just created a database with the following create command

CREATE TABLE SessHolder (
    id varchar(32) NOT NULL,
    access int(10) unsigned,
    data text,
    PRIMARY KEY (id)
);

So now if we run the DESCRIBE Command we should
get a result like so.

mysql> DESCRIBE SessHolder
+--------+------------------+------+-----+---------+-------+
| Field  | Type             | Null | Key | Default | Extra |
+--------+------------------+------+-----+---------+-------+
| id     | varchar(32)      |      | PRI |         |       |
| access | int(10) unsigned | YES  |     | NULL    |       |
| data   | text             | YES  |     | NULL    |       |
+--------+------------------+------+-----+---------+-------+

Im sure you will all agree that this is much easier to read!

Peace

litewarez Reviewed by litewarez on 22nd May 2009. HINT: Visually view a mysql table There's a small peice of mysql syntax that will create a visual form of a table ok soo lets say we just created a database with the following create command CREATE TABLE SessHolder ( id varchar(32) NOT NULL, access int(10) unsigned, data text, PRIMARY KEY (id) ); So now if we run the DESCRIBE Command we should get a result like so. Rating: 5

[TinTin]

Its one of basic commands.I think we can also use DESC tablename