ZSawLEQ5

1        SELECT * 
2	FROM recipes r
3//	INNER JOIN country_cats cc ON(cc.catid = r.catid)
4	WHERE 
5	r.catid = 3 AND
6	r.countryid = 1 
7 //    AND 	cc.countryid=1
8
9
10# --------------------------------------------------------
11# Host:                         127.0.0.1
12# Server version:               5.5.8-log
13# Server OS:                    Win32
14# HeidiSQL version:             6.0.0.3603
15# Date/time:                    2011-10-02 18:29:50
16# --------------------------------------------------------
17
18/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
19/*!40101 SET NAMES utf8 */;
20/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
21/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
22
23# Dumping structure for table demo.cats
24DROP TABLE IF EXISTS `cats`;
25CREATE TABLE IF NOT EXISTS `cats` (
26  `catid` int(10) unsigned NOT NULL AUTO_INCREMENT,
27  `title` varchar(50) NOT NULL,
28  PRIMARY KEY (`catid`)
29) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
30
31# Dumping data for table demo.cats: ~3 rows (approximately)
32/*!40000 ALTER TABLE `cats` DISABLE KEYS */;
33INSERT INTO `cats` (`catid`, `title`) VALUES
34	(1, 'meet'),
35	(2, 'chicken'),
36	(3, 'ישראלי');
37/*!40000 ALTER TABLE `cats` ENABLE KEYS */;
38
39
40# Dumping structure for table demo.countries
41DROP TABLE IF EXISTS `countries`;
42CREATE TABLE IF NOT EXISTS `countries` (
43  `countryid` int(10) unsigned NOT NULL AUTO_INCREMENT,
44  `title` varchar(50) NOT NULL DEFAULT '0',
45  PRIMARY KEY (`countryid`)
46) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
47
48# Dumping data for table demo.countries: ~4 rows (approximately)
49/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
50INSERT INTO `countries` (`countryid`, `title`) VALUES
51	(1, 'ישראל'),
52	(2, 'גרמניה'),
53	(3, 'ארה"ב'),
54	(4, 'אנגליה');
55/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
56
57
58# Dumping structure for table demo.country_cats
59DROP TABLE IF EXISTS `country_cats`;
60CREATE TABLE IF NOT EXISTS `country_cats` (
61  `ccid` int(10) unsigned NOT NULL AUTO_INCREMENT,
62  `countryid` int(10) unsigned DEFAULT NULL,
63  `catid` int(10) unsigned DEFAULT NULL,
64  PRIMARY KEY (`ccid`),
65  KEY `FK_country_cats_countries` (`countryid`),
66  KEY `FK_country_cats_cats` (`catid`),
67  CONSTRAINT `FK_country_cats_countries` FOREIGN KEY (`countryid`) REFERENCES `countries` (`countryid`) ON DELETE CASCADE ON UPDATE NO ACTION,
68  CONSTRAINT `FK_country_cats_cats` FOREIGN KEY (`catid`) REFERENCES `cats` (`catid`) ON DELETE CASCADE ON UPDATE NO ACTION
69) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
70
71# Dumping data for table demo.country_cats: ~7 rows (approximately)
72/*!40000 ALTER TABLE `country_cats` DISABLE KEYS */;
73INSERT INTO `country_cats` (`ccid`, `countryid`, `catid`) VALUES
74	(1, 1, 3),
75	(2, 1, 1),
76	(3, 3, 1),
77	(4, 4, 2),
78	(5, 3, 2),
79	(6, 4, 3),
80	(7, 3, 3);
81/*!40000 ALTER TABLE `country_cats` ENABLE KEYS */;
82
83
84# Dumping structure for table demo.recipes
85DROP TABLE IF EXISTS `recipes`;
86CREATE TABLE IF NOT EXISTS `recipes` (
87  `recipeid` int(10) unsigned NOT NULL AUTO_INCREMENT,
88  `catid` int(10) unsigned DEFAULT NULL,
89  `countryid` int(10) unsigned DEFAULT NULL,
90  `title` varchar(100) DEFAULT NULL,
91  PRIMARY KEY (`recipeid`),
92  KEY `FK_recipes_cats` (`catid`),
93  KEY `FK_recipes_countries` (`countryid`),
94  CONSTRAINT `FK_recipes_countries` FOREIGN KEY (`countryid`) REFERENCES `countries` (`countryid`) ON DELETE CASCADE ON UPDATE NO ACTION,
95  CONSTRAINT `FK_recipes_cats` FOREIGN KEY (`catid`) REFERENCES `cats` (`catid`) ON DELETE CASCADE ON UPDATE NO ACTION
96) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
97
98# Dumping data for table demo.recipes: ~3 rows (approximately)
99/*!40000 ALTER TABLE `recipes` DISABLE KEYS */;
100INSERT INTO `recipes` (`recipeid`, `catid`, `countryid`, `title`) VALUES
101	(1, 3, 1, 'ארוחת בוקר ישראלית'),
102	(2, 1, NULL, NULL),
103	(3, 3, 2, 'ארוחת בוקר גרמנית וישראלית ביחד');
104/*!40000 ALTER TABLE `recipes` ENABLE KEYS */;
105/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
106/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
107/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;