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

2010-05-18 Thread Niel Archer
> On Tue, May 18, 2010 at 2:51 PM, Niel Archer 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` ( > >> >   `i

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

2010-05-18 Thread Bastien Koert
On Tue, May 18, 2010 at 2:51 PM, Niel Archer 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 N

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

2010-05-18 Thread Niel Archer
> > 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, > > PRIM

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

2010-05-18 Thread Niel Archer
> 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`,

[PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Systems
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 `i