「MySQL」現在時刻を保存する方法
1.mysqlで時間カラムをdaterimeへ変更
alter table tablename add pay_date datetime comment '秒まで精確時間’
2.SQL文でnow()を直接使う
update tj_record set is_customerHandover =’1′ and customer_handover_date = now() where id = #{record_id}
Coding Changes the World
1.mysqlで時間カラムをdaterimeへ変更
alter table tablename add pay_date datetime comment '秒まで精確時間’
2.SQL文でnow()を直接使う
update tj_record set is_customerHandover =’1′ and customer_handover_date = now() where id = #{record_id}