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

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
Oct
7
asked One or two tables (for two things: cancellations and moves)?
Oct
4
accepted Extract data for all groups in a single SELECT statement
Oct
4
comment Extract data for all groups in a single SELECT statement
@ypercube: that UN means unsigned. There is a unique index for the pair groupid, startdate. There are no other unique constraints (not counting the primary key for ID)