255 reputation
110
bio website portonvictor.org
location
age
visits member for 2 years, 7 months
seen Jul 11 at 14:52

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
Nov
11
comment Sorting by a field in child table
MAX(day) is wrong in every setting. Well, I have asked this question in the hope that it can be calculated using joins. It seems not the case and I will manage to solve it with subqueries myself.
Nov
11
comment Sorting by a field in child table
No, I want to see the unique value day for the contract update with greatest startdate (having fixed a contract ID). And so for every contract ID.
Nov
11
comment Sorting by a field in child table
No, output is wrong. It should provide only one ID per contract
Nov
11
comment Sorting by a field in child table
@RolandoMySQLDBA: It is not relevant to my question what is day. Well, I'll answer your question: day: 1..28 is the day of month, in every month at every day with this number a payment should be made
Nov
11
comment Sorting by a field in child table
@RolandoMySQLDBA: No, no such equality
Nov
11
asked Sorting by a field in child table
Oct
7
accepted One or two tables (for two things: cancellations and moves)?
Oct
7
revised One or two tables (for two things: cancellations and moves)?
added 27 characters in body