Reputation
445
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 9 21
Impact
~74k people reached

  • 0 posts edited
  • 0 helpful flags
  • 99 votes cast
Jan
8
awarded  Nice Question
Nov
28
accepted Cannot configure nor start MySQL
Nov
3
awarded  Notable Question
Aug
20
awarded  Autobiographer
Aug
2
awarded  Famous Question
Jun
9
awarded  Custodian
Jun
9
reviewed Approve Cannot output MySQL data to file
Jun
9
awarded  Yearling
Apr
17
awarded  Popular Question
Feb
24
awarded  Famous Question
Feb
15
awarded  Critic
Feb
10
comment Will a covering index save a table hit if only the commoly-used length of a `text` field is indexed?
Thank you Rick. In fact this is an InnoDB table (probably Antelope).
Jan
26
asked Will a covering index save a table hit if only the commoly-used length of a `text` field is indexed?
Jan
26
accepted Reusing covering index for fields in FROM, from another query's index
Jan
26
asked Reusing covering index for fields in FROM, from another query's index
Jan
12
awarded  Notable Question
Jan
12
awarded  Notable Question
Dec
20
comment Why do we use Group by 1 and Group by 1,2,3 in SQL query?
Use order by 1 only when sitting at the mysql> prompt. In code, use ORDER BY id ASC. Note the case, explicit field name, and explicit ordering direction.
Dec
10
awarded  Notable Question
Dec
9
comment Cannot ALTER TABLE
Sure enough, the issue was disk space. Thanks.