- COPYRIGHT & LICENSE
Fey::SQL::Delete - Represents a DELETE query
my $sql = Fey::SQL->new_delete(); # DELETE FROM Part # WHERE Part.name LIKE '%Widget' $sql->delete(); $sql->from($Part); $sql->where( $name, 'LIKE', '%Widget' ); print $sql->sql($dbh);
This class represents a
This class provides the following methods:
To construct an object of this class, call
$query->delete() on a
This method is basically a no-op that exists to so that Fey::SQL has something to call after it constructs an object in this class.
This method specifies the
FROM clause of the query. It expects one or more Fey::Table objects (not aliases). Most RDBMS implementations only allow for a single table here, but some (like MySQL) do allow for multi-table deletes.
See the Fey::SQL section on WHERE Clauses for more details.
See the Fey::SQL section on ORDER BY Clauses for more details.
See the Fey::SQL section on LIMIT Clauses for more details.
Returns the full SQL statement which this object represents. A DBI handle must be passed so that identifiers can be properly quoted.
See the Fey::SQL section on Bind Parameters for more details.
DELETE clause portion of the SQL statement as a string.
WHERE clause portion of the SQL statement as a string.
ORDER BY clause portion of the SQL statement as a string.
LIMIT clause portion of the SQL statement as a string.
Dave Rolsky, <email@example.com>
See Fey for details on how to report bugs.
Copyright 2006-2009 Dave Rolsky, All Rights Reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.