若要修改 SQL 语句以查看第一页，每页 50000 条数据，可使用 `LIMIT` 关键字。原 SQL 语句里 `LIMIT 1,1000` 有误，其含义是从第 2 条记录开始取 1000 条记录。若要取第一页，每页 50000 条数据，应改为 `LIMIT 0, 50000`。
修改后的 SQL 语句如下：
```sql
SELECT
DATE_FORMAT(create_time, '%Y-%m-%d %H:%i:%S') AS 抓取时间,
city_name AS 城市,
place_name AS 点位,
DATE_FORMAT(pickup_time, '%Y-%m-%d %H:%i:%S') AS 取车时间,
DATE_FORMAT(dropoff_time, '%Y-%m-%d %H:%i:%S') AS 还车时间,
sort_list AS 列表页排序,
veh_name AS 车型名称,
veh_groups AS 车型配置,
offerta_sort AS 报价页排序,
supplier_name AS 服务商名称,
store_name AS 供应商名称,
single_special_service_codes AS 取还车方式,
special_service_name AS 车型标签,
pickup_location AS 取车地点,
dropoff_location AS 还车地点,
minTotalAmount AS 列表页最低实付总价,
rent_fee AS 车辆租赁费,
alipay_promotion AS 租车券减免,
merchant_promotion AS 商户特惠,
minorInjury_promotion AS 小伤免赔优惠,
hl_fficial_subsidy AS 哈啰官方补贴,
homeget_fee AS 上门取车费,
homesend_fee AS 上门送车费,
homereturn_fee AS 上门还车费,
pickup_service_fee AS 接送车服务费,
home_get_send_service AS 上门取送服务,
nightretu_get_service_fee AS 夜间还车服务费,
store_service_fee AS 车行手续费,
night_service_fee AS 夜间服务费,
night_send_fee AS 夜间取车费,
night_get_fee AS 夜间还车费,
basic_guarantee_fee AS 基础保障服务费,
premium_protection AS 优享保障,
no_coupon_amount AS 划线价,
pay_amount AS 实付价,
sporad_hour_fee AS 零散小时费,
differ_plac_retu_fee AS 异地还车费,
other_fee_name1 AS "其他费项名称 1",
other_fee1 AS "其他费项金额 1",
other_fee_name2 AS "其他费项名称 2",
other_fee2 AS "其他费项金额 2",
other_fee_name3 AS "其他费项名称 3",
other_fee3 AS "其他费项金额 3",
other_fee_name4 AS "其他费项名称 4",
other_fee4 AS "其他费项金额 4",
pickup_location_longitude AS 取车地点经度,
pickup_location_latitude AS 取车地点纬度,
dropoff_location_longitude AS 还车地点经度,
dropoff_location_latitude AS 还车地点纬度
FROM
t_didi_zuche_data
WHERE
DATE(create_time) > '2025-09-23'
AND DATE(create_time) < '2025-09-25'
LIMIT 0, 50000;
```
扫一扫
589
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
