Reputation
280
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 13
Newest
 Curious
Impact
~12k people reached

  • 0 posts edited
  • 0 helpful flags
  • 19 votes cast
Jun
7
comment Is LIMIT processed before or after retrieving data?
@zgguy I've read the docs you suggested. Docs say that it does some additional optimization in some cases. But it is not said explicitly whether it does optimization in other cases (not described in the docs). Should I assume that in the cases not covered by the docs no optimization is done?
Jun
7
asked When rows of a resultset are generated?
Jun
7
asked Is LIMIT processed before or after retrieving data?
Mar
20
awarded  Curious
Oct
7
awarded  Popular Question
Oct
3
comment Updating a table with a single UPDATE statement vs several UPDATE statements
This is an argument, but it does not resolve my problem. Neither performance nor consistency of the data are issues for this project.
Oct
3
asked Updating a table with a single UPDATE statement vs several UPDATE statements
Sep
15
awarded  Notable Question
Sep
4
awarded  Popular Question
Sep
1
comment Difference data between adjacent rows
#1093 - You can't specify target table 'R' for update in FROM clause
Sep
1
comment #1093 - You can't specify target table 'R' for update in FROM clause
Why we join with Visits N whilst N is not used in this code? How we can set Duration with SET Duration = ... without specifying whether we set Duration for R or for N?
Sep
1
comment #1093 - You can't specify target table 'R' for update in FROM clause
REqTime -> ReqTime
Sep
1
comment #1093 - You can't specify target table 'R' for update in FROM clause
#1054 - Unknown column 'R.ID' in 'where clause'
Sep
1
asked #1093 - You can't specify target table 'R' for update in FROM clause
Aug
31
asked Difference data between adjacent rows
Jul
18
awarded  Tumbleweed
Jul
6
asked Store both a city and its region?
Jul
4
revised Performance: Interleaving several statement handles in MySQL
edited body
Jul
4
revised Performance: Interleaving several statement handles in MySQL
English grammar
Jul
4
asked Performance: Interleaving several statement handles in MySQL