Fey::SQL::Update - Represents a UPDATE query


  my $sql = Fey::SQL->new_update();

  # UPDATE Part
  #    SET quantity = 10
  #  WHERE part_id IN (1, 5)
  $sql->set( $quantity, 10 );
  $sql->where( $part_id, 'IN', 1, 5 );

  print $sql->sql($dbh);


This class represents a UPDATE query.


This class provides the following methods:


To construct an object of this class, call $query->update() on a Fey::SQL object.


This method specifies the UPDATE 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 updates.


This method takes a list of key/value pairs. The keys should be column objects, and the value can be one of the following:

  • a plain scalar, including undef

    This will be passed to Fey::Literal->new_from_scalar().

  • Fey::Literal object

  • Fey::Column object

    A column alias cannot be used.

  • Fey::Placeholder object


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.


Dave Rolsky, <>


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.