MySQL and Relationships

[Tarbuza Smith]

I was told that it is easy to create a table in MYSQL but it is hard
to create a table with relationship like in Oracle or SQL Server by
using Relationship or Query by Design or whatever wysiwyg tools. It
has to be done by SQL query. Is there a better way to do that in
MySQL? I would appreciate any suggestions.

[swdev1]

Hi - would this be of help to you ?
---
Hi!

InnoDB is a MySQL table type which provides transactions, foreign key
constraints, and a non-free hot backup tool.

InnoDB is included in MySQL-Max-3.23 downloads, and in all downloads of
MySQL-4.0 and MySQL-4.1.

Release 3.23.58 is a bugfix release of the 'old' stable 3.23 branch. For
production use, MySQL-4.0 is now the recommended version.

The full InnoDB changelog of 3.23.58:

* Fixed a bug: InnoDB could make the index page directory corrupt in the
first B-tree page splits after mysqld startup. A symptom would be an
assertion in page0page.c, in function page_dir_find_slot().

* Fixed a bug: InnoDB could in rare cases return an extraneous row if a
rollback, purge, and a SELECT coincided.

* Fixed a possible hang over the btr0sea.c latch if SELECT was used inside
LOCK TABLES.

* Fixed a bug: if a single DELETE statement first managed to delete some
rows and then failed in a FOREIGN KEY error or a 'Table is full error',
MySQL did not roll back the whole SQL statement as it should.

Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
---
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Tarbuza Smith" <ta*****@yahoo.com> wrote in message
news:5b**************************@posting.google.c om...

I was told that it is easy to create a table in MYSQL but it is hard
to create a table with relationship like in Oracle or SQL Server by
using Relationship or Query by Design or whatever wysiwyg tools. It
has to be done by SQL query. Is there a better way to do that in
MySQL? I would appreciate any suggestions.

[swdev1]

Hi - would this be of help to you ?
---
Hi!

InnoDB is a MySQL table type which provides transactions, foreign key
constraints, and a non-free hot backup tool.

InnoDB is included in MySQL-Max-3.23 downloads, and in all downloads of
MySQL-4.0 and MySQL-4.1.

Release 3.23.58 is a bugfix release of the 'old' stable 3.23 branch. For
production use, MySQL-4.0 is now the recommended version.

The full InnoDB changelog of 3.23.58:

* Fixed a bug: InnoDB could make the index page directory corrupt in the
first B-tree page splits after mysqld startup. A symptom would be an
assertion in page0page.c, in function page_dir_find_slot().

* Fixed a bug: InnoDB could in rare cases return an extraneous row if a
rollback, purge, and a SELECT coincided.

* Fixed a possible hang over the btr0sea.c latch if SELECT was used inside
LOCK TABLES.

* Fixed a bug: if a single DELETE statement first managed to delete some
rows and then failed in a FOREIGN KEY error or a 'Table is full error',
MySQL did not roll back the whole SQL statement as it should.

Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
---
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Tarbuza Smith" <ta*****@yahoo.com> wrote in message
news:5b**************************@posting.google.c om...

I was told that it is easy to create a table in MYSQL but it is hard
to create a table with relationship like in Oracle or SQL Server by
using Relationship or Query by Design or whatever wysiwyg tools. It
has to be done by SQL query. Is there a better way to do that in
MySQL? I would appreciate any suggestions.