向数据表user中添加一个age字段:alter table user add column age int(4);
删除数据表user中的age字段 alter table user drop age;
修改age字段的属性: alter table user modify age int(10);
修改age字段的名称和属性:alter table user change age newage int(4);
Mysql IP地址转换:
将IP地址转化为数字: SELECT inet_aton('192.168.1.139');
将数字转化为IP地址: SELECT inet_ntoa(3525181543);
时间整型转换日期型:SELECT FROM_UNIXTIME(1320423419); 2011-11-05 00:16:59
时间日期型转换整型:SELECT UNIX_TIMESTAMP("2011-11-05 00:20:00"); 1320423600
查询一天:
select * from table where to_days(column_time) = to_days(now());查询一周:
select * from table where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(column_time);
查询一个月:
select * from table where DATE_SUB(CURDATE(), INTERVAL INTERVAL 1 MONTH) <= date(column_time);