This should work
DELETE Item FROM Item,ItemTag WHERE Item.ProductID =ItemTag.ItemID AND
ItemTag.TagID = '168'
Mark Kelly wrote:
Hi
I want to delete from the 'Item' table all the items identified by the
folowing query:
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.
Hi All,
I am planning to take mysqldump on slave running innodb engine.
I going to use the below command
/usr/bin/mysqldump --user=root --password= --flush-logs --all-databases
--master-data=2 --single-transaction > alldbdump.sql
Before doing the mysqldump, should i stop the slave or the
What i the error you seeing the error log file.
Please let us know
On 7/5/07, Douglas Araujo <[EMAIL PROTECTED]> wrote:
Hi everybody,
I have a MySQL 4.1 running on a Red Hat Linux Enterprise 4 that the
databases directory is the default point, /var/lib/mysql.
I have a NFS mount point in /va
The original message was received at Thu, 5 Jul 2007 20:50:06 +0200 from
pdnets.com [191.191.29.26]
- The following addresses had permanent fatal errors -
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On 7/5/07, David T. Ashley <[EMAIL PROTECTED]> wrote:
>
> a)I'm assuming that under MySQL I have to create a third table that maps
> between them? (Let's call it "users2priveleges".)
>
> b)I'm assuming that there is nothing special I need to do to get, for
> example, all the priveleges with a u
David, you've hit the nail on the head.
Dan
On 7/5/07, David T. Ashley <[EMAIL PROTECTED]> wrote:
I'm an old Microsoft Access user, so I just need to double-check on this
with MySQL:
I want to relate two tables (let's call them "users" and "priveleges") in
a
many:many way. That is, each use
I'm an old Microsoft Access user, so I just need to double-check on this
with MySQL:
I want to relate two tables (let's call them "users" and "priveleges") in a
many:many way. That is, each user may have multiple priveleges, and each
privelege may have multiple users with that privelege.
Here a
DBTools Software is pleased to announce the new DBManager Professional
Enterprise Edition version 3.4.5.
This is only a bug fix without new features and recommended for users of
previous versions.
For a complete list of changes please check
http://www.dbtools.com.br/EN/article.php?id=00094.
The n
The following query should work if I understand what you're attempting
correctly. Use at your own risk though ;)
DELETE FROM Item USING Item, ItemTag WHERE ItemTag.ItemID =
Item.ProductID AND ItemTag.TagID = '168';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi everybody,
I have a MySQL 4.1 running on a Red Hat Linux Enterprise 4 that the
databases directory is the default point, /var/lib/mysql.
I have a NFS mount point in /var/lib/mysql/area2, that mounts the
directory of a storage, when I mount the NFS, the MySQL server don't
show the database.
A
Hi.
On Thursday 05 July 2007 17:35, you wrote:
> > I want to delete from the 'Item' table
> > all the items identified by the folowing query:
>
> If you have MySQL 5+, you can do it using a sub-query:
>
> DELETE FROM
> Item
> WHERE
> ProductID IN (
> SELECT
> Item.ProductID
> FROM
> It
> I want to delete from the 'Item' table
> all the items identified by the folowing query:
If you have MySQL 5+, you can do it using a sub-query:
DELETE FROM
Item
WHERE
ProductID IN (
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
ItemTag.Ite
Hi
I want to delete from the 'Item' table all the items identified by the
folowing query:
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
ItemTag.ItemID = Item.ProductID;
but I'm not sure how to go about it. Can anyone help?
Thanks
Mark
--
My
Hi Alex,
You mean in the user table, right? max_questions, max_updates and
max_connections are all set to 0 for all accounts.
Can you think of anything else?
Thanks
-Chris
From: [EMAIL PROTECTED] on behalf of Alex Arul Lurthu
Sent: Thu 7/5/2007 2:03 AM
To:
Hi All,
There is 5 years data on mysql databases server. I want to delete 4 years
data from mysql server and keep it as a backup on external drive. The total
number of tables in the datases are more than 300+. Deletion will be done on
the basis of date column.
Please tell me the efficient way to
Hi Krishna,
If you dont have a date column, then on what basis you would be deleting
data older than 6 months.
As i mentioned earlier, if the no. of records in the table is less then you
can use direct delete statment.
On 7/5/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote:
Hi All,
So
16 matches
Mail list logo
