INSERT INTO flower_t_order ( id, point_id, store_id, member_id, tenant_id, channel_id, order_number, payable_amount, paid_amount, discount_amount, brokerage, pay_status, order_status, site_id, self_take_time, pay_type, take_type, create_user, create_time, update_user, update_time, state, remark, actual_amount, delivery_id, member_name ) VALUES (1666323908250439680, 1, 1666012500627427328, 1661213318544756736, 1, 1658768823098150912, 216861175532337, 12101212000.0000000000000000000000000000000000000000000000000000000000000000, 12101212000.0000000000000000000000000000000000000000000000000000000000000000, 0, 12101212000.0000000000000000000000000000000000000000000000000000000000000000,4, 1, 2023-06-07 16:30:00, 0, 1, 1, 2023-06-07 14:01:37, 1, 2023-06-07 14:01:37, 0, 111, 10891089000.00000000000000000000000000000000000000000000000000000000000000000, 1641003167225352192, 18868429216 ) ERROR: syntax error at or near "16" LINE 1: ...00000000000000000000000000000000,4, 1, 2023-06-07 16:30:00.0...
时间: 2023-10-04 21:10:41 浏览: 117
fusionpbx-4.2.zip_freeswitch_full_fusionpbx 4.2_multi-tenant_pbx
这是一个 SQL 语句,对应的是向名为 flower_t_order 的订单表插入一条订单记录。但是该 SQL 语句仍然存在语法错误,报错信息是在第一个时间戳后面的 ".0",可能是因为该时间戳格式不正确。需要对时间戳格式进行调整,例如将 "2023-06-07 16:30:00.0" 改为 "2023-06-07 16:30:00"。修改后的 SQL 语句如下:
INSERT INTO flower_t_order ( id, point_id, store_id, member_id, tenant_id, channel_id, order_number, payable_amount, paid_amount, discount_amount, brokerage, pay_status, order_status, site_id, self_take_time, pay_type, take_type, create_user, create_time, update_user, update_time, state, remark, actual_amount, delivery_id, member_name ) VALUES (1666323908250439680, 1, 1666012500627427328, 1661213318544756736, 1, 1658768823098150912, 216861175532337, 12101212000.0000000000000000000000000000000000000000000000000000000000000000, 12101212000.0000000000000000000000000000000000000000000000000000000000000000, 0, 12101212000.0000000000000000000000000000000000000000000000000000000000000000,4, 1, '2023-06-07 16:30:00', 0, 1, 1, '2023-06-07 14:01:37', 1, '2023-06-07 14:01:37', 0, 111, 10891089000.00000000000000000000000000000000000000000000000000000000000000000, 1641003167225352192, 18868429216 )
阅读全文