> 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
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
> > 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
> 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`,
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