发表于 2009年06月19日

建表   CREATE TABLE `tb_venue` (                                                                              `venueid` int(10) unsigned NOT NULL auto_increment,                                                  `venue_name` varchar(255) NOT NULL default ”,                                                       `venue_name_en` varchar(255) NOT NULL default ”,                                                                                                  KEY `idx_cityid_status_featured_venueid` (`cityid`,`status`,`featured_type`,`venueid`),              KEY `idx_cityid_pinyinfull` (`cityid`,`pinyin_full`)                                               ) ENGINE=InnoDB DEFAULT CHARSET=utf8    插入字段 alter table db_event.tb_event_info, add column `special_tickets` varchar(128) default NULL after flyer_file_name, add column `special_price` [...]