内容来自各次搜索汇总,都是来自各位大神的辛勤奉献,在此一并感谢,以下不是本人知识结晶,在此纯粹搬砖
//1、修改某条记录某个字段的值
SELECT iStatus,iSearchStatus FROM aazb2c_db.t_housing WHERE iAutoid=1 or iAutoid=2;
update aazb2c_db.t_housing set iStatus=0 ,iSearchStatus=0 where iAutoid=1; //修改iStatus,iSearchStatus这两个字段的值为0;
update aazb2c_db.t_housing set iStatus=0 ,iSearchStatus=0 where iAutoid=2;
update aazb2c_db.t_housing set iStatus=1 ,iSearchStatus=1 where iAutoid=1;
update aazb2c_db.t_housing set iStatus=1 ,iSearchStatus=1 where iAutoid=2;
update aazb2c_db.t_housing set iUpdateTime=UNIX_TIMESTAMP(NOW()) where iAutoid=1;//修改iUpdateTime这个字段的时间;
update aazb2c_db.t_housing set iUpdateTime=UNIX_TIMESTAMP(NOW()) where iAutoid=2;
//2、时间戳转换为日期,日期转换为UNIX时间戳
1、UNIX时间戳转换为日期用函数: FROM_UNIXTIME()
select FROM_UNIXTIME(1156219870);
输出:2006-08-22 12:11:10
2、日期转换为UNIX时间戳用函数: UNIX_TIMESTAMP()
Select UNIX_TIMESTAMP('2006-11-04 12:23:00');
输出:1162614180
//3、mysql增加列,修改列名、列属性,删除列语句