Re: mysqldump and Foreign Keys

On Wednesday 02 February 2005 14:11, Michael Satterwhite might have typed: > mysqldump backs all of the tables up in alphabetic order, including the > table create statements. The problem is that if foreign keys exist on > the tables, the reload will not work unless the backup fil

mysqldump and Foreign Keys

mysqldump backs all of the tables up in alphabetic order, including the table create statements. The problem is that if foreign keys exist on the tables, the reload will not work unless the backup file is hand edited to insure that tables depended upon are created first. Is there a way around

Re: Innodb foreign keys names

Martijn, - Alkuperäinen viesti - Lähettäjä: "Martijn Tonies" <[EMAIL PROTECTED]> Vastaanottaja: <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Wednesday, October 20, 2004 11:34 AM Aihe: Re: Innodb foreign keys names > Hello Heikki, > ... &

Re: Innodb foreign keys names

Thanks Heikki for your response : it works perfectly with the brand new version (4.1.6), I'm gonna drop all my old foreign keys now and rename them with an appropriate name... bye -- Richard FURIC CEDRICOM Tel : 02 99 55 07 55 Fax : 02 99 55 08 64 E-mail : [EMAIL PROTECTED] site vi

Re: Innodb foreign keys names

Hello Heikki, > >> >> you have to use a fairly recent 4.0 or 4.1 version of MySQL. > >> > > >> >Does a newer version allow you to change/set the names yourself? > >> > >> you can give the name yourself in new versions. Please look at the InnoDB > >> manual section. > > > > "A constraint name can

Re: Innodb foreign keys names

Martijn, - Original Message - From: ""Martijn Tonies"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, October 20, 2004 10:08 AM Subject: Re: Innodb foreign keys names Hello Heikki, > >> you have to use a fairly recent 4.0 or 4.

Re: Innodb foreign keys names

Hello Heikki, > > > >> you have to use a fairly recent 4.0 or 4.1 version of MySQL. > > > >Does a newer version allow you to change/set the names yourself? > > you can give the name yourself in new versions. Please look at the InnoDB > manual section. "A constraint name can be given as of MySQL 4.

Re: Innodb foreign keys names

Martijn, List: mysql Subject:Re: Innodb foreign keys names From: "Martijn Tonies" Date: 2004-10-19 9:53:28 Message-ID: <01ad01c4b5c1$7c1e69a0$0a02a8c0 () martijn> [Download message RAW] >Heikki, > >> you have to use a fairly recent 4.0 or 4.1

Re: Innodb foreign keys names

ene.com > Hi everybody, > > Still have a problem with naming "foreign key" constraints on innodb tables. > Can't retrieve any of the name that was given to the constraints. > > "Internally generated" IDs are always given to the foreign keys... no way to &

Re: Innodb foreign keys names

Richard, you have to use a fairly recent 4.0 or 4.1 version of MySQL. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL

Re: Creating primary and foreign keys for MySQL

You haven't found the online manual yet, have you? http://dev.mysql.com/doc/mysql/en/index.html Specifically the documentation for the command you are curious about is found here: http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html Shawn Green Database Administrator Unimin Corporation - Spruce

Creating primary and foreign keys for MySQL

Hi All I am MySQL newby with an Oracle background. Is the following syntax suported? alter table members add primary key (id); alter table members add constraint members_uk unique (name); Thanx Herman __ Do you Yahoo!? Yahoo! Mail Address AutoC

Re: AW: InnoDB and foreign keys

overhead and row level locking for simple selects. But, it should not be 'very very slow' if MyISAM is 'very very fast' as it sounds like you are saying. John On Wed, 2004-10-13 at 18:29 +0200, Ulrich Seppi wrote: > HELLO > > >> does anybody know if Foreign keys

Re: AW: InnoDB and foreign keys

nimin Corporation - Spruce Pine "Ulrich Seppi" <[EMAIL PROTECTED]> wrote on 10/13/2004 12:29:22 PM: > HELLO > > >> does anybody know if Foreign keys increase the performance of select > querys? > >> example. > >> DB1 has only INNODB tables. > >>

AW: InnoDB and foreign keys

HELLO >> does anybody know if Foreign keys increase the performance of select querys? >> example. >> DB1 has only INNODB tables. >> DB2 has the same structure as DB1 with all possible foreign keys. >> > is the same query faster on DB1 or DB2? > >Why should

Re: InnoDB and foreign keys

On Wednesday 13 October 2004 10:33 am, Ulrich Seppi wrote: > Hello people, > does anybody know if Foreign keys increase the performance of select > querys? example. > DB1 has only INNODB tables. > DB2 has the same structure as DB1 with all possible foreign keys. Huh? You might wa

Re: InnoDB and foreign keys

> does anybody know if Foreign keys increase the performance of select querys? > example. > DB1 has only INNODB tables. > DB2 has the same structure as DB1 with all possible foreign keys. > > is the same query faster on DB1 or DB2? Why should it increase performance? With

Re: InnoDB and foreign keys

I am not certain that Foreign Keys (FKs) are even considered when evaluating a SELECT statement. I know that the indexes that the FKs point to in either table play a major role in determining the execution plan but I don't think that the FKs actually participate in SELECT queries. Now,

InnoDB and foreign keys

Hello people, does anybody know if Foreign keys increase the performance of select querys? example. DB1 has only INNODB tables. DB2 has the same structure as DB1 with all possible foreign keys. is the same query faster on DB1 or DB2? regards Uli -- MySQL General Mailing List For list archives

Innodb foreign keys names

Hi everybody, Still have a problem with naming "foreign key" constraints on innodb tables. Can't retrieve any of the name that was given to the constraints. "Internally generated" IDs are always given to the foreign keys... no way to apply a "drop foreign key 0_x

Re: SHOW foreign keys

> and how is a foreign key displayed? as KEY or FOREIGN KEY??? No, not at all - it's shown in the CREATE TABLE statement - have a try at it yourself. You need to parse the info from the text. You can also not create a FK by name, InnoDB will assign a name to it. Changing an attribute on your con

Re: SHOW foreign keys

and how is a foreign key displayed? as KEY or FOREIGN KEY??? Martijn Tonies schrieb am 17.08.2004 12:24: Hi, how can i get all the foreign keys from a database? i used SHOW INNODB STATUS; but i get an unknown error! You can only get them on a per-table basis with a SHOW CREATE TABLE

Re: SHOW foreign keys

Hi, > how can i get all the foreign keys from a database? i used SHOW INNODB > STATUS; but i get an unknown error! You can only get them on a per-table basis with a SHOW CREATE TABLE statement. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird,

SHOW foreign keys

hi! how can i get all the foreign keys from a database? i used SHOW INNODB STATUS; but i get an unknown error! thanks! -- G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N. http://www

Re: Where are the Foreign Keys?

>From: "Naresh Sadhnani" > >You could also try > >SHOW KEYS FROM . > >Should work. According to the documentation, this is an alternative for SHOW INDEX FROM A quick try gave me no results for FKs, only PKs and indices. With regards, Martijn Tonies Database Workbench - developer tool for Inte

RE: Where are the Foreign Keys?

You could also try SHOW KEYS FROM . Should work. Naresh -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: 06 August 2004 14:06 To: [EMAIL PROTECTED] Subject: Re: Where are the Foreign Keys? Hi Ralf, > as far as i know, there is only 1 way to extract

Re: Where are the Foreign Keys?

Hi Ralf, > as far as i know, there is only 1 way to extract the foreign key relations from a table: "show create table ". > Are there any others? The "comments" column in SHOW TABLE STATUS is supposed to list the FKs as well. A rather silly way of doing things, IMO, cause you can't use the "comm

Where are the Foreign Keys?

Hi, as far as i know, there is only 1 way to extract the foreign key relations from a table: "show create table ". Are there any others? regards ralf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple Foreign Keys

HAR(100), INDEX p1_p2_id_ind (p1_id, p2_id), FOREIGN KEY (p1_id, p2_id) REFERENCES child(p1_id, p2_id) ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY (p1_id, p2_id) ); Note that foreign keys can contain multiple columns (as shown above) if the parent table has a multi-column (comp

Re: Multiple Foreign Keys

The answer is "yes" to all of your questions. Just as an example, I have a table in one of my databases that is a "child" to nine other tables and is the "parent" to two. Just remember that any child table columns participating in a FK relationship must also be indexed (or the first column list

Multiple Foreign Keys

Can a child table have multiple foreign key references linking its records to two or more parent tables? Can a parent table also be a child table? That is, can a parent table have a foreign key that links it to another table? I setting up my tables as INNODB types. Thanks, Roy Harrell --

Re: Foreign keys

Hi, > I have a table that with a TEXT filed as a primary key. > > I can't make a foreign key of this field on another table, why does this happens? > > Ex: > > Product --- > | ref - text, PK > | name - text > | > > ProductsList > | ID int, PK > | profref - foreign key of the table product > |

Foreign keys

Hello there, I have a table that with a TEXT filed as a primary key. I can't make a foreign key of this field on another table, why does this happens? Ex: Product --- | ref - text, PK | name - text | ProductsList | ID int, PK | profref - foreign key of the table product | Th

Re: foreign keys......

Look for a substring beginning with 'FOREIGN KEY' in the result of 'SHOW CREATE TABLE tblname'. PB - Original Message - From: Tom Roos To: [EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:05 AM Subject: foreign keys.. hi how does 1 know if a fo

Re: foreign keys......

Tom Roos wrote: hi how does 1 know if a foreign key is defined? describe tablename and show index from tablename dont sufice tks SHOW CREATE TABLE tablename; or SHOW TABLE STATUS LIKE 'tablename'; Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

foreign keys......

hi how does 1 know if a foreign key is defined? describe tablename and show index from tablename dont sufice tks Disclaimer http://www.shoprite.co.za/disclaimer.html

RE: Reloading Database with Foreign Keys

At 18:01 -0400 on 06/01/2004, Bartis, Robert M (Bob) wrote about Re: Reloading Database with Foreign Keys: See http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html mysql> SET FOREIGN_KEY_CHECKS = 0; mysql> SOURCE dump_file_name; mysql> SET FOREIGN_KEY_CHECKS = 1; B

Reloading Database with Foreign Keys

I just tried to reload a mysqldump created dump to a new server and got rejected due to lack of referential integrity. I remember the existence of a command I can insert in the file that will turn off the checking of the Foreign Keys while the recreation is being done but I can not locate it

RE: Reloading Database with Foreign Keys

4 5:56 PM To: [EMAIL PROTECTED] Subject: Reloading Database with Foreign Keys I just tried to reload a mysqldump created dump to a new server and got rejected due to lack of referential integrity. I remember the existence of a command I can insert in the file that will turn off the checking of th

Reloading Database with Foreign Keys

I just tried to reload a mysqldump created dump to a new server and got rejected due to lack of referential integrity. I remember the existence of a command I can insert in the file that will turn off the checking of the Foreign Keys while the recreation is being done but I can not locate it

RE: strange behavior in foreign keys

There I found a link to a document saying that I must create INDEXes for FOREIGN KEYs to work properly. I tried the example in that document and it works. Thanks again. Any explanation why I never bumped into this before ? jmf __ O email

RE: strange behavior in foreign keys

ailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 11:42 AM To: [EMAIL PROTECTED] Subject: Re: strange behaviour in foreign keys [EMAIL PROTECTED] wrote: > > I've been running MySQL 4.0.x on a RH9 machine for some months and everything > was fine. I could create tables of type InnoDB

Re: strange behaviour in foreign keys

[EMAIL PROTECTED] wrote: > > I've been running MySQL 4.0.x on a RH9 machine for some months and everything > was fine. I could create tables of type InnoDB and define FOREIGN KEY's all > was well. > > A few days ago it does not let me create tables with foreig

strange behaviour in foreign keys

Hello, I've been running MySQL 4.0.x on a RH9 machine for some months and everything was fine. I could create tables of type InnoDB and define FOREIGN KEY's all was well. A few days ago it does not let me create tables with foreign keys anymore it says something like "u

Re: Copying Tables with Foreign Keys

in message news:[EMAIL PROTECTED] > Can you run into problems when copying tables with > foreign keys? I want to copy my Nations and States > tables, making versions designed only to hold lengthy > articles. I copied and coverted the States table > successfully, but I'm running in

Copying Tables with Foreign Keys

Can you run into problems when copying tables with foreign keys? I want to copy my Nations and States tables, making versions designed only to hold lengthy articles. I copied and coverted the States table successfully, but I'm running into problems with the Nations table. I get an error me

Re: innoDB, myISAM and Foreign Keys

"Paul West" <[EMAIL PROTECTED]> wrote: > Here are some easy questions I hope you can answer. > I have been creating innoDB tables in mysql, creating contraints and foreign keys > and it > runs swimmingly. > > The server I am now doing mySQL on won't allo

innoDB, myISAM and Foreign Keys

Hi Folks, Here are some easy questions I hope you can answer. I have been creating innoDB tables in mysql, creating contraints and foreign keys and it runs swimmingly. The server I am now doing mySQL on won't allow me to create other than myISAM tables. Is it true that only innoDB t

Re: Alter table primary key and foreign keys

can cause a crash when InnoDB tries to load the child table definition from its internal data dictionary. I recall seeing this problem in early 4.0.x versions. You should upgrade to 4.0.18. It may have better diagnostics for this problem. Best regards, Heikki Tuuri Innobase Oy Foreign keys

RE: Alter table primary key and foreign keys

Can you mysqldump the table then rebuild the table from the dump file? -Original Message- From: Rich Schramm To: 'Victor Pendleton'; [EMAIL PROTECTED] Sent: 5/18/04 2:04 PM Subject: RE: Alter table primary key and foreign keys The error log shows nothing when the binary dies

RE: Alter table primary key and foreign keys

ch Schramm '; '[EMAIL PROTECTED] ' Subject: RE: Alter table primary key and foreign keys I would first see if an upgrade to a later version of InnoDB tables is possible. What is being written to the error log? The ALTER TABLE statement subtly creates a new table, with new contraint name

RE: Alter table primary key and foreign keys

child table? -Original Message- From: Rich Schramm To: [EMAIL PROTECTED] Sent: 5/18/04 12:43 PM Subject: Alter table primary key and foreign keys I am using mysql 4.0.12 max-nt on Windows XP. I have a master table with an int column as a primary key (bom_id) and a second table that has a

Alter table primary key and foreign keys

I am using mysql 4.0.12 max-nt on Windows XP. I have a master table with an int column as a primary key (bom_id) and a second table that has a foreign key reference to the master column and uses it as part of a composite key (bom_id, fc_date). Example: ** bom_mstr p

Re: Enforcing integrity of Foreign Keys

"Zachary Agatstein" <[EMAIL PROTECTED]> wrote: > Well, in order to enforce referential integrity, I converted the tables to > InnoDB. But referential integrity is still not being enforced. I use > mysql version 3-23-54-nt, and the tables are generated through the use of > dbdesigner (ver. 4.0

Re: Enforcing integrity of Foreign Keys

Well, in order to enforce referential integrity, I converted the tables to InnoDB. But referential integrity is still not being enforced. I use mysql version 3-23-54-nt, and the tables are generated through the use of dbdesigner (ver. 4.0.5.6 beta). Here is a snippet of a "create" script: ==

Re: Enforcing integrity of Foreign Keys

"Zachary Agatstein" <[EMAIL PROTECTED]> wrote: > A very simple question: > > If I have a table A with PRIMARY KEY K, > and table B which has a column C defined as a FOREIGN KEY F referencing > table A.K, > > then, I would expect, C can only take a value from those already existing in > table A

Re: Enforcing integrity of Foreign Keys

Which kind of tables do you have? InnoDB tables enforce foreign key integrity, MyISAM tables do not. From the manual : | In MySQL 3.23.44 or later, InnoDB tables support checking of foreign key | constraints. ... For other storage engines, M

Enforcing integrity of Foreign Keys

A very simple question: If I have a table A with PRIMARY KEY K, and table B which has a column C defined as a FOREIGN KEY F referencing table A.K, then, I would expect, C can only take a value from those already existing in table A column K. So, let's assume, for simplicity's sake, table A has

Re: MyISAM vs InnoDB + Foreign Keys

On Thu, 13 May 2004 10:34:37 -0700 (PDT) David Blomstrom <[EMAIL PROTECTED]> wrote: > I thought that only InnoDB tables could be joined - > and only if they had foreign keys. But it sounds like > any kind of table can be joined, and it doesn't need a > foreign key. Exa

Re: MyISAM vs InnoDB + Foreign Keys

> I thought that only InnoDB tables could be joined - > and only if they had foreign keys. But it sounds like > any kind of table can be joined, and it doesn't need a > foreign key. The ability to join a bunch of tables in a query is different from foreign keys. A foreign key

MyISAM vs InnoDB + Foreign Keys

I thought that only InnoDB tables could be joined - and only if they had foreign keys. But it sounds like any kind of table can be joined, and it doesn't need a foreign key. Can someone explain InnoDB, MyISAM and foreign keys in plain English? If I understand correctly, foreign keys simply

Re: From the top! (primary/foreign keys)

One more thing, though... I don't understand this restrict and cascade function. I looked for it when I created my table, but didn't see any mention of it. If I understand MySQL's documentation, I don't need to worry about it, because it's created by default every time you create a foreign key. Is

Re: From the top! (primary/foreign keys)

BINGO! About the same time I got your message, I figured out how to create foreign keys with SQLyog. I followed your instructions in creating two brand new tables in phpMyAdmin, then linked the foreign key and primary key in SQLyog. I haven't tested it yet - there isn't even any d

Re: From the top! (primary/foreign keys)

named it to nations.) > > If the only solution is to make all my primary keys > non-repeating numerals, then I'll go that route. If > there are other problems, then I'd like to know if > anyone on this list knows how to designate foreign > keys with either MySQL-Front or S

From the top! (primary/foreign keys)

r. I put screenshots of my trials online at http://www.geoworld.org/fk.gif (The second table was then named nations2, but I've since renamed it to nations.) If the only solution is to make all my primary keys non-repeating numerals, then I'll go that route. If there are other problems, th

RE: problems with foreign keys revisited

PROTECTED] Sent: 5/7/04 2:17 AM Subject: problems with foreign keys revisited Hi there, I am having some issues between two tables and foreign keys. Here is the two tables I have setup. | complaints |CREATE TABLE `complaints` ( `complaintID` int(11) NOT NULL auto_increment, `ticket_number

problems with foreign keys revisited

Hi there, I am having some issues between two tables and foreign keys. Here is the two tables I have setup. | complaints |CREATE TABLE `complaints` ( `complaintID` int(11) NOT NULL auto_increment, `ticket_number` varchar(20) NOT NULL default '', `complainant_name` varchar(100

Re: foreign keys help

saiph <[EMAIL PROTECTED]> wrote: > > alea> mysql -V > mysql Ver 12.22 Distrib 4.0.17, for pc-linux-gnu (i386) > > but > > mysql < SHOW VARIABLES LIKE "have_innodb"; > +---+---+ > | Variable_name | Value | > +---+---+ > | have_innodb | NO| > +--

Re: foreign keys help

alea> mysql -V mysql Ver 12.22 Distrib 4.0.17, for pc-linux-gnu (i386) but mysql < SHOW VARIABLES LIKE "have_innodb"; +---+---+ | Variable_name | Value | +---+---+ | have_innodb | NO| +---+---+ 1 row in set (0.09 sec) why? the gentoo eb

RE: Foreign Keys

Can you please post your DDL? -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 4/16/04 10:22 AM Subject: Foreign Keys hi, I am new to mysql. I am trying to create tables with foreign key constraints. but the constraintsdoesnt seem to be showing any effect on the

Re: Foreign Keys

1) are you running the InnoDB version of MySQL? 2) are you using InnoDB tables? If (1) and (2) are not satisfied, MySQL will parse your SQL and totally ignore everything that has to with Foreign Keys. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MyS

Foreign Keys

hi, I am new to mysql. I am trying to create tables with foreign key constraints. but the constraintsdoesnt seem to be showing any effect on the table. I am able to add any info in the foreign key table witout the same info in the main table. what is the problem?? Liza -- MySQL General Mail

Re: foreign keys help

saiph <[EMAIL PROTECTED]> wrote: > > <- snip -> > Because your tables are not InnoDB. > Check if InnoDB is enabled: > SHOW VARIABLES LIKE "have_innodb"; > > <- snip -> > > no, InnoDB is not enabled. how can i enable it? What version of MySQL do you use? 3.23.xx or 4.0.x? If you use 3.23 you sho

Re: foreign keys help

<- snip -> Because your tables are not InnoDB. Check if InnoDB is enabled: SHOW VARIABLES LIKE "have_innodb"; <- snip -> no, InnoDB is not enabled. how can i enable it? the referece manual show a my.cnf configuration for a machine with at least 2gb of ram and 60 of hard disk. how can

Re: foreign keys help

saiph <[EMAIL PROTECTED]> wrote: > > i'm studing foreign keys but my sql code does not react as > would imagine when i insert inconsistent data. > > i.e. > > create database urls; > use urls; > > create table caths > ( >name varchar(7) primar

Re: foreign keys help

Don't foreign keys need to be explicitly indexed? Respectfully, Ligaya Turmelle "saiph" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > hi list, > > i'm studing foreign keys but my sql code does not react as > would imagine when i inse

foreign keys help

hi list, i'm studing foreign keys but my sql code does not react as would imagine when i insert inconsistent data. i.e. create database urls; use urls; create table caths ( name varchar(7) primary key ) type = innodb; create table urls ( name varchar(10) primary key, home va

Re: understanding foreign keys

AIL PROTECTED]> wrote: > rb <[EMAIL PROTECTED]> wrote: > > I am a new user trying to learn mysql (using > InnoDB tables, mysql > > version 3.23.54) and to create a useful database > for a project I am > > working on. In trying to understand how to use > fore

Re: understanding foreign keys

rb <[EMAIL PROTECTED]> wrote: > I am a new user trying to learn mysql (using InnoDB tables, mysql > version 3.23.54) and to create a useful database for a project I am > working on. In trying to understand how to use foreign keys effectively, > I studied examples at http://sqlz

understanding foreign keys

I am a new user trying to learn mysql (using InnoDB tables, mysql version 3.23.54) and to create a useful database for a project I am working on. In trying to understand how to use foreign keys effectively, I studied examples at http://sqlzoo.net - "A Gentle Introduction to SQL" I am

Null Values & Foreign Keys

Here're a couple of tables: create table company(CompanyID varchar(32),...); create table contact(CompanyId varchar(32),... INDEX (CompanyID), FOREIGN KEY (CompanyID) REFERENCES company(CompanyID); Now, my expectation is that if contact has a CompanyID but it does not match one already e

Re: Foreign Keys in CREATE TABLEs produced by mysqldump

Michael, - Alkuperäinen viesti - Lähettäjä: <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Monday, December 29, 2003 11:53 PM Aihe: Re: Foreign Keys in CREATE TABLEs produced by mysqldump > &

Re: Foreign Keys in CREATE TABLEs produced by mysqldump

"Heikki Tuuri" <[EMAIL PROTECTED]> wrote on 12/24/2003 01:53:07 PM: > Michael, > > this is the question where the valid answer is: upgrade! > In which version was this corrected? I'm hesitant to upgrade to the latest and greatest without it being banged on by the masses first.. I have half a d

Re: foreign keys plz?

* Alaios > with myIsam? Does not check about integrity? That is correct, the myisam table handler does not support foreign key constraints. It does of course support foreign keys, but not foreign key constraints, consequently the foreign key itegrity is not checked for myisam tables. > Mys

Re: foreign keys plz?

with myIsam? Does not check about integrity? Mysql 3.2? What u will use for your application Innodb or MyISAM? --- Martijn Tonies <[EMAIL PROTECTED]> wrote: > Hi, > > > Hi there. I heave heared that mysql doesnot > support > > foreign keys? > > It does, but

Re: foreign keys plz?

Hi, > Hi there. I heave heared that mysql doesnot support > foreign keys? It does, but only with the "InnoDB" table type. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.ups

foreign keys plz?

Hi there. I heave heared that mysql doesnot support foreign keys? What funcionallity provides and what not? Inner Join what provides? Thx __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List

Re: Foreign Keys in CREATE TABLEs produced by mysqldump

Michael, - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, December 24, 2003 1:45 AM Subject: Foreign Keys in CREATE TABLEs produced by mysqldump > --=_alternative 008277CD88256E05_= > Content-Type: text/plain; chars

Foreign Keys in CREATE TABLEs produced by mysqldump

First let me state that this is not a question where a valid answer is to SET FOREIGN_KEY_CHECKS=0... (no, its not *that* question..) I have noticed that mysqldump includes the database name in foreign key specifications within CREATE TABLEs. This is causing a bit of grief as I would like to re

RE: mysqldump table order with foreign keys

- From: sean peters [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 10:28 AM To: [EMAIL PROTECTED] Subject: mysqldump table order with foreign keys Hey all, I'm trying to dump the structure of a database using: mysqldump -d myDatabase > structure.sql Which works fine in getting t

RE: mysqldump table order with foreign keys

You will need to place the following at the head of your dump file. SET FOREIGN_KEY_CHECKS=0 -Original Message- From: sean peters [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 10:28 AM To: [EMAIL PROTECTED] Subject: mysqldump table order with foreign keys Hey all, I&#

mysqldump table order with foreign keys

Hey all, I'm trying to dump the structure of a database using: mysqldump -d myDatabase > structure.sql Which works fine in getting the table create statements, but, how do i get mysqldump to put the creates in an order that will allow replication with foreign key concerns. For instance if i

Re: foreign keys.

MAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, December 18, 2003 12:47 AM > Subject: Re: foreign keys. > > > On Thu, 18 Dec 2003 09:05 am, Heikki Tuuri wrote: > > > Mofeed, > > > > > > - Original Message - > > > From: "Mo

Re: foreign keys.

Mofeed, - Original Message - From: "Mofeed Shahin" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 12:47 AM Subject: Re: foreign keys. > On Thu, 18 Dec 2003

Re: foreign keys.

On Thu, 18 Dec 2003 09:05 am, Heikki Tuuri wrote: > Mofeed, > > - Original Message - > From: "Mofeed Shahin" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, December 18, 2003 12:2

Re: foreign keys.

Mofeed, - Original Message - From: "Mofeed Shahin" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 12:20 AM Subject: Re: foreign keys. > Hmmm, Thanks for that. > B

Re: foreign keys.

N KEY error. > > Best regards, > > Heikki Tuuri > Innobase Oy > http://www.innodb.com > Foreign keys, transactions, and row level locking for MySQL > InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM > tables > > Order MySQL technical su

Re: foreign keys.

On Wed, 17 Dec 2003 07:55 pm, Victoria Reznichenko wrote: > Mofeed Shahin <[EMAIL PROTECTED]> wrote: > > mysql> CREATE TABLE foo ( > >-> ID INT PRIMARY KEY, > >-> note VARCHAR(50), > >-> First_Name VARCHAR(50), > >-> Last_Name VARCHAR(50), > >

Re: foreign keys.

Mofeed, if you are using a relatively recent version of 4.0, or 4.1.1, please look with SHOW INNODB STATUS\G what is the latest FOREIGN KEY error. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot

Re: foreign keys.

Mofeed Shahin <[EMAIL PROTECTED]> wrote: > > mysql> CREATE TABLE foo ( >-> ID INT PRIMARY KEY, >-> note VARCHAR(50), >-> First_Name VARCHAR(50), >-> Last_Name VARCHAR(50), >-> FOO_ID INT, >-> INDEX(FOO_ID), >-

<    1   2   3   4   5   >