编辑代码

-- 向 sell 表插入数据
INSERT INTO sell (订单号, 用户名, 图书编号, 订购册数, 订购单价, 订购时间, 是否发货, 是否收货, 是否结账)
VALUES
    (1, 'C0132', 'TP.2525', 13, 20, '2023-11-14 12:13:49', '已发货', NULL, 0),
    (2, 'D1963', 'TP.2463', 3, 31.5, '2023-11-21 12:25:12', '已发货', NULL, 0),
    (3, 'D1963', 'TP.2525', 6, 23.45, '2023-03-26 12:25:23', '已发货', '已收货', 0),
    (4, 'C0138', 'Ts.3035', 10, 23.5, '2023-08-01 12:13:49', '已发货', '已收货', 1),
    (5, 'C0138', 'TP.2525', 133, 33.5, '2023-08-01 12:13:49', NULL, NULL, 0),
    (6, 'A3013', 'Tw.2562', 4, 89, '2023-08-20 00:00:00', NULL, NULL, 0),
    (7, 'C0138', 'TP.2463', 43, 30, '2023-11-08 12:13:49', '已发货', NULL, 0),
    (8, 'C0138', 'Ts.3035', 5, 45.5, '2023-11-21 00:00:00', NULL, NULL, 0),
    (9, 'C0132', 'Tw.1283', 6, 23, '2023-11-28 18:23:35', '已发货', '已收货', 1);