MySQL基本命令

初步学习了一些MySQL的基本命令，以及针对apple的epfimporter而做的binlog日志分析，代码放在了github（https://github.com/aoyoo/mysql）。

创建用户

GRANT ALL PRIVILEGES ON *.* TO 'epfimporter'@'localhost' IDENTIFIED BY 'epf123' WITH GRANT OPTION;

行数：

select count(*) from epf_application ;

列最大/小值

select max(application_id) from epf_application ;

select min(application_id) from epf_application ;

最大/小 N个值

select application_id from epf_application order by application_id limit 10;

select application_id from epf_application where application_id<281816692 10="" application_id="" by="" div="" limit="" order="">

清空表

TRUNCATE TABLE epf_application ;

查看表大小

select TABLE_NAME,DATA_LENGTH,INDEX_LENGTH from information_schema.TABLES;