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 *

DOH! How did I miss that? Must be time for bed!

> -- 
> 
> Bastien
> 
> Cat, the other other white meat
> 
> -- 
> 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