-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSQLQuery4.sql
73 lines (57 loc) · 11.5 KB
/
SQLQuery4.sql
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
--Lenovo
INSERT dbo.SanPham VALUES ( N'Lenovo Legion 7 16ACHg6' ,51600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-7-16ACHg6.jpg',4,0,0,0,0,1,3,7,1,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion Slim 7i 15IMH5' ,31600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-Slim-7i-15IMH5.jpg',4,0,0,0,0,1,3,7,1,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion 5 Pro 16ACH6H' ,40600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-5-Pro-16ACH6H.jpg',4,0,0,0,0,1,3,7,1,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo ThinkPad X1 Carbon Gen 9' ,28600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-ThinkPad-X1-Carbon-Gen-9.jpg',4,0,0,0,0,1,3,7,1,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Legion Tower 5 AMD Gaming PC' ,32600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Legion-Tower-5-AMD-Gaming-PC.png',4,0,0,0,0,1,3,7,2,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ThinkCentre M90t Desktop Tower' ,22600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ThinkCentre-M90t-Desktop-Tower.png',4,0,0,0,0,1,3,7,2,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo ThinkStation P350 Tiny workstation' ,40600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ThinkStation-P350-Tiny-workstation.jpg',4,0,0,0,0,1,3,7,2,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion K500 RGB Mechanical Gaming' ,2600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-K500-RGB-Mechanical-Gaming.jpg',4,0,0,0,0,1,3,7,3,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion K300 RGB Gaming' ,1600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-K300-RGB-Gaming.jpg',4,0,0,0,0,1,3,7,3,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo ThinkPad TrackPoint' ,2000000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-ThinkPad-TrackPoint.jpg',4,0,0,0,0,1,3,7,3,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion M200 Mouse' ,600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-M200-Mouse.jpg',4,0,0,0,0,1,3,7,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion M300 RGB Gaming' ,900000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-M300-RGB-Gaming.jpg',4,0,0,0,0,1,3,7,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion M500 RGB Gaming' ,1600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-M500-RGB-Gaming.jpg',4,0,0,0,0,1,3,7,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion H300 Stereo Gaming' ,1600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-H300-Stereo-Gaming.jpg',4,0,0,0,0,1,3,7,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion H200 Gaming Headset' ,900000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-H200-Gaming-Headset.png',4,0,0,0,0,1,3,7,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion H600 Stingray Wireless Gaming ' ,2300000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-H600-Stingray-Wireless-Gaming.jpg',4,0,0,0,0,1,3,7,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion Y27q-20' ,13000000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-Y27q-20.png',4,0,0,0,0,1,3,7,6,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo G25-10 Gaming Monitor' ,5600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-G25-10-Gaming-Monitor.jpg',4,0,0,0,0,1,3,7,6,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Lenovo Legion Y25g-30' ,16000000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Lenovo-Legion-Y25g-30.jpg',4,0,0,0,0,1,3,7,6,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
--Logitech
INSERT dbo.SanPham VALUES ( N'LOGITECH G915 TKL6' ,4600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'LOGITECH-G915-TKL.png',4,0,0,0,0,1,3,8,3,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'LOGITECH PRO KDA KEYBOARD' ,3200000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'LOGITECH-PRO-KDA-KEYBOARD.png',4,0,0,0,0,1,3,8,3,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'LOGITECH PRO X KEYBOARD' ,4100000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'LOGITECH-PRO-X-KEYBOARD.jpg',4,0,0,0,0,1,3,8,3,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'LOGITECH G910 Orion RGB MECHANICAL' ,2600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'LOGITECH-G910-Orion-RGB-MECHANICAL.jpg',4,0,0,0,0,1,3,8,3,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'LOGITECH G213 RGB GAMING' ,1200000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'LOGITECH-G213-RGB-GAMING.png',4,0,0,0,0,1,3,8,3,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Logitech G903 Hero Lightspeed Wireless' ,3000000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Logitech-G903-Hero-Lightspeed-Wireless.jpg',4,0,0,0,0,1,3,8,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Logitech G502 Hero Lightspeed Wireless' ,3200000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Logitech-G502-Hero-Lightspeed-Wireless.jpg',4,0,0,0,0,1,3,8,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Logitech MX Master 2S' ,1500000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Logitech-MX-Master-2S.jpg',4,0,0,0,0,1,3,8,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Logitech G Pro X Superlight Wireless' ,2900000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Logitech-G-Pro-X-Superlight-Wireless.jpg',4,0,0,0,0,1,3,8,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Logitech G502 Hero KDA' ,1900000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Logitech-G502-Hero-KDA.png',4,0,0,0,0,1,3,8,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Logitech G733 KDA Lightspeed Wireless' ,3500000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Logitech-G733-KDA-Lightspeed-Wireless.png',4,0,0,0,0,1,3,8,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Logitech G Pro X Headset' ,3000000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Logitech-G-Pro-X-Headset.png',4,0,0,0,0,1,3,8,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Logitech G633S Headset' ,2800000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Logitech-G633S-Headset.png',4,0,0,0,0,1,3,8,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Logitech G Pro Gen 2 Headset' ,1600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Logitech-G-Pro-Gen-2-Headset.png',4,0,0,0,0,1,3,8,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Logitech G435 Lightspeed Wireless Headset' ,1700000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Logitech-G435-Lightspeed-Wireless-Headset.jpg',4,0,0,0,0,1,3,8,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
--Acer
INSERT dbo.SanPham VALUES ( N'ACER GAMING PREDATOR HELIOS 500 PH517' ,100600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ACER-GAMING-PREDATOR-HELIOS-500-PH517.jpg',4,0,0,0,0,1,3,9,1,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ACER PREDATOR TRITON 500SE PT516' ,85600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ACER-PREDATOR-TRITON-500SE-PT516.png',4,0,0,0,0,1,3,9,1,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ACER GAMING NITRO 5 EAGLE AN515' ,40600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ACER-GAMING-NITRO 5-EAGLE-AN515.png',4,0,0,0,0,1,3,9,1,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ACER SWIFT X SFX14' ,28600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'LAPTOP-ACER-SWIFT-X-SFX14.png',4,0,0,0,0,1,3,9,1,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ACER Predator Aethon 300 Keyboard' ,2600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ACER-Predator-Aethon-300-Keyboard.jpg',4,0,0,0,0,1,3,9,3,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ACER Predator Cestus 310 Gaming' ,800000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ACER-Predator-Cestus-310-Gaming.jpg',4,0,0,0,0,1,3,9,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ACER Predator Cestus 350 Wireless Gaming' ,2600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Predator-Cestus-350-Wireless-Gaming.jpg',4,0,0,0,0,1,3,9,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ACER Predator Cestus 330 Gaming' ,1600000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ACER-Predator-Cestus-330-Gaming.png',4,0,0,0,0,1,3,9,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ACER Nitro Gaming Headset' ,900000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ACER-Nitro-Gaming-Headset.jpg',4,0,0,0,0,1,3,9,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ACER Predator Galea 310 Headset' ,1800000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ACER-Predator-Galea-310-Headset.jpg',4,0,0,0,0,1,3,9,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'ACER Predator Galea 311 Headset' ,1900000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'ACER-Predator-Galea-311-Headset.jpg',4,0,0,0,0,1,3,9,5,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
--Xiaomi
INSERT dbo.SanPham VALUES ( N'Xiaomi Black Shark Mako M1' ,900000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Xiaomi-Black-Shark-Mako-M1.png',4,0,0,0,0,1,3,10,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Xiaomi Black Shark E-Sports' ,1700000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Xiaomi-Black-Shark-E-Sports.png',4,0,0,0,0,1,3,10,4,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Xiaomi Black Shark 4 PRO' ,18500000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Xiaomi-Black-Shark-4-PRO.jpg',4,0,0,0,0,1,3,10,7,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Xiaomi Black Shark 4' ,1500000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Xiaomi-Black-Shark-4.jpg',4,0,0,0,0,1,3,10,7,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Xiaomi Black Shark 3' ,1300000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Xiaomi-Black-Shark-3.jpg',4,0,0,0,0,1,3,10,7,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
INSERT dbo.SanPham VALUES ( N'Xiaomi Black Shark 3 PRO' ,1700000 , '11/5/2018 10:34:28 AM',NULL,NULL,N'Xiaomi-Black-Shark-3-PRO.jpg',4,0,0,0,0,1,3,10,7,0,N'No-Image.png',N'No-Image.png',N'No-Image.png',N'No-Image.png')
select * from dbo.SanPham