Reputation
295
Top tag
Next privilege 300 Rep.
Create new tags
Badges
3 14
Impact
~15k people reached

  • 0 posts edited
  • 0 helpful flags
  • 19 votes cast
Jan
18
awarded  Notable Question
Nov
3
asked Two ways to define may-have-a (1..0-1) relationship
Nov
3
awarded  Informed
Oct
6
comment Fetching from parent/child table pairs
The first variant however has the advantage that we don't need to load all data into memory.
Oct
6
asked Fetching from parent/child table pairs
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
REqTime -> ReqTime
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?