473,692 Members | 2,315 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3969
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_s lot().

* 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.goo gle.com...
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_s lot().

* 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.goo gle.com...
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
4679
by: sandy | last post by:
Hi All, I am a newbie to MySQL and Python. At the first place, I would like to know what are the general performance issues (if any) of using MySQL with Python. By performance, I wanted to know how will the speed be, what is the memory overhead involved, etc during database specific operations (retrieval, update, insert, etc) when MySQL is used with Python.
0
1432
by: eli | last post by:
Hi, Can anyone explain me how to create relationships between tables in Mysql? For making some kind of functions like joins, it is indispensable to have relationships defined? Thanks in advanced.
6
3552
by: jacob nikom | last post by:
I would like to create data model for a group of stores. All stores in this group are very similar to each other, so it is natural to allocate one MySQL database per store. Each database is going to have very similar set of tables with content related to a particular store. Let's suppose each store has multiple departments which are also very similar to each other. In this case I would like to model the departments
2
1368
by: Obi Wan Shinobi | last post by:
Hello to you all, I am a total newbie to MySQL other than entering data. What I would like to know is whether it is possible to create relational databases via MySQL. I would assume so considering its popularity. If possible, where would I begin? Can someone point me in the direction of some beginner tutorials? I can create non-related table structures but would like to define relationships. Many thanks in advance.
0
1480
by: Chris | last post by:
Hi, I am currently designing a simple service orders database. I have played around with MySQL a bit but this is the first time I'm using it in anger, I have a few design queries to make sure I am implementing the database correctly. Currently I have a number of tables, the first being the package table (lists the different service names - such as small, medium etc). Note in the tables I have trimmed a lot of the unnecessary stuff to...
0
1301
by: Missaka Wijekoon | last post by:
Folks, I have 3 mysql replicated servers ( 1 master + 2 slaves). One thing I noticed is that every once in a while the data (*.MYD) and index (*.MYI) files for a table may differ from the other mysql servers. Now my question is this: If I have identical data files on each server (verified by using checksums), should the indexes generated be identical on each mysql server? If not, is there something wrong? Is it possible for mysql...
3
1977
by: Gregory.Spencer | last post by:
Hello there, I'm looking for a tool that does for MySQL Db's what Access does for Jet DB's. Therefore provides a nice gui to speedup certain tasks and produce entitiy relationship diagrams. Is there a market leader in this field? Do people have recommendations? I'm actually looking into using Visio for creating my diagrams but it
1
1721
by: Smriti Dev | last post by:
Hi, I have a question regarding autonumbering . I'm using linked tables between msql and MS Access. Quite a few linked tables exist with relationships. The auto increment fields once linked loose thier autonumber property and come up as numbers. I have developed a form interface and when I press the next record the next number does not come as the autonumber property has been lost. Thier are quite a few relationships with linked...
1
2253
by: Smriti Dev | last post by:
Hi, I have a question regarding autonumbering . I'm using linked tables between msql and MS Access. Quite a few linked tables exist with relationships. The auto increment fields once linked loose thier autonumber property and come up as numbers. I have developed a form interface and when I press the next record the next number does not come as the autonumber property has been lost. Thier are quite a few relationships with linked...
0
8545
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8810
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8810
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7633
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6462
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4327
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2978
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2242
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1961
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.