At 10:42 PM 2/25/2007, mos wrote:
At 06:13 PM 2/25/2007, Miles Thompson wrote:
Would someone please check this delete query?
This should delete all rows from the geodesic_user_data that have no
match in the subscriber table, but another set of eyes would be appreciated.
DELETE
At 07:51 PM 2/26/2007, Miles Thompson wrote:
At 10:42 PM 2/25/2007, mos wrote:
At 06:13 PM 2/25/2007, Miles Thompson wrote:
Would someone please check this delete query?
This should delete all rows from the geodesic_user_data that have no
match in the subscriber table, but another set of
Would someone please check this delete query?
This should delete all rows from the geodesic_user_data that have no match
in the subscriber table, but another set of eyes would be appreciated.
DELETE geodesic_user_data
FROM geodesic_user_data
LEFT JOIN subscriber ON
At 06:13 PM 2/25/2007, Miles Thompson wrote:
Would someone please check this delete query?
This should delete all rows from the geodesic_user_data that have no match
in the subscriber table, but another set of eyes would be appreciated.
DELETE geodesic_user_data
FROM geodesic_user_data
LEFT
Daevid Vincent [EMAIL PROTECTED] wrote:
I have my schema set so that a field in a table has a default value of 16.
I also have a script that initializes the database, but I don't want to
delete the record since I want the other fields' data preserved. Is there a
way to find out what the
I have my schema set so that a field in a table has a default value of 16.
I also have a script that initializes the database, but I don't want to
delete the record since I want the other fields' data preserved. Is there a
way to find out what the default schema value is so that I can issue an
Hi,
is it possible to ignore all sql delete statement while doing
mysql replication?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
You could do something like have a process periodically run the non-delete
queries in the logs against another database and replicate the second
database. Wouldn't be automatic, but you'd have as much control as you like
over what goes in the other db.
Depending on what you're trying to do, it
On Thursday 16 January 2003 12:16, CheongMeng wrote:
is it possible to ignore all sql delete statement while doing
mysql replication?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net
in set (0.00 sec)
mysql ## THIS IS THE STATEMENT CAUSING THE FAULTY REPORT
mysql delete from asses_cats;
Query OK, 0 rows affected (0.00 sec)
mysql select * from asses_cats;
Empty set (0.00 sec)
same situation, different delete statement
mysql select * from asses_cats
* Martijn Haak
Description:
Using delete with no where statement results in a faulty message about
updated lines
How-To-Repeat:
SQL-statements follow:
mysql select * from asses_cats;
+---+---+
| ac_id | label |
+---+---+
| 1 | test1 |
| 2 | test2 |
Andrew,
Friday, April 26, 2002, 3:12:25 AM, you wrote:
AW Hello, I am new to mysql - past the very basics - you may see a few silly
AW questions - here is the first.
AW I have a DELETE statement:
AW delete bond_master,bond_data from bond_data where
AW bond_master.cusip=bond_data.cusip
Hello, I am new to mysql - past the very basics - you may see a few silly
questions - here is the first.
I have a DELETE statement:
delete bond_master,bond_data from bond_data where
bond_master.cusip=bond_data.cusip and bond_master.maturity = 2002/02/15;
That has syntax errors. I am
I don't know if this is a bug or a feature. Just an observation concerning
creating MYISAM tables with auto_increment.
CREATE TABLE mytable (myval int auto_increment unique ) AUTO_INCREMENT=9000;
INSERT INTO mytable VALUES(NULL);
INSERT INTO mytable VALUES(NULL);
these above INSERTS create
is preferred.
Question: upon deleting all entries from a table with DELETE FROM mytable,
should the next auto_incremented value be 1 or the initial auto_increment
value specified in the CREATE statement (in this case 9000)?
1. To retain the current counter, empty the table using a DELETE
statement
Dear all,
Does anyone know how I can run a script that calls other scripts in order to
create the DB and its tables?
How do I do it from my Windows NT?
Thanks
From: Sascha Dahl [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: LIKE clause in DELETE-Statement
Date: Wed, 25 Apr 2001 10:48:51
Hi,
I want to delete products from subcategories which are part of a main
category.
for example:
maincat
|__subcat1
| |__prod1
| |__prod2
| |__prod3
|
|__subcat2
I'm trying to write a query which deletes prod1,2,3
I tried this but it doesn't seem to work. Can anyone help?
DELETE FROM
Hello, Lieven!
I will kindly answer...
Subselects are not supported in current released versions of mySQL. Please "continue"
to ask questions, as that is what list groups are for.
Fredrick
Fred van Engen wrote:
Hi,
On Sun, Feb 18, 2001 at 05:23:02PM +0100, Lieven Op De Beck wrote:
Hello,
Personally, I am sick and tired of discussions like that.
On Sun, Feb 18, 2001 at 09:36:47AM -0800, Fredrick Bartlett wrote:
I will kindly answer...
Thank you Fredrick! But your answer is not the answer Lieven wanted and me too, by the
way.
Subselects are not supported in current
: "Canadian Lumberer" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 19, 2001 11:50
Subject: Re: DELETE statement
Hello,
Personally, I am sick and tired of discussions like that.
On Sun, Feb 18, 2001 at 09:36:47AM -0800, Fredrick Bartlett wrote:
I will kindly answ
20 matches
Mail list logo