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>