drop table if exists product;
CREATE TABLE `product` (
`id` bigint(11) NOT NULL,
`name` varchar(30) NOT NULL,
`price` decimal(11,1) NOT NULL,
`farmId` bigint(11) NOT NULL,
`des` varchar(255) DEFAULT NULL,
`status` varchar(20) DEFAULT NULL,
`store` int(11) UNSIGNED DEFAULT NULL,
PRIMARY KEY (`id`),
KEY (`name`,`farmId`),
KEY (`farmId`),
Key (`farmId`,`store`,`STATUS`),
KEY(`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
建表语句查看
1.show create table tablename;
2.use information_schema;
select * from columns where table_name='tablename'
CREATE TABLE `jos_modules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`content` text NOT NULL,
`ordering` int(11) NOT NULL DEFAULT '0',
`position` varchar(50) DEFAULT NULL,
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL DEFAULT '0',
`module` varchar(50) DEFAULT NULL,
`numnews` int(11) NOT NULL DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1',
`params` text NOT NULL,
`iscore` tinyint(4) NOT NULL DEFAULT '0',
`client_id` tinyint(4) NOT NULL DEFAULT '0',
`control` text NOT NULL,
PRIMARY KEY (`id`),
KEY `published` (`published`,`access`),
KEY `newsfeeds` (`module`,`published`)
) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=utf8
Hibernate auto配置参数含义
create:表示启动的时候先drop,再create
create-drop: 也表示创建,只不过再系统关闭前执行一下drop
update: 这个操作启动的时候会去检查schema是否一致,如果不一致会做scheme更新
validate: 启动时验证现有schema与你配置的hibernate是否一致,如果不一致就抛出异常,并不做更新
持续更新~