GCJV0XyV

1$string = serialize(array(1, 2, 'foo', 'tree', 'monkey'); 
2     
3$array = unserialize($string); 
4     
5/*
6
7Navicat MySQL Data Transfer
8
9
10Date: 2009-10-20 03:01:18
11
12*/
13
14
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19
20-- Table structure for `job_scores`
21
22-- ----------------------------
23
24DROP TABLE IF EXISTS `job_scores`;
25
26CREATE TABLE `job_scores` (
27
28  `job_id` int(2) NOT NULL,
29
30  `user_id` int(2) NOT NULL,
31
32  `rating` tinyint(2) NOT NULL
33
34) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
35
36
37
38-- ----------------------------
39
40-- Records of job_scores
41
42-- ----------------------------
43
44INSERT INTO `job_scores` VALUES ('1', '1', '10');
45
46
47
48-- ----------------------------
49
50-- Table structure for `jobs`
51
52-- ----------------------------
53
54DROP TABLE IF EXISTS `jobs`;
55
56CREATE TABLE `jobs` (
57
58  `id` int(2) NOT NULL auto_increment,
59
60  `name` varchar(50) collate utf8_unicode_ci default NULL,
61
62  PRIMARY KEY  (`id`)
63
64) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
65
66
67
68-- ----------------------------
69
70-- Records of jobs
71
72-- ----------------------------
73
74INSERT INTO `jobs` VALUES ('1', 'plumber');
75
76
77
78-- ----------------------------
79
80-- Table structure for `users`
81
82-- ----------------------------
83
84DROP TABLE IF EXISTS `users`;
85
86CREATE TABLE `users` (
87
88  `id` int(2) NOT NULL auto_increment,
89
90  `name` varchar(50) collate utf8_unicode_ci NOT NULL,
91
92  PRIMARY KEY  (`id`)
93
94) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
95
96
97
98-- ----------------------------
99
100-- Records of users
101
102-- ----------------------------
103
104INSERT INTO `users` VALUES ('1', 'John'); 
105     
106SELECT
107
108jobs.name as job_name, users.name as user_name, job_scores.rating
109
110FROM
111
112job_scores
113
114
115INNER JOIN jobs ON jobs.id = job_scores.job_id
116INNER JOIN users on users.id = job_scores.user_id
117
118WHERE 
119
120user_id = 1 
121     
122CREATE TABLE table1 (jsonString JSON);
123
124INSERT INTO table1 VALUES('{"car": "bmw", "year": "2006", "key": "value"  }');