469,648 Members | 1,549 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

MySQL and Relationships

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.
Jul 19 '05 #1
2 3802
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.

Jul 19 '05 #2
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.

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by sandy | last post: by
reply views Thread by eli | last post: by
6 posts views Thread by jacob nikom | last post: by
2 posts views Thread by Obi Wan Shinobi | last post: by
reply views Thread by Missaka Wijekoon | last post: by
3 posts views Thread by Gregory.Spencer | last post: by
1 post views Thread by Smriti Dev | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.