mysql merge报错ERROR 1168
mysql> create table total ( -> `user_id` varchar(6) NOT NULL default '',-> `provider_id` varchar(6) NOT NULL default '',
-> `org_id` varchar(6) NOT NULL default '',
-> `mbox_id` varchar(8) default NULL,
-> `password` varchar(26) default NULL,
-> `pwd_hint_question` varchar(33) default NULL,
-> `pwd_hint_answer` varchar(13) default NULL,
-> `time_zone` varchar(3) default NULL,
-> `alt_email` varchar(26) default NULL,
-> `true_name` varchar(30) default NULL,
-> `nick_name` varchar(30) default NULL,
-> `gender` char(0) default NULL,
-> `birthday` date default NULL,
-> `pager_number` varchar(6) default NULL,
-> `mobile_number` varchar(6) default NULL,
-> `home_phone` varchar(6) default NULL,
-> `company_phone` varchar(6) default NULL,
-> `fax_number` varchar(6) default NULL,
-> `address` varchar(85) default NULL,
-> `zipcode` varchar(3) default NULL,
-> `city` varchar(20) default NULL,
-> `province` varchar(3) default '0',
-> `country` varchar(20) default NULL,
-> `homepage` varchar(20) default NULL,
-> `anniversary` date default NULL,
-> `netfolder_id` varchar(8) default NULL,
-> `im_account` varchar(53) default NULL,
-> `company` varchar(66) default NULL,
-> `department` varchar(40) default NULL,
-> `position` varchar(40) default NULL,
-> `remind` int(1) default '0',
-> `face` int(11) default '0',
-> PRIMARY KEY(`user_id`,`provider_id`,`org_id`),
-> KEY(`mbox_id`)
-> )
-> ENGINE=MERGE DEFAULT CHARSET=utf8 UNION=(t1,t2) INSERT_METHOD=LAST;
Query OK, 0 rows affected (0.01 sec)
页:
[1]