xcc258的专栏

获取每个类别最新记录： [code="java"]select MAX(car_id) from tbl_carinfo group by org_id[/code] org_id--类别ID，car_id--主键 mysql 时间格式化函数： [code="sql"] DATE_FORMAT(`oper_date`, '%Y-%m-%d %k:%i:%s')[/code] c...

数据库导入导出 [code="java"] mysqldump -u root -p uebuycar_test >test.sql mysql -u root -p uebuycar_new='2013-09-01 00:00:00' and create_time='2013-09-01 00:00:00' and create_time='2015-01-19 18:25:00'; ...