Re: [PHP-DB] deleting rows with composite primary key

On Tue, May 18, 2010 at 2:51 PM, Niel Archer <[email protected]> wrote:
>> > Is there a different syntax to the mysql delete statement when the "WHERE"
>> > clause points only to half of the primary key?
>> >
>> > The structure is as follows:
>> > CREATE TABLE IF NOT EXISTS ` table1` (
>> >   `id1` int(10) unsigned NOT NULL,
>> >   `id2` int(10) unsigned NOT NULL,
>> >   PRIMARY KEY  (`id1`,`id2`),
>> >   KEY `id2` (`id2`)
>> > ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
>> >
>> > Query is
>> > $query = "DELETE * FROM table1 WHERE id1 = '$recID';";
>>
>> Integer values do not need to be quoted. You should be able to drop the
>> semi-colon from the query too.  See if that helps
>>
>> > Error is a 1064 syntax error.
>
> And try var_dump()ing the complete query to make sure it looks as you
> would expect.
>
>
>> > Any help is appreciated.
>> >
>> > Eli
>> >
>> >
>> > --
>> > PHP Database Mailing List (http://www.php.net/)
>> > To unsubscribe, visit: http://www.php.net/unsub.php
>>
>> --
>> Niel Archer
>> niel.archer (at) blueyonder.co.uk
>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> Niel Archer
> niel.archer (at) blueyonder.co.uk
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

The syntax should be

"DELETE FROM table1 WHERE id1 = '$recID';";

No need for the *

-- 

Bastien

Cat, the other other white meat