常用建表语句mysql

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是否一致，如果不一致就抛出异常，并不做更新

持续更新~