Hello. Please send the complete output of SHOW CREATE TABLE on all tables, which you want to put into merged table. You may check if your new merged table is ok by running queries of your web application in MySQL-Admin.
[EMAIL PROTECTED] wrote: > Hello! > I have been struggling with this, and don=B4t know how to move on. > > I have several databases they have the same stucture. > I want to gather all data fr=E5n one type of table in the databases to > another table: "merge-union operation". > > I have done that operation and it looks okay, but aren=B4t. Beacuse th= > e > index in the new tables are null, in the old tables the index are the s= > ame > as the number of instances in the table. And it mathers beacuse the > webapplikation shows nothing of whats seems to be in the tables. > > I have an webbapplikation in php to present the data (it=B4s formated i= > nto > statistics). And the webbapplikation need besides the "answer" table al= > so a > "person" table. I have Mysql-admin to administrate Mysql. I have some > knowledge about databases in general, but Mysql are new to me. > > My queries looks like this: > > CREATE TABLE answer (id INT, value TINYINT, question INT, person INT, > INDEX(id) ) TYPE=3DMERGE UNION=3D( answer1, person2, person3) > > CREATE TABLE person (id INT(10) unsigned NOT NULL auto_increment, namec= > ode > VARCHAR(50) NOT NULL default '', password VARCHAR (8) default NULL, > isinvited TINYINT(4) NOT NULL default '0', isdone TINYINT (4) NOT NULL > default '0', section TINYINT (3) unsigned default NULL, INDEX(id) , > INDEX(namecode) ) TYPE=3DMERGE UNION=3D(person1, person2, person3 > > I am very thankful for help in this matter. > > > regards > Rosemarie > = > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
