9.3.1.sql

来自「Hibernate开发及整合应用大全 蔡雪焘编著 本书用典型的示例剖析Hiber」· SQL 代码 · 共 27 行

drop database if exists schoolproject;
create database schoolproject;
use schoolproject;

--
-- Table structure for table `student`2005-2-2 16:31

DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `name` varchar(20) NOT NULL default '',
  `cardId` varchar(20) NOT NULL default '',
  `age` int(11) default '0',
  PRIMARY KEY  (`name`,`cardId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `student`
--


/*!40000 ALTER TABLE `student` DISABLE KEYS */;
LOCK TABLES `student` WRITE;
INSERT INTO `student` VALUES ('tom','200512333',33),('tomclus','200512345',33);
UNLOCK TABLES;