sql

-- ----------------------------
-- Table structure for `customer_bak`
-- ----------------------------
DROP TABLE IF EXISTS `customer_bak`;
CREATE TABLE `customer_bak` (
  `id` bigint(20) NOT NULL,
  `deleted` tinyint(4) default '0',
  `imark` varchar(255) default NULL,
  `raw_add_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `raw_update_time` datetime default NULL,
  `version` int(11) default '0',
  `customer_source` bigint(20) default NULL,
  `area_id` bigint(20) default NULL,
  `building_id` bigint(20) default NULL,
  `building_type` bigint(20) default NULL,
  `name` varchar(255) default NULL,
  `phone` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ENGINE=InnoDB:数据库引擎，

DEFAULT CHARSET=utf8; 默认的字符集为utf-8.

给表增加字段在某个字段后：

ALTER TABLE question ADD twentySeven VARCHAR(2) NULL AFTER twentySix;