473,378 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Relationship in Mysql

------=_NextPart_000_000D_01C36572.F6480CE0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_000E_01C36572.F6480CE0"
------=_NextPart_001_000E_01C36572.F6480CE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi

I can't help establish a relationship between two tables (table 1, =
table 2) in Mysql.
I work with DBTools, it has an relationship editor, but it doesn't =
work, since after i ' ve created the relationship for the field email, =
if i delete a register in table 1, the register with same data remains =
in table 2.
Is there any other tool i can use to edit relationship in Mysql? Or =
is there any other way to make it ?=20

Thank you
Alcyone Oliveira
(al**************@trtrio.gov.br)
------=_NextPart_001_000E_01C36572.F6480CE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; I can't help =
establish a=20
relationship between two tables (table 1, table 2)&nbsp;in =
Mysql.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; I work with DBTools, =
it has an=20
relationship editor, but it doesn't work, since after i ' ve created the =

relationship for the field email, if i delete a register in table 1, the =

register with same data remains in table 2.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; Is there any other =
tool i can=20
use to edit relationship in Mysql? Or is there any other way to make it =
?=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV align=3Dcenter><FONT face=3DArial size=3D2>Thank you</FONT></DIV>
<DIV align=3Dcenter><FONT face=3DArial size=3D2>Alcyone =
Oliveira</FONT></DIV>
<DIV align=3Dcenter><FONT face=3DArial size=3D2>(<A=20
href=3D"mailto:al**************@trtrio.gov.br">al* *************@trtrio.go=
v.br</A>)</FONT></DIV>
<DIV align=3Dcenter><FONT face=3DArial =
size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_001_000E_01C36572.F6480CE0--
------=_NextPart_000_000D_01C36572.F6480CE0
Content-Type: text/plain; charset=us-ascii

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
------=_NextPart_000_000D_01C36572.F6480CE0--

Jul 19 '05 #1
0 1482

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Morten Gulbrandsen | last post by:
Hello MySQL programmers, suppose we have an Enhanced ER diagram, with entities as classes/ subclasses connected through some IS-A relationship. How can this be Coded in MySQL Please? My...
0
by: Alcyone Oliveira | last post by:
------=_NextPart_000_000D_01C36572.F6480CE0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_000E_01C36572.F6480CE0" ------=_NextPart_001_000E_01C36572.F6480CE0 Content-Type:...
0
by: Eric | last post by:
I use Mysql and SQLyog (trial version), I created 2 tables but I get this message when I try to create relationship between tables: "The selected table does not have InnoDB Table Handler. You...
1
by: Steve Malley | last post by:
Is MaxDB ultimately a "souped up" MySQL? Does anyone know what the plan is? i.e., Is the company going to converge these? Continue to market separate products? Also, how divergent is the code...
5
by: Marek Kotowski | last post by:
I mean: which RDBMS 1) allows to declare that relationship is in fact 1-1, and 2) protests when one tries to violate the 1-1 relationship, that is inserts into a table two records with the same...
2
by: Ken Loh | last post by:
Hi All, I'd like to develop something which has a concept like the folders-and-files in your PC. A folder can have subfolders and/or files. The subfolders themselves have the same...
5
by: BrianDP | last post by:
This is a strange one-- I have an Access 2K database with a split front end/back end. There are two tables in the back end - RFile and RLine. There is a one to many relationship from...
1
by: divjoy | last post by:
Hi, This is my first post and I am looking forward to contributing, just loaded MySql 5.0 on windows XP and looks great, what a bargain a fully features industrials trength database with security...
5
by: odntuk | last post by:
Hello, I'm new to database development and need your help. Although, I'm new I know that storing multiple entries into a database field is a horrible idea. Therefore, I'm trying to implement...
10
by: Richard | last post by:
Hi folks, thanks for taking the time to read this (and hopefully point our where I'm going wrong). The scenario: I have a local Access2007 database which links in several read only mySql...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.