/*
MySQL Data Transfer
Source Host: localhost
Source Database: l2
Target Host: localhost
Target Database: l2
Date: 13.03.2013 19:00:43
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tablica
-- ----------------------------
DROP TABLE IF EXISTS `tablica`;
CREATE TABLE `tablica` (
`prepod` VARCHAR(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`ekzamen` VARCHAR(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`gruppa` CHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`god` CHAR(8) COLLATE utf8_unicode_ci DEFAULT NULL,
`predmet` VARCHAR(40) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `tablica` VALUES ('Иванов', 'физика', '63', '2012', 'физика');
INSERT INTO `tablica` VALUES ('Иванов', 'алгебра', '85', '2013', 'математика');
INSERT INTO `tablica` VALUES ('Иванов', 'геометрия', '63', '2012', 'математика');
Code: SQL