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
===
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]
-
It's
(`parent_id`) REFERENCES `show_cat` (`id`)
) ENGINE=InnoDB 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
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
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.
Finally I read from PhpMyAdmin documentation that recently PhpMyAdmin
can check
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 I still dont know how to do
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 Integrity
but I still
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
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
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
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 work!
Rob
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 of the
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
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
:)
/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\binmysql --local-infile -h localhost -u rob -prob
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id
\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 problem remains... details below.
Any further
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
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 which is
AY actually
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
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 constraints
, 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 do i take advantage of it and where in the
BP documenation
-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=
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
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
three tables:
CREATE TABLE members (
member_id int
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 communicate
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
PD: sorry about my grammar
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
, 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]
To: pak [EMAIL PROTECTED]
Cc: Ken
|
||
--
|__|__|
|| ||
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 -
From: Ken
]
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 workflows (incomplete data or
data entered out of sequence) and adds processing
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
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:
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
Subject: Re: Referential Integrity
So is MySQL
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 entering what is supposed
: 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, rather than
someone else trying to tell you objectively what is suitable.
You can argue for and against the use
35 matches
Mail list logo