MySQL的其他未曾关注过的特性

最近看了下MySql的具体介绍，很有感触，记录一下

1、游标，存储过程

2、主键索引、唯一索引、常规索引、全文索引

3、事务（ACID）：原子性、一致性、隔离性、持久性－－Transaction,COMMIT,ROLLBACK

4、导出:SELECT * INTO OUTFILE "*.TXT/*.XLS" FIELDS TERMINATED BY '\t',LINES TERMINATED BY '\n' FROM TABLES WHERE ....

5、导入：LOAD DATA LOCAL INFILE 'productreviews.txt' INTO TABLE productreviews FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n';