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 ey
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 geodesic_use
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
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 geodesic_classifieds_userda
"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 wha
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
U
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.ensi
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 ma
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)
To
* 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
+
2 rows 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> sel
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=
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
lue specified in the CREATE statement (in this case 9000)?
1. To retain the current counter, empty the table using a DELETE
statement that includes a WHERE clause.
>
>rick
>
>
-
Before posting, please check:
htt
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 entr
Hi!
We just encountered that MySQL seeems not to accept a "LIKE '%...'" clause
in a DELETE statement. In the annotated online documentation it is said a
DELETE statement can be followed by any valid WHERE clause. LIKE is listed
as a common string comparison function in
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-St
In article <[EMAIL PROTECTED]>,
Canadian Lumberer <[EMAIL PROTECTED]> writes:
> Friends, seriously, could you please post working solutions for cascade
> delete, update? Did I miss some FAQ? Site? Page? Post?
As someone else said: You forgot to read the manual.
Why should we re-cite the paragr
- Original Message -
From: "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 a
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 re
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 Beéck wrote:
> >
Hi,
On Sun, Feb 18, 2001 at 05:23:02PM +0100, Lieven Op De Beéck wrote:
> DELETE FROM product
> WHERE product.id in
>(SELECT p.id
> FROM product p, category c
> WHERE p.cat=c.id AND c.subcatfrom=2)
>
You forgot to read the manual.
Regards,
Fred.
--
Fred van Engen
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 prod
23 matches
Mail list logo
