deleting rows with composite primary key
[email protected] ("Systems")
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
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';"; Error is a 1064 syntax error. Any help is appreciated. Eli