>
> The difference between 4.0 and Max-4.0 is that Max
> supports also BDB tables.
>
> Regards,
>
> Heikki
>
> - Original Message -
> From: "Michael Ivanyo" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Saturday, J
You shouldn't have a problem if you list each foreign
key separately, as follows:
foreign key (MenuName) references MenuDetails
(MenuName)on update restrict on delete restrict,
foreign key (MenuParentName) references MenuDetails
(MenuParentName)on update restrict on delete restrict,
That's how
Hello,
I've experienced what seems to be the same problem on
Redhat 7.2. I eventually realized that in addition to
the regular 4.0.2 server RPM, I had to also install
the MySql-Max 4.0.2 server RPM. After that,
everything worked fine.
I was under the impression that there would only be
one ser
I am using MySql with InnoDB and have just discovered
that tables created using char types show up as
varchars when I type, describe tableName. Previously,
I was using MyIsam tables and did not see char types
being changed to varchars so I am a bit puzzled.
This is true for almost all of the tab
Okay, here is a possible solution, you will have to
try it to see if it is successful. It is based on the
fact that a table can be joined to itself.
select b.book_title,ba.publisher_code AS Author,
bb.publisher_code AS Publisher
from books b, basic_data ba, basic_data bb
where b.author
Hello,
My perception of the InnoDB vs BDB question is that
although the BDB is very impressive and long standing,
it does not get the same level of attention that
InnoDB seems to get from the good folks at MySQL AB.
If I am not mistaken, BDB does not yet offer foreign
key support.
I have chosen
Hi,
I am currently running MySQL-3.23.51 on RedHat Linux
7.2 and would like to gradually switch to
MySQL-Max-3.23.51. My question is, would I be able to
install them both if I only run one at a time?
I am really looking forward to trying out transations
and foreign keys using InnoDB and am in
Friends,
I am designing a MySql DB schema that will use foreign
keys similar to:
create table orders(id int auto_increment primary key,
amount double(7,2) );
create table orderItems(id int, item char(20), price
double(5,2), quantity int, key(id), foreign key id
references orders (id));
I am cu
I am using MySql-3.23.51. Even though this version
doesn't support foreign keys, the foreign key
declarations can be entered without getting an error
message. I would like to write CREATE TABLE
statements that include foreign key declarations that
would be compatible with future releases that wi
I do not fully understand the license requirements and
have a question. The application that I am developing
will be able to work with either MySql, Postgres, or
Oracle. Will I still need a license if the user
decides to connect to a MySql database?
--Michael
__
I would like to set up a MySql database that will
store distance information for a milage lookup
program. The user will enter the origin city and the
destination city for some predefined trips. Then the
query will need to return the milage broken down by
state. For example, for an origin city i
Hello to all,
I would like to set up a MySql database that will
store trip information for a milage lookup
program. The user will enter the origin city/st and
the destination city/st for some predefined trips.
Then the query will need to return the milage broken
down by state. For example, for
I would like to set up a MySql database that will
store distance information for a milage lookup
program. The user will enter the origin city and the
destination city for some predefined trips. Then the
query will need to return the milage broken down by
state. For example, for an origin city i
I am designing a database using MySql and need a
column that can hold a boolean value of T or F. I am
considering both the enum type and char type.
I would like to know if the enum type is a standard
type as defined by the ANSI SQL standard.
--Michael
14 matches
Mail list logo