Mysql Command

This post will record all the mysql command that i used in my projects.

Show the size of the table

use information_schema; 
select concat(round(sum(data_length/1024),2),'KB') as data from tables where table_schema='futures';

Select the latest row of the table

select * from M0 where time=(select max(time) from M0);