Search results
"tag:mysql"
| Title and summary | Date/time | |
|---|---|---|
|
1
|
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 |
|
2
|
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 |
|
3
|
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 |
|
4
|
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 |