|
Beispiele:
SELECT COUNT(*) FROM nwCustomers
SELECT * FROM nwEmployees WHERE Birthdate > '1965-01-01'
SELECT * FROM nwProducts, nwSuppliers
WHERE nwProducts.SupplierID = nwSuppliers.SupplierID
AND nwSuppliers.CompanyName = 'Pasta Buttini s.r.l.'
|
Hier eine Übersicht über die Tabellen:
nwCustomers
| Spalte |
Typ |
| CustomerID
|
varchar(5) |
|
CompanyName |
varchar(40) |
|
ContactName |
varchar(30) |
|
ContactTitle |
varchar(30) |
| Address
|
varchar(60) |
| City |
varchar(15) |
| Region |
varchar(15) |
|
PostalCode |
varchar(10) |
| Country
|
varchar(15) |
| Phone |
varchar(24) |
| Fax |
varchar(24) |
nwEmployees
| Spalte |
Typ |
| EmployeeID
|
int(11) |
|
LastName |
varchar(20) |
| FirstName |
varchar(10) |
| Title |
varchar(30) |
|
TitleOfCourtesy |
varchar(25) |
|
BirthDate |
date |
|
HireDate |
date |
| Address
|
varchar(60) |
| City |
varchar(15) |
| Region |
varchar(15) |
|
PostalCode |
varchar(10) |
| Country
|
varchar(15) |
| HomePhone |
varchar(24) |
| Extension |
varchar(4) |
| Notes |
text |
|
ReportsTo |
int(11) |
|
PhotoFileName |
varchar(255) |
nwOrderDetails
| Spalte |
Typ |
| OrderID
|
int(11) |
| ProductID
|
int(11) |
| UnitPrice |
decimal(9,2) |
| Quantity |
smallint(5) |
| Discount |
double |
nwOrders
| Spalte |
Typ |
| OrderID
|
int(11) |
| CustomerID |
varchar(5) |
| EmployeeID |
int(11) |
| OrderDate |
date |
| RequiredDate |
date |
| ShippedDate |
date |
| ShipVia |
int(11) |
| Freight |
decimal(9,2) |
| ShipName |
varchar(40) |
| ShipAddress |
varchar(60) |
| ShipCity |
varchar(15) |
| ShipRegion |
varchar(15) |
| ShipPostalCode |
varchar(10) |
| ShipCountry |
varchar(15) |
nwProducts
| Spalte |
Typ |
| ProductID
|
int(11) |
| ProductName |
varchar(40) |
| SupplierID |
int(11) |
| CategoryID |
int(11) |
| QuantityPerUnit |
varchar(20) |
| UnitPrice |
decimal(9,2) |
| UnitsInStock |
smallint(6) |
| UnitsOnOrder |
smallint(6) |
| ReorderLevel |
smallint(6) |
| Discontinued |
char(1) |
nwShippers
| Spalte |
Typ |
| ShipperID
|
int(11) |
| CompanyName |
varchar(40) |
| Phone |
varchar(24) |
nwSuppliers
| Spalte |
Typ |
| SupplierID
|
int(11) |
| CompanyName |
varchar(40) |
| ContactName |
varchar(30) |
| ContactTitle |
varchar(30) |
| Address |
varchar(60) |
| City |
varchar(15) |
| Region |
varchar(15) |
| PostalCode |
varchar(10) |
| Country |
varchar(15) |
| Phone |
varchar(24) |
| Fax |
varchar(24) |
|
HomePage |
text |
|