You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

37 lines
1.8 KiB

-- 插入一条新的客户记录
INSERT INTO customers (T_name, T_rsex, T_phone) VALUES ('李华', '', '13800138000');
-- 插入另一条新的客户记录
INSERT INTO customers (T_name, T_rsex, T_phone) VALUES ('王芳', '', '13900139000');
-- 插入一条新的菜单项记录
INSERT INTO menu_items (M_id, M_name, M_class, M_price) VALUES ('013', '炒青菜', '', 12.99);
-- 插入另一条新的菜单项记录
INSERT INTO menu_items (M_id, M_name, M_class, M_price) VALUES ('014', '红烧肉', '', 25.99);
-- 插入一条新的折扣规则记录
INSERT INTO discount_rules (M_id, discount) VALUES ('013', 0.8);
-- 插入另一条新的折扣规则记录
INSERT INTO discount_rules (M_id, discount) VALUES ('014', 0.7);
-- 插入一条新的餐桌记录
INSERT INTO tables (Cz_id, Cz_number, Cz_zt) VALUES ('TABLE11', 11, '空闲');
-- 插入另一条新的餐桌记录
INSERT INTO tables (Cz_id, Cz_number, Cz_zt) VALUES ('TABLE12', 12, '占用');
-- 插入一条新的员工记录
INSERT INTO workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('11', '张十一', '', 1, 5000);
-- 插入另一条新的员工记录
INSERT INTO workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('12', '张十二', '', 1, 5100);
-- 插入一条新的订单记录
INSERT INTO orders (T_id, time, Cz_id, W_id, items) VALUES (30, '2024-12-28 22:18:15', 'TABLE06', '03', '001,002,003');
-- 插入另一条新的订单记录
INSERT INTO orders (T_id, time, Cz_id, W_id, items) VALUES (31, '2024-12-28 22:19:10', 'TABLE06', '04', '005,006,007');
-- 插入一条新的账单记录
INSERT INTO bills (O_id, S_price, S_priceafter, time) VALUES (37, 50.00, 45.00, '2024-12-28 22:18:17');
-- 插入另一条新的账单记录
INSERT INTO bills (O_id, S_price, S_priceafter, time) VALUES (38, 30.00, 27.00, '2024-12-28 22:19:11');