Re: deleting rows with composite primary key

On Tue, May 18, 2010 at 2:51 PM, Niel Archer <not@chance.now> 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