MYSQL随机抽取数据库里的几条数据
- select username from cdb_members order by rand() limit 0,5;
数据表(table2)移植到(table1)
- insert into table1(字段1,字段2,字段3) select 字段1,字段2,字段3 from table2
从new表中中读取在maked_new表中没有的记录。
- select id from `new` where id not in(select marked_new_id from maked_news)
用一条语句得出某日期所在月份的最大天数?
- SELECT DAY(DATEADD(dd, -DAY('2004-02-13'), DATEADD(mm, 1, '2004-02-13'))) AS 'Day Number'