mysql 5.0

hattori.hanzo · 02-24-2009, 05:31 PM

What is the use of UNION=() in CREATE TABLE?

Code:

ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 UNION=();

I have been given some code and could not explain why it's err's out. Checked the mysql 5.0 manual but nothing(http://dev.mysql.com/doc/refman/5.0/...ate-table.html). It only explains using UNION in a SELECT statement which I understand.

If I drop off UNION=() then CREATE TABLE works fine.

thanks & regards

gergely89 · 02-24-2009, 07:37 PM

UNION is one of the table options and in your code it has no valid values (no table name defined), so that might be the reason why MySQL throws the error. It should be something like

Quote:

ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 UNION=(tbl_name);

linux

hattori.hanzo · 02-24-2009, 08:14 PM

Thanks. I kinda suspected that. I will check with the dude who wrote the code.

regards

Vanostaajen · 02-25-2009, 04:05 PM

I have a qsuestion: Why is sqlite(sucks) standard in amarok in ubuntu instead of mysql(rocks)? And why is it so damn hard to configure mysql?

jlinkels · 02-25-2009, 08:12 PM

You'd better start a new thread on this, it is totally unrelated with the orginal question.

What is your problem configuring MySQL. Installation? Or setting up a database?

jlinkels