Re: problems with relationships created by mysql

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 rounak.m...@gmail.com wrote: I have connected MySql to Base. I created some relationships in MySql. They are properly visible in the Relationships chart

1 to many relationships

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 need

Re: 1 to many relationships

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 and

Re: 1 to many relationships

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 the a form Comes up

Re: 1 to many relationships

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 and

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

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

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

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

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

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 PRIMARY

Re: MySQL ignores foreign key relationships between tables?

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 InnoDB tables in MySQL. I am

Re: MySQL ignores foreign key relationships between tables?

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 tables and enforce

Re: MySQL ignores foreign key relationships between tables?

?- 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 MySQL. I am using InnoDB. I use MySQL

Re: MySQL ignores foreign key relationships between tables?

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 it disappointing that MySQL

Re: MySQL ignores foreign key relationships between tables?

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 that those relationships

MySQL ignores foreign key relationships between tables?

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.mysql.com/mysql To unsubscribe:http

Re: MySQL ignores foreign key relationships between tables?

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 end of your table definitions

Re: MySQL ignores foreign key relationships between tables?

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. Add ENGINE = InnoDB to the end

Re: MySQL ignores foreign key relationships between tables?

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 ignores this relationship. Add

Re: Child-Parent Relationships with 2 Parents

... 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 you said. Eventually one

Child-Parent Relationships with 2 Parents

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 SUBclass)

Re: Child-Parent Relationships with 2 Parents

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

RE: MYSQL + acquiring table relationships

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 often,

RE: MYSQL + acquiring table relationships

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 to

Re: MYSQL + acquiring table relationships

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 been able to acquire the said

RE: MYSQL + acquiring table relationships

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

MYSQL + acquiring table relationships

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

MYSQL + acquiring table relationships

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

newbie: relationships between fields

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. Imagine I had two tables

Re: newbie: relationships between fields

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 because I'm working

Re: newbie: relationships between fields

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 because I'm working

RE: newbie: relationships between fields

: 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 this point

Graphical program to describe table relationships

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

Re: Graphical program to describe table relationships

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've filled large

Re: RI enforcement and m2m relationships.

: bsrc.ac.uk Fax to: Subject: RI enforcement and m2m relationships. 06/02/2004 06:45

Re: RI enforcement and m2m relationships.

[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

RES: RI enforcement and m2m relationships.

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 responsible

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_,_score_id_,...) INSTALLATIONS(_id_,_score_id_,...) PERFORMANCES(_id_,???) The

RE: Relationships Question

, 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_

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 offer advice on how to construct a select statement to show which users aren't in the comp-user-link table? Sort of the

RE: Search for relationships that aren't present

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 offer

Re: Search for relationships that aren't present

: 05/25/2004 02:39 Fax to: PM Subject: Search for relationships that aren't present

Re: Search for relationships that aren't present

,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: Search for relationships that aren't present Three tables

Re: Search for relationships that aren't present

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

Re: Search for relationships that aren't present

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

Re: Search for relationships that aren't present

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:

Re: Search for relationships that aren't present

to: PM Subject: Re: Search for relationships that aren't present

Re: Search for relationships that aren't present

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

Re: Search for relationships that aren't present

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) users

Re: Modelling specialized M:N relationships?

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

Creating Relationships

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: Creating Relationships

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 to change that. I

Modelling specialized M:N relationships?

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.

Re: Modelling specialized M:N relationships?

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

Relationships

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

relationships

Hi, is there a way of showing relationships in mysql? such as. mysql SHOW relationships Bob

Re: relationships

* 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 tablename. -- Roger -- MySQL

RE: relationships

, 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.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Relationships - Foreign Key

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]

Re: Relationships - Foreign Key

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

Using joins to create code from E- ER relationships

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

Re: Relationships in Mysql

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 you insert a new record, make sure that any foreign key points to an existing record (a record

Re: FW: Relationships in Mysql

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: FW: Relationships in Mysql

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:20Write a Friend : I am a newbie

Re: FW: Relationships in Mysql

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 Nils Valentin

FW: Relationships in Mysql

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

Re: FW: Relationships in Mysql

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

Re: FW: Relationships in Mysql

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 foreign key columns

re: Need Help Setting Relationships

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 and MySQL 3.23.54

Re: Need Help Setting Relationships

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't

Re: Need Help Setting Relationships

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

Need Help Setting Relationships

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, categories

Re: updating many-to-many relationships?

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

updating many-to-many relationships?

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 SKU_TWO AGENT_ONE SKU_TWO AGENT_TWO SKU_TWO AGENT_THREE

Re: updating many-to-many relationships?

) 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 two days), I'll be getting a new text file with the relationships

Re: updating many-to-many relationships?

be getting a new text file with the relationships in a format that looks like: SKU_ONE AGENT_ONE SKU_ONE AGENT_TWO SKU_TWO AGENT_ONE SKU_TWO AGENT_TWO SKU_TWO AGENT_THREE SKU_THREE AGENT_BLUE SKU_THREE AGENT_ORANGE etc. The text is what gets shoved

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

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 logic

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

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 storyId relationships

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

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 relationships - in both directions. Their is no easy answer

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

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 what I want to do... I am building a CMS

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

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

Another Defining Relationships in MySQL Question

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... (think I have

Re: Another Defining Relationships in MySQL Question

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

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 greatly appreciated. Thanks in advance! - Before posting,

RE: MySQL Relationships

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 greatly

inserting values w/ relationships

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

Re: inserting values w/ relationships

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

Building relationships between tables

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

Re: Building relationships between tables

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/doc/A/N

Buliding relationships between tables - how?

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

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 in Access comprising over 1000

I thought MySQL Supported Relationships

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 I can find

RE: I thought MySQL Supported Relationships

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 from

RE: I thought MySQL Supported Relationships

* 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 does anyone know where I can

Re: I thought MySQL Supported Relationships

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 the subject. Does MySQL support

Re: I thought MySQL Supported Relationships

, with 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 support. 3

RE: I thought MySQL Supported Relationships

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 in Access

relationships between databases

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: relationships between databases

: 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 done with the DG: insert statement DG: DG

Tables relationships

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

Re: Tables relationships

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 me in the right direction to let me know how

Re: Relationships???

over simplifies the process and itself imposes data integrity questions. Pat... . - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 14, 2001 9:28 PM Subject: Re: Relationships??? If you are really after referential

  1   2   >