WVRARAUd

1drop database if exists autovermietung;
2create database autovermietung;
3use autovermietung;
4
5# --------------------------------------------------------
6
7#
8# Tabellenstruktur für Tabelle `kunde`
9#
10
11DROP TABLE IF EXISTS `kunde`;
12CREATE TABLE `kunde` (
13  `kundennr` int(11) NOT NULL auto_increment,
14  `nachname` varchar(25) default NULL,
15  `vorname` varchar(25) default NULL,
16  `plz` varchar(5) default NULL,
17  `ort` varchar(30) default NULL,
18  `strasse` varchar(30) default NULL,
19  PRIMARY KEY  (`kundennr`)
20);
21
22#
23# Daten für Tabelle `kunde`
24#
25
26INSERT INTO `kunde` (`kundennr`, `nachname`, `vorname`, `plz`, `ort`, `strasse`) VALUES (1, 'Luebbe', 'Klaus', '22123', 'Hamburg', 'Vinetastraße 123');
27INSERT INTO `kunde` (`kundennr`, `nachname`, `vorname`, `plz`, `ort`, `strasse`) VALUES (2, 'Nagel', 'Andreas', NULL, NULL, NULL);
28INSERT INTO `kunde` (`kundennr`, `nachname`, `vorname`, `plz`, `ort`, `strasse`) VALUES (3, 'Giera', 'Heike', NULL, NULL, NULL);
29INSERT INTO `kunde` (`kundennr`, `nachname`, `vorname`, `plz`, `ort`, `strasse`) VALUES (4, 'Stausberg', 'Monika', NULL, NULL, NULL);
30
31# --------------------------------------------------------
32
33# Numbero Dos:
34SELECT Modell 
35FROM pkwtyp 
36WHERE left(modell,1) BETWEEN 'A' AND 'G';