Search results
"tag:programming"
| Title and summary | Date/time | |
|---|---|---|
|
1
|
Pebble Blog Configuration
When configuring Pebble for my blog, there were a couple of things I had to search quite hard to discover. 1. Enablng email notifications. 2. Long Post names (names that include the title of the post -- which is much better for search engines (ie ... |
Dec 14, 2009 11:32:00 AM |
|
2
|
Like column
Like column Create table t1 ( x int unsigned default 911, y like x ) Create table t2 (x like t1.x) Tricky extension Create table t2 (x always like t1.x) Meaning that alter table t1 modify x int signed implies a corresponding alter on t2 The purpose of ... |
Jun 23, 2008 1:17:00 PM |
|
3
|
ALTER Initial
ALTER Initial Alter table this,that (ie. ALTER with multiple changes) appears to be optimized perform a single pass thru a table (at least sometimes) to perform the multiple changes. Some changes require column expression evaluation. These could be done ... |
Jun 15, 2008 1:14:00 PM |
|
4
|
BitOf(column,string)
BitOf(column,string) Manipulating Column Type SETs cannot be readily (or efficiently) manipulated Eg. Suppage the column Flags is defined as set(‘a’,... |
Jun 14, 2008 1:07:00 PM |
|
5
|
Limit [while|until] expression
Limit [while|until] expression Performing sequential operations on set is a bitch, but this might help. The MySQL extension ‘limit’ … Select * from budget_candidates order by priority limit while sum(cost)1000.00 |
Jun 13, 2008 12:51:00 PM |
|
6
|
This website is based on Pebble
I've been thinking about creating a website like this for years, but I never go around to it. I'm a programmer so if I want something done by a computer my natural reaction is to program it myself -- which is why I never got around to making this site. ... |
Jun 1, 2008 8:51:00 PM |