-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcustomers.sql
21 lines (21 loc) · 1.9 KB
/
customers.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
insert into Customers(CustomerID,CustomerName,ContactName,Address,City,PostalCode,Country)
values(1,'Alfreds Futterkiste','Maria Anders','Obere Str. 57','Berlin','12209','Germany');
insert into Customers(CustomerID,CustomerName,ContactName,Address,City,PostalCode,Country)
values(2,'Ana Trujillo Emparedados y helados','Ana Trujillo','Avda. de la Constitución 2222','México D.F.','05021','Mexico');
insert into Customers(CustomerID,CustomerName,ContactName,Address,City,PostalCode,Country)
values(3,'Alfreds Futterkiste','Maria Anders','Obere Str. 57','Berlin','12209','Germany');
insert into Customers(CustomerID,CustomerName,ContactName,Address,City,PostalCode,Country)
values(4,'Alfreds Futterkiste','Maria Anders','Obere Str. 57','Berlin','12209','Germany');
insert into Customers(CustomerID,CustomerName,ContactName,Address,City,PostalCode,Country)
values(5,'Alfreds Futterkiste','Maria Anders','Obere Str. 57','Berlin','12209','Germany');
insert into Customers values(6,'Alfreds Futterkiste','Maria Anders','Obere Str. 57','Berlin','12209','Germany');
insert into Customers(CustomerID,CustomerName,ContactName,Address,City,PostalCode,Country)
values(7,'Alfreds Futterkiste','Maria Anders','Obere Str. 57','','12209','Germany');
insert into Customers(CustomerID,CustomerName,ContactName,Address,City,PostalCode,Country)
values(8,'Alfreds Futterkiste','Maria Anders','Obere Str. 57',' ','12209','Germany');
insert into Customers(CustomerID,CustomerName,ContactName,Address,City,PostalCode,Country)
values(9,'Alfreds Futterkiste','Maria Anders','Obere Str. 57','','12209','Germany');
insert into Customers(CustomerID,CustomerName,ContactName,Address,City,PostalCode,Country)
values(10,'Alfreds Futterkiste','Maria Anders','Obere Str. 57',NULL,'12209','Germany');
insert into Customers(CustomerID,CustomerName,ContactName,Address,City,PostalCode,Country)
values(11,'Abc','Maria Anders','Obere Str. 57',NULL,'12209','Germany');