[PHP-DB] deleting rows with composite primary key
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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] deleting rows with composite primary key
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. 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
Re: [PHP-DB] deleting rows with composite primary key
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
Re: [PHP-DB] deleting rows with composite primary key
On Tue, May 18, 2010 at 2:51 PM, Niel Archer n...@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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] deleting rows with composite primary key
On Tue, May 18, 2010 at 2:51 PM, Niel Archer n...@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 * 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
