265 reputation
212
bio website portonvictor.org
location
age
visits member for 3 years
seen Nov 19 at 18:36

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?
Jun
23
asked Should I create a multi-column UNIQUE index?