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

  • 0 posts edited
  • 0 helpful flags
  • 19 votes cast
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
11
revised Storing IDs of strings instead of strings?
edited tags
Jul
11
asked Storing IDs of strings instead of strings?
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
Jun
24
accepted Should I create a multi-column UNIQUE index?