|
erics, May 16th, 2011 |
1 2 |
INSERT INTO globals ( setting, content ) VALUES ( ?, ? ) ON DUPLICATE KEY UPDATE content = VALUES(content); |
Categories: How-To's, Technology Duplicate Key, howto, Insert, mysql, SQL, tips
| 
No comments
erics, May 11th, 2011 |
1 2 3 4 5 6 7 |
my $value = $dbh->fetch_one_value( 'table' => 'users', 'columns' => 'COUNT(*)', 'where' => { 'active' => 1, }, ); |
Categories: How-To's, Technology Column, Count, DBI, DBIx, DBIx::SQLEngine, mysql, SQL
| No comments
erics, August 3rd, 2010 [code]SELECT city, sum(is_special) as special_count FROM stores where state="$state" group by city[/code]
Categories: How-To's, Technology Count, Distinct, mysql, select, SQL, Sum
| No comments
erics, January 5th, 2010 Found that DBIx::Wrapper was BROKEN BADLY – now using DBIx::SQLEngine with great success… Just had our first successful test from the database through JSON to the javascript front-end. Very nice. Zooooooooom!
Categories: Technology CPAN, DBI, DBIx, JSON, mysql, perl, SQL
| No comments
