Answers for "mysql show table contents"

mysql show table column full description

/**table's full description*/
SHOW FULL COLUMNS FROM tablename;

mysql show tables in database

show tables;

mysql show data from table

mysql> SELECT * FROM [table name];

print all records of table in mysql

SELECT * FROM TABLE_NAME;
OR
SELECT column_name_1, column_name_2 FROM TABLE_NAME;

mysql show table structure

DESCRIBE table_name; # To show table structure...

mysql show table fields

DESCRIBE my_table;