====== Beispielbefehle ====== mysql> alter table 7b add column (plz varchar(4)); Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> alter table 7b add column (ort varchar(25)); Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe 7b; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | id | int(11) | NO | | NULL | | | nachname | varchar(25) | YES | | NULL | | | vorname | varchar(20) | YES | | NULL | | | strasse | varchar(25) | YES | | NULL | | | nr | int(11) | YES | | NULL | | | plz | varchar(4) | YES | | NULL | | | ort | varchar(25) | YES | | NULL | | +----------+-------------+------+-----+---------+-------+ 7 rows in set (0.00 sec) mysql> alter table 7b modify plz char(4); Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe tables; ERROR 1146 (42S02): Table 'adressen.tables' doesn't exist mysql> describe 7b; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | id | int(11) | NO | | NULL | | | nachname | varchar(25) | YES | | NULL | | | vorname | varchar(20) | YES | | NULL | | | strasse | varchar(25) | YES | | NULL | | | nr | int(11) | YES | | NULL | | | plz | char(4) | YES | | NULL | | | ort | varchar(25) | YES | | NULL | | +----------+-------------+------+-----+---------+-------+ 7 rows in set (0.00 sec) mysql> alter table 7b modify nr varchar(8); Query OK, 0 rows affected (0.09 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe 7b; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | id | int(11) | NO | | NULL | | | nachname | varchar(25) | YES | | NULL | | | vorname | varchar(20) | YES | | NULL | | | strasse | varchar(25) | YES | | NULL | | | nr | varchar(8) | YES | | NULL | | | plz | char(4) | YES | | NULL | | | ort | varchar(25) | YES | | NULL | | +----------+-------------+------+-----+---------+-------+ 7 rows in set (0.00 sec) mysql> insert into 7b (id, nachname, vorname, strasse, nr, plz, ort) values (1,A rtmüller,Stefan,Franz Pilz Strasse, 9, 3300, Amstetten); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'üller ,Stefan,Franz Pilz Strasse, 9, 3300, Amstetten)' at line 1 mysql> insert into 7b (id, nachname, vorname, strasse, nr, plz, ort) values (1," Artmüller","Stefan","Franz Pilz Strasse", "9", "3300", "Amstetten"); Query OK, 1 row affected (0.02 sec) mysql> select * from 7b; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 1 row in set (0.00 sec) mysql> insert into 7b (nachname, vorname, strasse, nr, plz, ort) values ("Artmül ler","Stefan","Franz Pilz Strasse", "9", "3300", "Amstetten"); Query OK, 1 row affected, 1 warning (0.01 sec) mysql> select * from 7b; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | | 0 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 2 rows in set (0.00 sec) mysql> insert into 7b (id, nachname, vorname, strasse, nr, plz, ort) values (1," Artmüller","Stefan","Franz Pilz Strasse", "9", "3300", "Amstetten"); Query OK, 1 row affected (0.00 sec) mysql> select * from 7b; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | | 0 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 3 rows in set (0.00 sec) mysql> insert into 7b (nachname, vorname, strasse, nr, plz, ort) values ("Artmül ler","Stefan","Franz Pilz Strasse", "9", "3300", "Amstetten"); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> select * from 7b; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | | 0 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | | 0 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 4 rows in set (0.00 sec) mysql> delete from 7b where id = 0; Query OK, 2 rows affected (0.01 sec) mysql> select * from 7b; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 2 rows in set (0.00 sec) mysql> delete from 7b where id = 0 limit 1; Query OK, 0 rows affected (0.02 sec) mysql> select * from 7b; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 2 rows in set (0.00 sec) mysql> delete from 7b where id = 1 limit 1; Query OK, 1 row affected (0.00 sec) mysql> select * from 7b; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 1 row in set (0.00 sec) mysql> insert into 7b (id, nachname, vorname, strasse, nr, plz, ort) values (1," Artmüller","Stefan","Franz Pilz Strasse", "9", "3300", "Amstetten"); Query OK, 1 row affected (0.00 sec) mysql> describe 7b; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | id | int(11) | NO | | NULL | | | nachname | varchar(25) | YES | | NULL | | | vorname | varchar(20) | YES | | NULL | | | strasse | varchar(25) | YES | | NULL | | | nr | varchar(8) | YES | | NULL | | | plz | char(4) | YES | | NULL | | | ort | varchar(25) | YES | | NULL | | +----------+-------------+------+-----+---------+-------+ 7 rows in set (0.00 sec) mysql> delete from 7b where id = 1 limit 1; Query OK, 1 row affected (0.00 sec) mysql> select * from 7b; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 1 row in set (0.00 sec) mysql> insert into 7b (id, nachname, vorname, strasse, nr, plz, ort) values (2," Brottrager","Johannes","Völkrahof", "6", "332", "Euratsfeld"); Query OK, 1 row affected (0.02 sec) mysql> select * from 7b; +----+------------+----------+--------------------+------+------+------------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+------------+----------+--------------------+------+------+------------+ | 2 | Brottrager | Johannes | Völkrahof | 6 | 332 | Euratsfeld | | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+------------+----------+--------------------+------+------+------------+ 2 rows in set (0.00 sec) mysql> delete from 7b where id = 2 limit 1; Query OK, 1 row affected (0.00 sec) mysql> insert into 7b (id, nachname, vorname, strasse, nr, plz, ort) values (2," Brottrager","Johannes","Völkrahof", "6", "3324", "Euratsfeld"); Query OK, 1 row affected (0.00 sec) mysql> select * from 7b; +----+------------+----------+--------------------+------+------+------------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+------------+----------+--------------------+------+------+------------+ | 2 | Brottrager | Johannes | Völkrahof | 6 | 3324 | Euratsfeld | | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+------------+----------+--------------------+------+------+------------+ 2 rows in set (0.00 sec) mysql> select nachname, vorname from 7b; +------------+----------+ | nachname | vorname | +------------+----------+ | Brottrager | Johannes | | Artmüller | Stefan | +------------+----------+ 2 rows in set (0.00 sec) mysql> select nachname, vorname, ort from 7b where plz="3300"; +-----------+---------+-----------+ | nachname | vorname | ort | +-----------+---------+-----------+ | Artmüller | Stefan | Amstetten | +-----------+---------+-----------+ 1 row in set (0.00 sec) mysql> select * from 7b where strasse like "%Pilz%"; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 1 row in set (0.00 sec) mysql> select * from 7b where strasse like '%Pilz%'; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 1 row in set (0.00 sec) mysql> select * from 7b where strasse like 'Pilz'; Empty set (0.00 sec) mysql> select * from 7b where strasse like 'Pilz%'; Empty set (0.00 sec) mysql> select * from 7b where strasse like '%pilz%'; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 1 row in set (0.00 sec) mysql> select * from 7b where strasse like '%pils%'; Empty set (0.00 sec) mysql> select * from 7b where strasse like '%pilz%'; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 1 row in set (0.00 sec) mysql> select * from 7b where strasse = '%pilz%'; Empty set (0.00 sec) mysql> select * from 7b where strasse = '%Pilz%'; Empty set (0.00 sec) mysql> select * from 7b where strasse like '%Strasse%'; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 1 row in set (0.00 sec) mysql> select * from 7b where strasse like 'Pil_'; Empty set (0.00 sec) mysql> select * from 7b where strasse like '%Pil_ Strasse%'; +----+-----------+---------+--------------------+------+------+-----------+ | id | nachname | vorname | strasse | nr | plz | ort | +----+-----------+---------+--------------------+------+------+-----------+ | 1 | Artmüller | Stefan | Franz Pilz Strasse | 9 | 3300 | Amstetten | +----+-----------+---------+--------------------+------+------+-----------+ 1 row in set (0.00 sec) mysql>