-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsql.py
More file actions
42 lines (34 loc) · 1.42 KB
/
sql.py
File metadata and controls
42 lines (34 loc) · 1.42 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
a = '''INSERT INTO `购物车` (`用户名`, `商品名`, `数量`, `勾选状态`) VALUES
('万东', 'LightSkyBlue', 400, '已勾选'),
('万霞', 'DarkGray', 260, '未勾选'),
('刘兰英', 'FireBrick', 230, '未勾选'),
('刘瑞', 'BlueViolet', 36, '已勾选'),
('吕莉', 'DarkMagenta', 69, '未勾选'),
('唐萍', 'ForestGreen', 337, '未勾选'),
('常敏', 'LightBlue', 336, '已勾选'),
('张想', 'FireBrick', 316, '已勾选'),
('张雷', 'Snow', 355, '已勾选'),
('施梅', 'Olive', 364, '已勾选'),
('李东', 'SandyBrown', 442, '已勾选'),
('李云', 'MistyRose', 27, '未勾选'),
('李杨', 'BlueViolet', 483, '已勾选'),
('林鹏', 'GoldenRod', 167, '未勾选'),
('武颖', 'RosyBrown', 494, '未勾选'),
('王兵', 'SpringGreen', 165, '未勾选'),
('王坤', 'Linen', 238, '已勾选'),
('王洁', 'Moccasin', 281, '已勾选'),
('罗燕', 'LightSeaGreen', 480, '未勾选'),
('胡桂英', 'Coral', 163, '已勾选'),
('蔡丽华', 'Linen', 48, '未勾选'),
('袁淑英', 'DarkMagenta', 232, '未勾选'),
('赖丽娟', 'DimGray', 210, '未勾选'),
('赵丽丽', 'GoldenRod', 250, '未勾选'),
('邓健', 'DimGray', 304, '未勾选'),
('钟颖', 'Linen', 429, '未勾选'),
('阎佳', 'Wheat', 183, '未勾选'),
('陈杰', 'FireBrick', 175, '未勾选'),
('陈楠', 'Snow', 125, '未勾选'),
('骆霞', 'MistyRose', 359, '已勾选');
'''
a=a.replace('\n', '')
print(a)