Example3.sql

-- the structure of the table

DESCRIBE rnaseq;

-- go        (\g) Send command to mysql server.
 SELECT * FROM  rnaseq \G


 -- show column
 SHOW COLUMNS FROM rnaseq;

 ---wild card sign %

SHOW COLUMNS FROM rnaseq LIKE '%id';