mysql语法点滴

1、随机抽取一定数量的数据

select id,from_unixtime(create_time) from A where create_time between unix_timestamp('2008-10-1 00:00:00') and unix_timestamp('2009-12-31 00:00:00') order by rand() limit 100;