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 DELETE query.
DELETE
This class provides the following methods:
To construct an object of this class, call $query->delete() on a Fey::SQL object.
$query->delete()
Fey::SQL
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.
FROM
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.
This class does Fey::Role::SQL::HasWhereClause, Fey::Role::SQL::HasOrderByClause, and Fey::Role::SQL::HasLimitClause roles.
Fey::Role::SQL::HasWhereClause
Fey::Role::SQL::HasOrderByClause
Fey::Role::SQL::HasLimitClause
Dave Rolsky, <autarch@urth.org>
See Fey for details on how to report bugs.
Copyright 2006-2008 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.
To install Fey, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Fey
CPAN shell
perl -MCPAN -e shell install Fey
For more information on module installation, please visit the detailed CPAN module installation guide.