Ac653UMP

1SELECT * 
2FROM address_book 
3WHERE  zip_code IN ("44801")
4AND street_key IN ( 9659600003) ;
5
6SELECT * 
7FROM address_book 
8WHERE  zip_code IN ("44801")
9AND street_key IN ( 5169100001 );
10
11SELECT * 
12FROM address_book 
13WHERE  zip_code IN ("44801") 
14AND street_key IN ( 9659600003 , 5169100001 ); 
15     
16SELECT * 
17FROM address_book 
18WHERE  zip_code IN ("18107") 
19AND street_key IN (26908700001 , 9631900009 ) 
20     
21-- --------------------------------------------------------
22-- Host:                         127.0.0.1
23-- Server Version:               10.4.6-MariaDB - mariadb.org binary distribution
24-- Server Betriebssystem:        Win64
25-- HeidiSQL Version:             10.2.0.5599
26-- --------------------------------------------------------
27
28/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
29/*!40101 SET NAMES utf8 */;
30/*!50503 SET NAMES utf8mb4 */;
31/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
32/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
33
34-- Exportiere Struktur von Tabelle test.adresse_verzeichnis
35CREATE TABLE IF NOT EXISTS `adresse_verzeichnis` (
36  `ort_alort` int(10) unsigned NOT NULL,
37  `str_schluessel` bigint(20) unsigned NOT NULL,
38  `otl_schl` smallint(5) unsigned DEFAULT NULL,
39  `kgs` int(10) unsigned NOT NULL,
40  `plz` varchar(5) NOT NULL,
41  KEY `FK__ort_verzeichnis3` (`ort_alort`),
42  KEY `FK__strasse_verzeichnis3` (`str_schluessel`),
43  KEY `FK__ortsteil_verzeichnis3` (`otl_schl`),
44  KEY `FK__plz_verzeichnis3` (`plz`),
45  KEY `FK_adresse_verzeichnis_gemeinde_verzeichnis` (`kgs`),
46  CONSTRAINT `FK__ort_verzeichnis3` FOREIGN KEY (`ort_alort`) REFERENCES `ort_verzeichnis` (`ort_alot`),
47  CONSTRAINT `FK__ortsteil_verzeichnis3` FOREIGN KEY (`otl_schl`) REFERENCES `ortsteil_verzeichnis` (`otl_schl`),
48  CONSTRAINT `FK__plz_verzeichnis3` FOREIGN KEY (`plz`) REFERENCES `plz_verzeichnis` (`plz`),
49  CONSTRAINT `FK__strasse_verzeichnis3` FOREIGN KEY (`str_schluessel`) REFERENCES `strasse_verzeichnis` (`str_schluessel`),
50  CONSTRAINT `FK_adresse_verzeichnis_gemeinde_verzeichnis` FOREIGN KEY (`kgs`) REFERENCES `gemeinde_verzeichnis` (`kgs_id`)
51) ENGINE=InnoDB DEFAULT CHARSET=latin1;
52
53
54/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
55/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
56/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;