Reputation
413
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 8 19
Impact
~47k people reached

  • 0 posts edited
  • 0 helpful flags
  • 94 votes cast
1d
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.
Dec
9
accepted Cannot ALTER TABLE
Dec
9
comment Cannot ALTER TABLE
@Michael-sqlbot: Thank you. I understand that rebooting an EC2 instance does move it, so I assumed that is valid for RDS as well.
Dec
8
comment Cannot ALTER TABLE
Yes, I think so too. However the console shows that there is space. I've now filed an issue with Amazon support.
Dec
8
comment Cannot ALTER TABLE
Thank you, in fact I did try this. I could make the new table, but in populating it I get the error he table 'replacement_tasks' is full.