קובץ SQL להורדה

אתם יכולים להעתיק את הקוד ולהשתמש בו במדריכי ה-mySQL.

--
-- Table structure for table `workers`
--
 
CREATE TABLE IF NOT EXISTS `workers` (
`workers_id` smallint(6) NOT NULL AUTO_INCREMENT,
`workers_name` varchar(25) DEFAULT NULL,
`workers_phone1` varchar(11) DEFAULT NULL,
`workers_phone2` varchar(11) DEFAULT NULL,
`workers_city` varchar(25) DEFAULT NULL,
`workers_date_added` date DEFAULT NULL,
`workers_comment` tinytext,
PRIMARY KEY (`workers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
 
--
-- Dumping data for table `workers`
--
 
INSERT INTO `workers` (`workers_id`, `workers_name`, `workers_phone1`, `workers_phone2`,
`workers_city`, `workers_date_added`, `workers_comment`) VALUES
(1, 'Moshe', '09-9888887', NULL, 'Hakrayot', '2011-06-07', NULL),
(2, 'Yechezkel', '04-4888887', NULL, 'Ramat Hasharon', '2011-06-07', NULL),
(3, 'Yirmiyahu', '03-3333337', NULL, 'Bat Yam', '2011-06-07', NULL),
(4, 'Gershon', '0544-444333', NULL, 'Beer-sheva', '2011-06-08', NULL),
(5, 'Asher', '02-2000002', NULL, 'Jerusalem', '2011-06-08', NULL),
(6, 'Metushelah', '09-99999998', NULL, 'Natanyah', '2011-06-08', NULL),
(7, 'Yoshiahu', '09-8999997', NULL, 'Hakrayot', '2011-06-09', NULL),
(8, 'Sheshet', '09-9777778', NULL, 'Hakrayot', '2011-06-09', NULL),
(9, 'Eliezer', '03-7333335', NULL, 'Bat Yam', '2011-06-09', NULL),
(10, 'Shlomo', '08-8666666', NULL, 'Kiryat Gat', '2011-06-09', NULL),
(11, 'Zrubavel', '07-7888887', NULL, 'Hakrayot', '2011-06-21', NULL),
(12, 'Koresh', '02-2888887', NULL, 'Rosh haayin', '2011-06-21', NULL),
(13, 'Yehuda', '02-2233337', NULL, 'Makabim', '2011-06-21', NULL);

אהבתם? לא אהבתם? דרגו!

0 הצבעות, ממוצע 0 מתוך 5 כוכבים