265 reputation
211
bio website portonvictor.org
location
age
visits member for 2 years, 9 months
seen Sep 2 at 13:18

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?
Jun
23
asked Should I create a multi-column UNIQUE index?
Feb
12
awarded  Popular Question
Nov
11
accepted Sorting by a field in child table
Nov
11
comment Sorting by a field in child table
The output looks sensible. I will gaze at your code to decide whether it is correct