MySQL Forums
Forum List  »  Merge Storage Engine

Merge table on Windows server problems
Posted by: Ashley Golden
Date: April 21, 2005 01:12PM

When we merge tables with the following query, the table is created, but contains no data. Any help would be greatly appreciated.

DROP TABLE IF EXISTS fin_mod_users;

CREATE TABLE fin_mod_users (
user_id int(10) unsigned NOT NULL default '0',
username varchar(20) binary NOT NULL default '',
password varchar(32) binary NOT NULL default '',
email varchar(50) default NULL,
admin_switch smallint(6) NOT NULL default '0',
groups text,
deity smallint(6) NOT NULL default '0',
log_sess int(10) unsigned NOT NULL default '0',
last_on int(10) unsigned NOT NULL default '0',
cookie varchar(32) default NULL,
PRIMARY KEY (user_id)
) ENGINE=MyISAM UNION=(mod_users) INSERT_METHOD=LAST;

Options: ReplyQuote


Subject
Views
Written By
Posted
Merge table on Windows server problems
5355
April 21, 2005 01:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.