1、统计同一个房屋下的车辆个数:
SELECT houseid,COUNT(*) FROM t_car GROUP BY houseId;
2、在1的基础上,统计拥有最多车辆个数的房间号
SELECT houseId,COUNT(*) as car_num FROM t_car GROUP BY houseId ORDER BY car_num DESC LIMIT 1;
3、用一条sql语句批量新增3条t_car记录
INSERT INTO `t_car` VALUES ('00111', '鄂AB1000', '11111111111111111111111111111121', 'car_brand_01', 'car_color_01', 'car_type_01', '2017-07-23 12:12:00', ''),
('00112', '鄂AC1234', '1111111