Re: problems with relationships created by mysql

2013-05-12 Thread rounak jain
oops..sorryproblem seems to be with base...so i meant to post it in base mailing list On Mon, May 13, 2013 at 9:37 AM, rounak jain wrote: > I have connected MySql to Base. I created some relationships in MySql. > They are properly visible in the Relationships chart in Base. See

Re: 1 to many relationships

2006-08-16 Thread Chris
Brian E Boothe wrote: hey guys ; it's not Customers Per issue it's the other way around "issues per customer" i enter in Customer 1 and then down the road i wanna add a issue associated with that customer, so goto that customer and Click "Add issue" the a form Comes up and i add the issue an

Re: 1 to many relationships

2006-08-16 Thread William R. Mussatto
Gerald L. Clark said: > Brian E Boothe wrote: >> hey guys ; >>it's not Customers Per issue it's the other way around "issues per >> customer" >> i enter in Customer 1 and then down the road i wanna add a issue >> associated with that customer, so goto that customer and Click "Add >> issue" >> t

Re: 1 to many relationships

2006-08-16 Thread Gerald L. Clark
Brian E Boothe wrote: hey guys ; it's not Customers Per issue it's the other way around "issues per customer" i enter in Customer 1 and then down the road i wanna add a issue associated with that customer, so goto that customer and Click "Add issue" the a form Comes up and i add the issue an

1 to many relationships

2006-08-16 Thread Brian E Boothe
hey guys ; it's not Customers Per issue it's the other way around "issues per customer" i enter in Customer 1 and then down the road i wanna add a issue associated with that customer, so goto that customer and Click "Add issue" the a form Comes up and i add the issue and Click Add issue, i ne

Re: General DB Design Question - How to avoid redundancy in table relationships

2006-02-14 Thread Bob Gailer
Scott Klarenbach wrote: These are the tables in question: RFQ (Request for Quote) Part Inventory Inventory items ALWAYS have a partID. RFQ items ALWAYS have a partID. However, sometimes, RFQ items have an inventoryID as well. Now, we have a redundancy problem. Because, in those instances w

Re: General DB Design Question - How to avoid redundancy in table relationships

2006-02-13 Thread Peter Brawley
Scott, >I'm sure this type of problem is run up against all the time, and I'm >wondering what the best practice methodology is from experienced DBA's. It looks like the kind of problem database schemas are meant to _avoid_. >From your description it seems you have ...   part (     partID PRIM

General DB Design Question - How to avoid redundancy in table relationships

2006-02-13 Thread Scott Klarenbach
These are the tables in question: RFQ (Request for Quote) Part Inventory Inventory items ALWAYS have a partID. RFQ items ALWAYS have a partID. However, sometimes, RFQ items have an inventoryID as well. Now, we have a redundancy problem. Because, in those instances when the RFQ has an invento

Re: MySQL ignores foreign key relationships between tables?

2006-01-31 Thread Ferindo Middleton Jr
7;t that the point of a relational database?- TO CHECK RELATIONSHIPS between tables and enforce that those relationships aren't broken? I find it disappointing that MySQL ignores this relationship. Add ENGINE = InnoDB to the end of your table definitions. Foreign keys are supported only for I

Re: MySQL ignores foreign key relationships between tables?

2006-01-30 Thread Paul DuBois
elational database?- TO CHECK RELATIONSHIPS between tables and enforce that those relationships aren't broken? I find it disappointing that MySQL ignores this relationship. Add ENGINE = InnoDB to the end of your table definitions. Foreign keys are supported only for InnoDB tables in MySQ

Re: MySQL ignores foreign key relationships between tables?

2006-01-30 Thread Ferindo Middleton Jr
#x27;ve tried this same syntax in PostgreSQL and it doesn't allow the schedules.id record to be deleted without first removing any records in the registration table which carry a matching schedule_id record. Isn't that the point of a relational database?- TO CHECK RELATIONSHIPS between

Re: MySQL ignores foreign key relationships between tables?

2006-01-29 Thread Paul DuBois
ame syntax in PostgreSQL and it doesn't allow the schedules.id record to be deleted without first removing any records in the registration table which carry a matching schedule_id record. Isn't that the point of a relational database?- TO CHECK RELATIONSHIPS between tables and enforce t

Re: MySQL ignores foreign key relationships between tables?

2006-01-29 Thread Ferindo Middleton Jr
chedules.id record to be deleted without first removing any records in the registration table which carry a matching schedule_id record. Isn't that the point of a relational database?- TO CHECK RELATIONSHIPS between tables and enforce that those relationships aren't broken? I find

Re: MySQL ignores foreign key relationships between tables?

2006-01-28 Thread Ferindo Middleton Jr
eted without first removing any records in the registration table which carry a matching schedule_id record. Isn't that the point of a relational database?- TO CHECK RELATIONSHIPS between tables and enforce that those relationships aren't broken? I find it disappointing that MySQL igno

Re: MySQL ignores foreign key relationships between tables?

2006-01-28 Thread Ferindo Middleton Jr
any records in the registration table which carry a matching schedule_id record. Isn't that the point of a relational database?- TO CHECK RELATIONSHIPS between tables and enforce that those relationships aren't broken? I find it disappointing that MySQL ignores this relationship. Ad

Re: MySQL ignores foreign key relationships between tables?

2006-01-28 Thread Paul DuBois
registration table which carry a matching schedule_id record. Isn't that the point of a relational database?- TO CHECK RELATIONSHIPS between tables and enforce that those relationships aren't broken? I find it disappointing that MySQL ignores this relationship. Add ENGINE = InnoDB to the e

MySQL ignores foreign key relationships between tables?

2006-01-28 Thread Ferindo Middleton Jr
record. Isn't that the point of a relational database?- TO CHECK RELATIONSHIPS between tables and enforce that those relationships aren't broken? I find it disappointing that MySQL ignores this relationship. Ferindo -- MySQL General Mailing List For list archives: http://lists.my

Re: Child-Parent Relationships with 2 Parents

2005-08-13 Thread douglass_davis
ute1 Attribute2 ... Now, the RelationshipTable can have zero to many relationships between a child and a parent. You can even add a "Label" column in there if you want to label the relationship type somehow. And it may be better to create separate tables for each taxonomic level, like

Re: Child-Parent Relationships with 2 Parents

2005-08-12 Thread David Blomstrom
I just thought of a possible solution. Instead of listing all the phyla, orders, classes, families, genera and species in one big table, create separate tables for each taxonomic level. Each taxon would then have two parents. the genus Sus' (pigs) parents would be both the subfamily Suinae and fam

Child-Parent Relationships with 2 Parents

2005-08-12 Thread David Blomstrom
Suppose I want to create an animal kingdom database that gives me the option of displaying the following taxonomic hierarchies: 1) A bread crumbs navigation string, including ALL taxons; e.g. Animalia (kingdom) > Chordata (phylum) > Vertebrata (a SUBphylum) > Mammalia (class) > Eutheria (a SUBclas

RE: MYSQL + acquiring table relationships

2005-01-20 Thread SGreen
"Paul Wallace" <[EMAIL PROTECTED]> wrote on 01/19/2005 06:50:48 PM: > Was there a reply to this post? If so, I could have (did) missed it. Can > you please resend? > > Rgds > > Paul. > Sorry, but I never said (woops!) Which language I use depends on where I want to run the script and how

RE: MYSQL + acquiring table relationships

2005-01-19 Thread Paul Wallace
Was there a reply to this post? If so, I could have (did) missed it. Can you please resend? Rgds Paul. Shawn, what language(s) are you using to parse this? Could you share the code? Thanks, Dave Merrill > I prefer to parse the results of a "SHOW CREATE TABLE..." query. It's > rather trivial

RE: MYSQL + acquiring table relationships

2005-01-17 Thread Dave Merrill
Shawn, what language(s) are you using to parse this? Could you share the code? Thanks, Dave Merrill > I prefer to parse the results of a "SHOW CREATE TABLE..." query. It's > rather trivial to detect which rows in the result of that statement are > your FOREIGN KEYS. They not only indicate which

Re: MYSQL + acquiring table relationships

2005-01-17 Thread SGreen
"Paul Wallace" <[EMAIL PROTECTED]> wrote on 01/17/2005 12:04:13 AM: > Hi, > How can I, if at all, acquire table relationships - in particular > one-to-may/many-to-one relationships? I have looked into the > DatabaseMetaData object (Java) , but have not as yet bee

MYSQL + acquiring table relationships

2005-01-16 Thread Paul Wallace
Hi, How can I, if at all, acquire table relationships - in particular one-to-may/many-to-one relationships? I have looked into the DatabaseMetaData object (Java) , but have not as yet been able to acquire the said relationship data. I post to this list as the ability to pull such such

MYSQL + acquiring table relationships

2005-01-16 Thread Paul Wallace
Hi, How can I, if at all, acquire table relationships - in particular one-to-may/many-to-one relationships? I have looked into the DatabaseMetaData object (Java) , but have not as yet been able to acquire the said relationship data. I post to this list as the ability to pull such such

RE: newbie: relationships between fields

2004-11-16 Thread gunmuse
: newbie: relationships between fields -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | Dear list, | | I'm hoping to move to MySQL from Access, mostly so I can use my Mac to build databases. So far I've been able to set up MySQL, connect to it, and create databases and tables. Getting to

Re: newbie: relationships between fields

2004-11-16 Thread Amer Neely
m shift or two on my part (my first question after it was installed was, okay, how the hell do I open up the app and start work?). | | Now I'd like to create some relationships between the tables in my database. But I'm having some trouble getting my head around how to do this - probably

Re: newbie: relationships between fields

2004-11-16 Thread Richard Whitney
point has required a > paradigm shift or two on my part (my first question after it was > installed was, okay, how the hell do I open up the app and start > work?). > > Now I'd like to create some relationships between the tables in my > database. But I'm having some trouble

newbie: relationships between fields

2004-11-16 Thread Christian Kavanagh
ter it was installed was, okay, how the hell do I open up the app and start work?). Now I'd like to create some relationships between the tables in my database. But I'm having some trouble getting my head around how to do this - probably because I'm working with an Access paradigm.

Re: Graphical program to describe table relationships

2004-09-30 Thread Piotr Duszynski
Hi Joshua, > Hi All, > This is more of a general SQL database question than a MySQL question, but > since I use MySQL almost exclusively I thought I would ask here. > Up until now, when designing a database, I always plotted out the > relationships on paper, with pen/pencil. I&

Graphical program to describe table relationships

2004-09-30 Thread Joshua Beall
Hi All, This is more of a general SQL database question than a MySQL question, but since I use MySQL almost exclusively I thought I would ask here. Up until now, when designing a database, I always plotted out the relationships on paper, with pen/pencil. I've filled large pieces of paper

RES: RI enforcement and m2m relationships.

2004-06-02 Thread Renato Cramer
Para: eifion herbert (IAH-C) Cc: [EMAIL PROTECTED] Assunto: RI enforcement and m2m relationships. Hi all, I'm developing a database to store job adverts to appear on a company website. Each vacancy has at least one supervisor, but may have more than one, and a supervisor may be responsibl

Re: RI enforcement and m2m relationships.

2004-06-02 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: I don't see how you can possibly hope to satisfy two mutually dependent constraints at the exact same time. It's a chicken-and-egg scenario. If you can't create your vacancy record first (to get its PK value) you won't be able to create the new record in your supervision ta

Re: RI enforcement and m2m relationships.

2004-06-02 Thread SGreen
<[EMAIL PROTECTED]cc: bsrc.ac.uk> Fax to: Subject: RI enforcement and m2m relationships.

RI enforcement and m2m relationships.

2004-06-02 Thread eifion herbert (IAH-C)
Hi all, I'm developing a database to store job adverts to appear on a company website. Each vacancy has at least one supervisor, but may have more than one, and a supervisor may be responsible for multiple vacancies. I've resolved the vacancy<-->supervisor many-to-many relationship in the normal

Re: Search for relationships that aren't present

2004-05-25 Thread olinux
a LEFT JOIN should do the trick something like this: SELECT users.user_id FROM users LEFT JOIN comps_users_link ON (users.user_id=comps_users_link.user_id) WHERE comps_users_link.computer_id IS NULL olinux --- Brad Tilley wrote: > Three tables: > > computers (Describes computers) > use

Re: Search for relationships that aren't present

2004-05-25 Thread Michael Stassen
Brad Tilley wrote: I should better describe the tables: computers has 'comp_id' as its primary, unique key. users has 'user_id' as its primary, unique key. comp-user-link has two (and only two fields) that are *never* null: 'comp_id' (which must be unique), and 'user_id' Every computer is linked t

Re: Search for relationships that aren't present

2004-05-25 Thread SGreen
05/25/2004 02:58 Fax to: PM

Re: Search for relationships that aren't present

2004-05-25 Thread Brad Tilley
Ah yes, thank you Gerald. I didn't understand this until now. I guess I should say that 'by design' the linking table will never contain a null, but the left join changes that. Thank you for pointing that out. gerald_clark wrote: Brad Tilley wrote: I should better describe the tables: computers

Re: Search for relationships that aren't present

2004-05-25 Thread Brad Tilley
Victor & Shawn, Thanks for the select info and the relationship info. Both of your examples worked. The reason we designed a separate linking table is that we wanted to always keep the computers separate from the users. A container of users and a container of computers with a linking table join

Re: Search for relationships that aren't present

2004-05-25 Thread gerald_clark
Brad Tilley wrote: I should better describe the tables: computers has 'comp_id' as its primary, unique key. users has 'user_id' as its primary, unique key. comp-user-link has two (and only two fields) that are *never* null: Except within the context of a left join. Every user in a left join mat

Re: Search for relationships that aren't present

2004-05-25 Thread Brad Tilley
sub-selects you could perform a subquery. Otherwise,the solution depends on your primary keys. SELECT u.* FROM users u LEFT OUTER JOIN comp-user-link c ON u.userID = c.userID WHERE c.userID IS NULL -Original Message- From: Brad Tilley To: [EMAIL PROTECTED] Sent: 5/25/04 1:39 PM Subject: Se

Re: Search for relationships that aren't present

2004-05-25 Thread SGreen
cc: 05/25/2004 02:39 Fax to: PM

RE: Search for relationships that aren't present

2004-05-25 Thread Victor Pendleton
PROTECTED] Sent: 5/25/04 1:39 PM Subject: Search for relationships that aren't present Three tables: computers (Describes computers) users (Describes users) comp-user-link (Links users to computers in a 1 user to many computers relationship) Could someone

Search for relationships that aren't present

2004-05-25 Thread Brad Tilley
Three tables: computers (Describes computers) users (Describes users) comp-user-link (Links users to computers in a 1 user to many computers relationship) Could someone offer advice on how to construct a select statement to show which users aren't in the comp-user-link table? Sort of the reve

RE: Relationships Question

2004-05-25 Thread Laercio Xisto Braga Cavalcanti
, 25 de maio de 2004 09:58 To: [EMAIL PROTECTED] Subject: Relationships Question Dear List, I am working on a database of electronic compositions (and installations etc.) and currently have, amongst others, the following tables: ARTIST(_id_,...) SCORE(_id_,_artist_id_,...) COMPOSITIONS(_id_

Relationships Question

2004-05-25 Thread Richard Lewis
Dear List, I am working on a database of electronic compositions (and installations etc.) and currently have, amongst others, the following tables: ARTIST(_id_,...) SCORE(_id_,_artist_id_,...) COMPOSITIONS(_id_,_score_id_,...) INSTALLATIONS(_id_,_score_id_,...) PERFORMANCES(_id_,???) The PERFOR

RE: Creating Relationships

2004-04-21 Thread Dathan Vance Pattishall
Use INNODB and use FK constraints / cascades. > -Original Message- > From: LastingImages [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 6:33 PM > To: [EMAIL PROTECTED] > Subject: Creating Relationships > > OK I am a umber newbie. And I have decided

Creating Relationships

2004-04-21 Thread LastingImages
OK I am a umber newbie. And I have decided to change that. I was wondering how do you create relationships between tables? If you know where it talks about it in the MySQL reference manual you can direct me there. But I have not been able to find it. So this is my first question. Thank you! Bryan

Re: Modelling specialized M:N relationships?

2004-04-21 Thread Leandro Melo
I'm actually i deep doubts with this. Price is not a thing itself, good point. But in my case, it was the best way i found out to model. Suppose you got a company the rents a place (just a big room, or a party house) for any kinda envents you'd to make. The company is clear an entity, and the pric

Re: Modelling specialized M:N relationships?

2004-04-20 Thread Robert J Taylor
Leandro Melo wrote: Hi, i have a M:N relationship between PRODUCT and PRICE. Is Price an Entity or an Attribute? I'm not accustomed to using price as a Thing. What is it that causes a Product to have one, exactly, or more prices? Is it its relationship to some other thing? Or is it a special

Modelling specialized M:N relationships?

2004-04-20 Thread Leandro Melo
Hi, i have a M:N relationship between PRODUCT and PRICE. 1 product may be associated to N prices and 1 prices may belong to N products. I got special cases the some kinda product MUST have only 1 price associated with it. I don't what would be the best way to model this "flag" for the special case.

Relationships

2003-12-05 Thread Matthew Stuart
How do I create relationships between tables? I have tried but have no way of being sure that I am successful just by looking at the db. I am not sure how to relate one record in one table to it corresponding record in another. Mat -- MySQL General Mailing List For list archives: http

RE: relationships

2003-11-06 Thread Dathan Vance Pattishall
->Sent: Thursday, November 06, 2003 11:18 AM -->To: mysqllist -->Subject: relationships --> -->Hi, is there a way of showing relationships in mysql? --> -->such as. mysql> SHOW relationships --> -->Bob -- MySQL General Mailing List For list archives: http://lists.mys

Re: relationships

2003-11-06 Thread Roger Baklund
* Robert Morgan > Hi, is there a way of showing relationships in mysql? > > such as. mysql> SHOW relationships No. The relationships are dynamic, defined by join statements on the fly. You can however show any defined foreign key constraints using "SHOW CREATE TABLE tabl

relationships

2003-11-06 Thread Robert Morgan
Hi, is there a way of showing relationships in mysql? such as. mysql> SHOW relationships Bob

Re: Relationships - Foreign Key

2003-10-03 Thread Roger Baklund
* Paulo > Hi, sorry for my english, but, how can I do relationships between > tables? Is possible? This is done using different types of JOIN: http://www.mysql.com/doc/en/JOIN.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Relationships - Foreign Key

2003-10-03 Thread Paulo
Hi, sorry for my english, but, how can I do relationships between tables? Is possible? Thanks, Paulo Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Using joins to create code from E- ER relationships

2003-08-22 Thread Morten Gulbrandsen
Hello, starting from some software database spesification, defined in some Enhanced entity relationship diagram, resulting in all kinds of relationships, 1:1 1:Many Many:1 Many : many And last but not least: Subclass/superclass relationship This seems to be a small problem for me, With the

Re: FW: Relationships in Mysql

2003-07-25 Thread Write a Friend
Nils, Thanks. I will code accordingly. Carlos > > Hi Carlos, > > I believe that would have to be 2 separated steps. > > 1) creating the value in the primary key and > 2) creating the foreign key value > > However you can use UNION to write both statements in one go. > > Best regards > > Ni

Re: FW: Relationships in Mysql

2003-07-25 Thread Nils Valentin
Hi Carlos, I believe that would have to be 2 separated steps. 1) creating the value in the primary key and 2) creating the foreign key value However you can use UNION to write both statements in one go. Best regards Nils Valentin Tokyo/Japan 2003年 7月 26日 土曜日 05:20、Write a Friend さんは書きました: >

Re: FW: Relationships in Mysql

2003-07-25 Thread Write a Friend
I am a newbie to db. I have a few tables, one that I define the primary key. CREATE TABLE member ( memid INT(6) UNSIGNED ZEROFILL DEFAULT '002000' NOT NULL AUTO_INCREMENT, last VARCHAR(20) DEFAULT '' NOT NULL, first VARCHAR(20) DEFAULT '

Re: Relationships in Mysql

2003-07-25 Thread eli
as you point out, you > *have* to use them to establish relationships among your > tables. > > If the database system doesn't recognize the foreign key > columns as foreign keys, then you must programatically > ensure that referential integrity is maintained: > --when

Re: FW: Relationships in Mysql

2003-07-24 Thread John Hicks
imary key. You can use foreign keys in your database design and programming without actually formally declaring them as such in the database system. Indeed, as you point out, you *have* to use them to establish relationships among your tables. If the database system doesn't recognize the

Re: FW: Relationships in Mysql

2003-07-24 Thread Nils Valentin
Hi Eli, The short answer is .. you create relationships between tables by creating foreign keys and primary keys. However, you might not even need them ;-) - I explain below. Foreign keys and primary keys are used to create relations between tables. Using them will bind you to some rules

FW: Relationships in Mysql

2003-07-24 Thread eli
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. eli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Need Help Setting Relationships

2003-03-07 Thread Chris Montgomery
Disregard my previous msg. It looks like I have it figured out. Friday, March 7, 2003, 5:31:38 PM, Chris Montgomery wrote: > I've looked at the examples, but one thing it doesn't mention is whether > both indexes need to be unique. In the primary table they are, but does > the index in the table

Re: Need Help Setting Relationships

2003-03-07 Thread Chris Montgomery
Howdy Egor, Friday, March 7, 2003, 7:36:00 AM, Egor Egorov wrote: > Both columns Node are indexed, so just add foreign key constraint. You can > find examples in the InnoDB manual: > http://www.innodb.com/ibman.html#InnoDB_foreign_keys I've looked at the examples, but one thing it doesn'

re: Need Help Setting Relationships

2003-03-07 Thread Egor Egorov
On Friday 07 March 2003 00:43, Chris Montgomery wrote: > I have been using MS Access for 5+ years and am new to MySQL. I > understand the theory behind setting relationships between tables, but > am trying to get up to speed in how to do it in MySQL. > > My environment: Win2k an

Need Help Setting Relationships

2003-03-06 Thread Chris Montgomery
Howdy, I have been using MS Access for 5+ years and am new to MySQL. I understand the theory behind setting relationships between tables, but am trying to get up to speed in how to do it in MySQL. My environment: Win2k and MySQL 3.23.54 Here's what I want to do: I have two tables, categ

Re: updating many-to-many relationships?

2003-02-20 Thread gerald_clark
I don't have a mailing list, and I don't appreciate your email. You subscribed to the mysql mailing list, or you would not be getting it. The instructions to unsubscribe are at the bottom of every message. Kip McGee wrote: will you please take me off of your mailing list if you dont im gonna se

Re: updating many-to-many relationships?

2003-02-19 Thread Paul Chvostek
t; > >CREATE TABLE skuagent ( > > sku int(10) unsigned NOT NULL, > > agent mediumint(5) unsigned NOT NULL, > > UNIQUE KEY skuagent (sku,agent), > > KEY agentsku (agent,sku), > >); > > > >That's fine as far as it goes, but I can't figur

Re: updating many-to-many relationships?

2003-02-19 Thread gerald_clark
skuagent ( sku int(10) unsigned NOT NULL, agent mediumint(5) unsigned NOT NULL, UNIQUE KEY skuagent (sku,agent), KEY agentsku (agent,sku), ); That's fine as far as it goes, but I can't figure out how to repopulate the tables when new data comes in. On a regular basis (probably once every

updating many-to-many relationships?

2003-02-19 Thread Paul Chvostek
ar as it goes, but I can't figure out how to repopulate the tables when new data comes in. On a regular basis (probably once every two days), I'll be getting a new text file with the relationships in a format that looks like: SKU_ONE AGENT_ONE SKU_ONE AGENT_TWO

Re: Whats the best way to manage 'generic two-way relationships'?

2003-01-17 Thread Gelu Gogancea
Hi, - Original Message - From: "Hoffman, Geoffrey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 7:01 PM Subject: Whats the best way to manage 'generic two-way relationships'? > I couldn't think of a better term for

Re[2]: Whats the best way to manage 'generic two-way relationships'?

2003-01-17 Thread Brian Lindner
ry 17, 2003, 12:01:20 PM, you wrote: >> I couldn't think of a better term for what I want to do... >> I am building a CMS for news stories. Often news stories are related to each >> other, or need to be grouped by content. I need a simple way to manage >> storyId relati

Re: Whats the best way to manage 'generic two-way relationships'?

2003-01-17 Thread Brian Lindner
Geoffrey, Friday, January 17, 2003, 12:01:20 PM, you wrote: > I couldn't think of a better term for what I want to do... > I am building a CMS for news stories. Often news stories are related to each > other, or need to be grouped by content. I need a simple way to manage > stor

Whats the best way to manage 'generic two-way relationships'?

2003-01-17 Thread Hoffman, Geoffrey
I couldn't think of a better term for what I want to do... I am building a CMS for news stories. Often news stories are related to each other, or need to be grouped by content. I need a simple way to manage storyId relationships - in both directions. Thinking about the business log

Where should I start looking? Relationships? Joins? Temp Tables?

2002-11-15 Thread Chris Couture
Hello, I am trying to create a shopping cart for my company and have hit a snag. I have created a database in MySQL that has several tables. How would I go about displaying the fields from one table based on the fields in the other? Let me explain. I have a table called forder_details which

Re: Another Defining Relationships in MySQL Question

2002-11-08 Thread Michael T. Babcock
tmb wrote: In MS Access you define relationships between Key ID fields by dragging a line on the screen from the parent table to the child table. Read up on referential integrity and InnoDB tables in the online docs at http://www.mysql.com/doc/en -- Michael T. Babcock C.T.O., FibreSpeed

Another Defining Relationships in MySQL Question

2002-11-08 Thread tmb
In MS Access you define relationships between Key ID fields by dragging a line on the screen from the parent table to the child table. So, if you are enforcing "referential integrity" you can not delete data that is referred to by another table or mess up the basic db structure... (th

RE: MySQL Relationships

2002-07-12 Thread anjani.sinha
toniel Cantu` [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 11:06 AM To: [EMAIL PROTECTED] Subject: MySQL Relationships Hi, I am new to MySQL and was needing to know about MySQL and relationship between tables. Can it be done and if so how? Any docs or show me how would be g

MySQL Relationships

2002-07-12 Thread Otoniel Cantu`
Hi, I am new to MySQL and was needing to know about MySQL and relationship between tables. Can it be done and if so how? Any docs or show me how would be greatly appreciated. Thanks in advance! - Before posting, p

Re: inserting values w/ relationships

2002-06-07 Thread Dan Nelson
In the last episode (Jun 07), Jule Slootbeek said: > Hey gang, > I have two tables: > > user > ++--+--+-+-+---+ > | Field | Type | Null | Key | Default | Extra | > ++--+--+-+

inserting values w/ relationships

2002-06-07 Thread Jule Slootbeek
Hey gang, I have two tables: user ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | user_id| int(10) unsigned |

Re: Building relationships between tables

2002-05-01 Thread Victoria Reznichenko
Denis, Wednesday, May 01, 2002, 1:09:07 PM, you wrote: DLM> In Access, we build relationships between tables and keys, How do we do this DLM> between keys in mysql? What about foreign keys? Look at the manual, you can find some info about foreign keys in MySQL: http://www.mysql.com

Building relationships between tables

2002-05-01 Thread Denis L. Menezes
Hello friends, In Access, we build relationships between tables and keys, How do we do this between keys in mysql? Thanks Denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Buliding relationships between tables - how?

2002-04-30 Thread Denis L. Menezes
Hello friends, Can someone tell me how I can build the relationships between tables in mysql? I have tried books and web manuals. Even a link will do. Thanks Denis - Before posting, please check: http://www.mysql.com

RE: I thought MySQL Supported Relationships

2002-04-24 Thread Alec Grynspan
om: Arthur Fuller [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, April 23, 2002 5:57 PM >To: Jonathan Hilgeman; [EMAIL PROTECTED] >Subject: Re: I thought MySQL Supported Relationships > > >Perhaps I fail to catch the humour in your response, or the flavour of this >newsgroup, but I find yo

RE: I thought MySQL Supported Relationships

2002-04-23 Thread Land, Christopher
Jonathan Hilgeman; [EMAIL PROTECTED] Subject: Re: I thought MySQL Supported Relationships Perhaps I fail to catch the humour in your response, or the flavour of this newsgroup, but I find your answer in no way helpful, and beyond that quite insulting to Access. 1. I have developed applications

Re: I thought MySQL Supported Relationships

2002-04-23 Thread Arthur Fuller
numerous complex relationships and C++ components that interfaced to instruments such as scales, scanners, etc. I am not the only one to push Access that far. 2. To answer Andrew's question, the answer is No. MySQL does not support defined relationships. The InnoDB extension provides this suppor

Re: I thought MySQL Supported Relationships

2002-04-23 Thread Jason Yates
On Tue, 2002-04-23 at 14:35, Andrew Kuebler wrote: > Hello Everyone. > > I'm still fairly a newbie to MySQL, but I could have sworn I read > somewhere that MySQL supported relationships just like Access. I've > searched the entire manual, and cannot find anything on

RE: I thought MySQL Supported Relationships

2002-04-23 Thread Roger Baklund
* Andrew Kuebler > I'm still fairly a newbie to MySQL, but I could have sworn I read > somewhere that MySQL supported relationships just like Access. I've > searched the entire manual, and cannot find anything on the subject. > Does MySQL support relationships, and if so do

RE: I thought MySQL Supported Relationships

2002-04-23 Thread Jonathan Hilgeman
Actually, no. The addiction to MySQL has caused many relationship break-ups. There's probably even a database with that information out there somewhere. Probably a MySQL database, too. Meanwhile Access supports relationships because it blows so hard that people can't wait to get away f

I thought MySQL Supported Relationships

2002-04-23 Thread Andrew Kuebler
Hello Everyone. I'm still fairly a newbie to MySQL, but I could have sworn I read somewhere that MySQL supported relationships just like Access. I've searched the entire manual, and cannot find anything on the subject. Does MySQL support relationships, and if so does anyone know where

Re: relationships between databases

2001-12-17 Thread sherzodR
<[EMAIL PROTECTED]> DG: Subject: relationships between databases DG: DG: DG: DG: This is my first post to the list DG: DG: What is the best way of making a relationship between tables in Mysql. DG: Do you set it up when you are creating the tables or is it don

relationships between databases

2001-12-17 Thread Defryn, Guy
This is my first post to the list What is the best way of making a relationship between tables in Mysql. Do you set it up when you are creating the tables or is it done with the insert statement I am a newbie to Mysql, BTW Guy -

Re: Tables relationships

2001-08-07 Thread Stefan Hinz
13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: "Chris Malloch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 07, 2001 10:54 AM Subject: Tables relationships > Hi folks, > > Can someone please point

Tables relationships

2001-08-07 Thread Chris Malloch
Hi folks, Can someone please point me in the right direction to let me know how to define a relationship between tables in MySQL eg one-to-many. I haven't come across it in the manual yet, but am sure it must be there somewhere. Many thanks in advance, Chris Malloch

  1   2   >