Hi.
On Friday 18 May 2012 18:21:07 Daevid Vincent wrote:
> Actually, I may have figured it out. Is there a better way to do this?
I don't see why you need the dvds table when the dvd_id is in the scene table:
SELECT a.dvd_id
FROM scenes_list a, moviefiles b
WHERE a.scene_id = b.scene_id
AND
Hi.
On Thursday 10 Mar 2011 at 20:09 mos wrote:
[snip]
> Let's say I have a Document_Id column and the url is
> www.mydocuments.com/public?docid=4
> to retrieve document_id=4, I don't want someone to write a program to
> retrieve all of my public documents and download them. I want them to go
>
Hi.
On Wednesday 08 August 2007 18:39, Jason Pruim wrote:
> Did some more testing, made a new table and matched the field names,
> now it will load it without any errors, it's just only importing the
> first row... Not the rest of the 934 records...
You are using ENCLOSED BY '"' in your SQL, whic
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
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
