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, 0, 1, 1, 2023-06-07 14:01:37.42, 1, 2023-06-07 14:01:37.42, 0, 111, 10891089000.00000000000000000000000000000000000000000000000000000000000000000, 1641003167225352192, 18868429216 )
时间: 2023-10-04 18:09:44 浏览: 50
django_tenant_type3:带有共享架构的共享数据库的django租户示例项目
这是一个 SQL 语句,对应的是向名为 flower_t_order 的订单表插入一条订单记录。该订单记录包括订单的各种属性,如订单 ID、门店 ID、会员 ID、订单编号、应付金额、已付金额、支付状态、订单状态等等。其中,订单的创建时间和更新时间分别为 2023-06-07 14:01:37.42。同时,该订单的支付方式为在线支付,取货方式为到店自取。订单备注为 "111",实际支付金额为 10891089000.00000000000000000000000000000000000000000000000000000000000000000。收货人姓名为 "18868429216"。
阅读全文