Dear MySQL developers and users,
Version 0.9.8 Beta of the PrimeBase XT storage engine for MySQL 5.1
has just been released.
PBXT is a transactional storage engine for MySQL which can be loaded
dynamically by the pluggable storage engine API of MySQL 5.1. Full
MVCC (multi-version concurre
; CONSTRAINT `show_cat_ibfk_1` FOREIGN KEY
> > (`parent_id`) REFERENCES `show_cat` (`id`)
> > ) ENGINE=InnoDB DEFAULT CHARSET=latin1
> >
> > ===
> >
> > I would like to know what would be the best method
> > to
> > d
DB DEFAULT CHARSET=latin1
===
I would like to know what would be the best method to
delete some records of the table without lossing
referential integrity.
thanks,
esv.
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
fframe wrote:
> >I've read that MyIsam type table doesnt have the "referential
integrity" function...
Correct.
> >I hav tried to find other 3rd party s/w that can solve the issue.
The program / script that uses MySQL data can manage the integrity issues.
>
CanIt Vote for ID 62298InnoDB still has the major issue about the slow access of
database...
I use mysql database for website..
- Original Message -
From: Daniel Kasak
To: starofframe ; [EMAIL PROTECTED]
Sent: Friday, July 02, 2004 11:08 AM
Subject: Re: referential integrity
starofframe wrote:
Hi All,
I've read that MyIsam type table doesnt have the "referential integrity" function...
I hav tried to find other 3rd party s/w that can solve the issue.
Finally I read from PhpMyAdmin documentation that "recently PhpMyAdmin can check
referential In
Hi All,
I've read that MyIsam type table doesnt have the "referential integrity" function...
I hav tried to find other 3rd party s/w that can solve the issue.
Finally I read from PhpMyAdmin documentation that "recently PhpMyAdmin can check
referential Integrity"
but
At 16:20 +0100 28-07-2003, Tom Gazzini wrote:
I need to have a table that supports FULLTEXT searches. This implies
that this table should be a MyISAM table.
However, I also require that this table act as a parent for child tables
in order to support referential integrity. If I create the child
> I need to have a table that supports FULLTEXT searches. This
> implies that this table should be a MyISAM table.
>
> However, I also require that this table act as a parent for
> child tables in order to support referential integrity. If I
> create the child tables as I
I need to have a table that supports FULLTEXT searches. This implies
that this table should be a MyISAM table.
However, I also require that this table act as a parent for child tables
in order to support referential integrity. If I create the child tables
as INNODB tables, will referential
\ibdata
Rob
:)
> -Original Message-
> From: Robert Mark Bram [mailto:[EMAIL PROTECTED]
> Sent: Sunday, 23 February 2003 1:03 AM
> To: Mysql
> Subject: RE: mysqld-max but still no referential integrity?
>
>
> Howdy all!
>
> I have changed my my.ini but my pr
bin/mysqld-MAX-nt.exe
innodb_data_home_dir = C:\mySql\ibdata
innodb_data_file_path=ibdata1:30M:autoextend
== Creating tables with referential integrity?
C:\mySql\bin>mysql --local-infile -h localhost -u rob -prob
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connect
I think I solved this.. I deleted C:\mySql\ibdata and I could start it up
again..
I think I know why it happened too.. when I start a connection with this:
mysqld-max-nt.exe --console --standalone
it takes the console over..
How do I properly close it down from another console?
Rob
:)
---
Hi Oliver,
I tried as you suggested, but I have a different problem now..
> > == my.ini
> > My my.ini file:
> >
> > [mysqld]
> > basedir=C:/mySql/
> > datadir=C:/mySql/data
> >
> > [WinMySQLAdmin]
> > Server=C:/mySql/bin/mysqld-MAX-nt.exe
> > innodb_data_home_dir = C:\mySql\ibdata
> > innodb
Hy Rob,
> == my.ini
> My my.ini file:
>
> [mysqld]
> basedir=C:/mySql/
> datadir=C:/mySql/data
>
> [WinMySQLAdmin]
> Server=C:/mySql/bin/mysqld-MAX-nt.exe
> innodb_data_home_dir = C:\mySql\ibdata
> innodb_data_file_path=ibdata1:30M:autoextend
you have the InnoDB Variables in the wrong section
Howdy all!
I thought InnoDB tables enforced referential integrity? I believe I have set
up MySql to use InnoDB tables and I have created tables of type InnoDB, yet
I can still enter an illegal row!
Can anyone tell me what I am doing wrong? The final "insert into PET " below
should not
Adnan,
Tuesday, July 16, 2002, 2:18:22 PM, you wrote:
AY> I am having a problem in referential Integrity in mySQL. I have
AY> created a parent table which have deptno from 1-10. When i insert a row in
AY> child table that has deptno as foreign key it accept a value 11 wh
Hello all,
I am having a problem in referential Integrity in mySQL. I have
created a parent table which have deptno from 1-10. When i insert a row in
child table that has deptno as foreign key it accept a value 11 which is
actually not present in parent table.
Can
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Blue Presley wrote:
| okay, so my tables have to be of type InnoDB. Is there a
configuration file
| somewhere where i can specify that all my tables be InnoDB so I don't have
| to keep manually specifying the type?
|
Add "set-variable= default-t
;[EMAIL PROTECTED]>
Sent: Tuesday, July 02, 2002 11:45 AM
Subject: Re: cascading, referential integrity
> Blue,
> Tuesday, July 02, 2002, 5:54:32 PM, you wrote:
>
> BP> does mysql 3.23 support cascading and referential integrity or is this
only
> BP> part of 4.01? if so, how
Blue,
Tuesday, July 02, 2002, 5:54:32 PM, you wrote:
BP> does mysql 3.23 support cascading and referential integrity or is this only
BP> part of 4.01? if so, how do i take advantage of it and where in the
BP> documenation (link) can I read about it?
Yes, MySQL supports foreign key co
does mysql 3.23 support cascading and referential integrity or is this only
part of 4.01? if so, how do i take advantage of it and where in the
documenation (link) can I read about it?
thanks,
blue
-
Before posting, please
>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 28, 2001 2:05 PM
Subject: Programming for referential integrity
> Hello,
> Forgive me for what is probably a fairly novice question as I am still
> fairly new to MySQL. I have constructed the following database with
> thre
Hello,
Forgive me for what is probably a fairly novice question as I am still
fairly new to MySQL. I have constructed the following database with
three tables:
CREATE TABLE members (
member_id int DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY,
first varchar(20) NOT NULL,
last varchar(20)
At 11:02 PM 8/12/01 -0300, you wrote:
>I read that MySQL doesn't support the referential integrity, so i wan to
>know if you recommend to use it in systems with complex relationated
>tables in a database.
>If yes, where can i find helpfull documentation about that.
>thanks
I read that MySQL doesn't support the referential integrity, so i wan to know if you
recommend to use it in systems with complex relationated tables in a database.
If yes, where can i find helpfull documentation about that.
thanks
PD: sorry about my grammar and stuff, see i normally commun
Well, dunno about that, but I've got a system here which I designed round
the fact that MySQL *doesn't* have RI.
When a customer gets deleted (or changes it's reference id), the data for
the old id has to remain in the system. I know that if I was using a
product which enforces RI I'd design it d
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 10:20 AM
Subject: RE: Referential Integrity
>
> In my experience, most "large corporate" databases
> are not implemented with RI enabled. The RI constraints
> often interfere with user
0.596.1443|
||
--
|__|__|
|| ||
ooO Ooo
-Original Message-
From: pak [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 11:31 PM
To: Ken Sommers; [EMAIL PROTECTED]
Subject: Re: Referential Integrity
So is MySQL not suitable for large corporate database ?
- Original Message -
2001 11:58 PM
To: Michael Bacarella; pak
Cc: [EMAIL PROTECTED]
Subject: Re: Referential Integrity
Please give some examples of 'bad' design where a "foreign key" would have
to be changed..
ken
- Original Message -
From: "Michael Bacarella" <[EMAIL PROTECTED
On Wed, Jul 11, 2001 at 01:31:15PM +1000, pak wrote:
>
> So is MySQL not suitable for large corporate database ?
It often depends on the corporation and who makes the decisions. In
many corporations, it's the folks who know little about the
technology. In the minority of them, it appears to be
ECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 8:53 PM
Subject: Re: Referential Integrity
> On Wed, Jul 11, 2001 at 01:31:15PM +1000, pak wrote:
>
> > So is MySQL not suitable for large corporate database ?
>
> That depends more on what you feel is suitable, r
from our systems
(since they're taxed quite heavily).
On systems that I've designed that are terrible, I wish I had
referential integrity. :)
This is not to say that I wouldn't mind the feature, but it's
absolutely not stopping me from enjoying MySQL.
-MB
> | If the user is en
Please give some examples where you would need the dbms to do the
referential integrity?
Ken
- Original Message -
From: "pak" <[EMAIL PROTECTED]>
To: "Ken Sommers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 8:31 PM
Subjec
So is MySQL not suitable for large corporate database ?
- Original Message -
From: "Ken Sommers" <[EMAIL PROTECTED]>
To: "pak" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 1:24 PM
Subject: Re: Referential Integrity
| hello
-- Original Message -
From: "pak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 7:17 PM
Subject: Referential Integrity
> MySQL does not support RI, anyone has good suggestion that do this in the
> program ?
> As this
MySQL does not support RI, anyone has good suggestion that do this in the
program ?
As this would be a nightmare if I have 50 detail tables to update
programmatically.
-
Before posting, please check:
http://www.mysql.com/manu
37 matches
Mail list logo
