Lines Matching +refs:org +refs:table
113 my $table = $self->_table(shift);
119 $sql = join " ", $self->_sqlcase('insert into'), $table, $sql;
242 my $table = $self->_table(shift);
286 my $sql = $self->_sqlcase('update') . " $table " . $self->_sqlcase('set ')
308 my $table = $self->_table(shift);
318 $self->_sqlcase('from'), $table)
331 my $table = $self->_table(shift);
336 my $sql = $self->_sqlcase('delete from') . " $table" . $where_sql;
1056 # separate table / column (if applicable)
1060 # do the quoting, except for "*" or for `table`.*
1333 my($stmt, @bind) = $sql->select($table, \@fields, \%where, \@order);
1335 my($stmt, @bind) = $sql->insert($table, \%fieldvals || \@values);
1337 my($stmt, @bind) = $sql->update($table, \%fieldvals, \%where);
1339 my($stmt, @bind) = $sql->delete($table, \%where);
1483 similar order to each function (table, then fields, then a where
1511 %where = (name => 'nwiger', email => 'nate@wiger.org');
1515 WHERE name = 'nwiger' AND email = 'nate@wiger.org'
1520 WHERE name like 'nwiger' AND email like 'nate@wiger.org'
1637 This is the character that a table or column name will be quoted
1655 This is the character that separates a table and column name. It is
1659 SELECT `table`.`one_field` FROM `table` WHERE `table`.`other_field` = 1
1689 =head2 insert($table, \@values || \%fieldvals, \%options)
1691 This is the simplest function. You simply give it a table name
1715 =head2 update($table, \%fieldvals, \%where)
1717 This takes a table, hashref of field/value pairs, and an optional
1734 The argument can be either a plain scalar (interpreted as a table
1736 of table names, joined by commas, quoted), or a scalarref
1737 (literal table name, not quoted), or a ref to an arrayref
1738 (list of literal table names, joined by commas, not quoted).
1748 the first argument C<$table>, for backwards compatibility reasons.
1767 =head2 delete($table, \%where)
1769 This takes a table name and optional hashref L<WHERE clause|/WHERE CLAUSES>.
1795 my($stmt, @bind) = $sql->generate('create table', \$table, \@fields);
1796 my $stmt_and_val = $sql->generate('create table', \$table, \@fields);
2545 $stmt ||= $sql->insert('table', $href);
2574 my($stmt, @bind) = $sql->update('table', $field, {id => $id});
2579 table, the actual query script can be extremely simplistic.
2677 Copyright (c) 2001-2007 Nathan Wiger <nwiger@cpan.org>. All Rights Reserved.