8,825 reputation
1923
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 11 months
seen yesterday

If you question or otherwise fail to recognize the superiority of the relational model... you're doing it wrong.


Jul
23
revised Auto-increment ids with multiple inserts in mysql/mariadb
how many "rows" (not columns) was (afaik) the intended meaning
Apr
23
revised “Display width out of range for column” error when importing mysql 5.1 dump into 5.5
clarification
Apr
2
revised Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes
added query-cache tag
Jan
23
revised How can I set a field when original lookup is NULL or isn't in the list?
CASE needed to result in a valid column name since this is CREATE TABLE...SELECT
Jan
17
revised MySQL/MariaDB stored procedure inserts even with syntax error
clarify more
Jan
16
revised Autoincrement primary key in CREATE TABLE … AS SELECT
typo fix, add word
Dec
21
revised RMAN backup copy - read once and write many?
cleanup, clarify, and format
Dec
6
revised Warning before issuing delete/update command in mysql/oracle , then executes
flehhh coherent sentences are good.
Dec
5
revised Determining what algorithm MYSQL View is using
add last line
Nov
28
revised Group by clause giving temporary and filesort
clean up formatting
Nov
27
revised How To Update Random ID to a table in mysql?
add is null test from comments
Nov
15
revised Amazon RDS for MySQL vs installing MySQL on an Amazon EC2 instance
new information to reflect the current state of RDS
Nov
9
revised Make MySQL server terminate when shell exits or on ctrl-c
clarify
Oct
22
revised How to “warm up” a cold DB server?
add a missing word and some italics; fix spacing
Oct
22
revised Slow query responce on different mysql versions, percona, MariaDB
add "logically" ... the two queries are not "logically" equivalent
Oct
20
revised RegEx with update query my sql
user-suggested edit; the fact that quotes are required if the values are literals should be obvious but I've made the suggested change; also I've changed the 2nd column name since it's not afaik a regex
Oct
17
revised Query an intermediate table and join to child table
update to address comment.
Oct
8
revised mysql's query cache behaviour on LIMIT
fix example to match question
Oct
8
revised mysql's query cache behaviour on LIMIT
add tag "mysql" -- question and answer applies to essentially all versions
Oct
8
revised mysql's query cache behaviour on LIMIT
clarified the wording of the question