Hi there. I am trying to find what these
ON DELETE NO ACTION
ON UPDATE NO ACTION
would provide ib my db. What are the options and what each of them do?
-
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
objects by using ON DELETE CASCADE.
NO ACTION will raise an exception if there are child objects
and you're trying to delete/update a parent row.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
Hi!
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 03, 2003 4:46 PM
Subject: Re: on delete|update
Hi,
Hi there. I am trying to find what these
ON DELETE NO ACTION
ON UPDATE NO ACTION
would provide
- Original Message -
From: Alaios
To: Martijn Tonies
Sent: Wednesday, December 03, 2003 4:57 PM
Subject: Re: on delete|update
axa!!! this works with myIsam tables?
Martijn Tonies [EMAIL PROTECTED] wrote: Hi,
Hi there. I am trying to find what these
ON DELETE NO ACTION
ON UPDATE NO ACTION
Hi!
Bennett == Bennett Haselton [EMAIL PROTECTED] writes:
Bennett Is there any way to do a long update/delete on a table such that you can
Bennett view the progress as the command runs, so that long before it's over, you
Bennett have some idea of what the total running time will be?
Bennett
Is there any way to do a long update/delete on a table such that you can
view the progress as the command runs, so that long before it's over, you
have some idea of what the total running time will be?
The way I did it was to write a perl script that takes the total range of
values for the
someone, please, show me an example on how can I delete/update table
V based on the records in another tables. This is query that works on ASA:
V delete from t1
V from t1, t2
V where t1.col1 = t2.col1
V and t2.col2 is NULL ;
V update t1, t2
V
and
update. I can live without stored procedures, triggers and views
(although, they are very useful simply can not function as a DBA /SQL
developer without being able to perform simple delete on a table set
based on the result of a join.
Can someone, please, show me an example on how can I delete/update
and
update. I can live without stored procedures, triggers and views
(although, they are very useful simply can not function as a DBA /SQL
developer without being able to perform simple delete on a table set
based on the result of a join.
Can someone, please, show me an example on how can I delete/update
-Original Message-
From: Vadim [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 27, 2002 4:49 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: I need an example on DELETE /UPDATE with JOIN syntax
Greetings:
My company migrated to MySQL a few months ago from Sybase
Thank you for your report.
We shall take a look at it.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/
OK, I sent in something I hope will be useful.
# PROBLEM SUMMARY ###
Two problems seen with multi-table delete:
1) After a multi-table delete, first query of the second table
referenced in
the delete results in ERROR 1032. Subsequent queries are fine. Happens
with
BDB and InnoDB.
hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Becky McElroy writes:
Two questions regarding multi-table operations:
1) I've got multi-table delete working with a couple of BDB tables,
where it's properly deleting from one or both tables, and all
possibilities of the
Becky McElroy writes:
Thank you for your response and the info.
Actually I was using 4.0.1 which I downloaded a couple of days ago:
[beckymcelroy@indigo bhm]$ rpm -qa | grep SQL
MySQL-Max-4.0.1-2
MySQL-client-4.0.1-2
MySQL-4.0.1-2
[beckymcelroy@indigo bhm]$
[skip]
--
Becky
Becky McElroy writes:
Two questions regarding multi-table operations:
1) I've got multi-table delete working with a couple of BDB tables,
where it's properly deleting from one or both tables, and all
possibilities of the delete criteria are being exersized. After the
multi-table delete
Two questions regarding multi-table operations:
1) I've got multi-table delete working with a couple of BDB tables,
where it's properly deleting from one or both tables, and all
possibilities of the delete criteria are being exersized. After the
multi-table delete command, I can 'select *' from
16 matches
Mail list logo