MySQL Data statement

SELECT Fl.name,fvl.value,count ((Fvl.value)) n from Ps_feature_lang FL left joins Ps_feature_product FP on (fl.id_feature= Fp.id_feature) left JOIN Ps_feature_value_lang FVL on (fvl.id_feature_value=fp.id_feature_value) WHERE fp.id_product in (select Id_product from ps_category_product where id_category=110) group by Fvl.value Order by Fvl.value;

Show CREATE TABLE Tbl_name
Displays the SQL statement that created the table.

show Character set [like ' Pattern ']
Show all available character sets

Show CREATE DATABASE db_name
Displays the SQL statement when the db_name was created

show databases [like ' pattern ']
Displays all databases on the current MySQL

mysql> Show tables;

Show all tables on the current database

Show Open Table
Displays the table in the current table buffer

SHOW Privileges
Show the permissions that MySQL supports

MySQL Data statement