network profile
| bio | website | portonvictor.org |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 5 months |
| seen | May 13 at 14:51 | |
| stats | profile views | 5 |
|
May 13 |
asked | A separate table or ENUM? |
|
Apr 25 |
comment |
Default values for a table, how to refactor? @Colin'tHart: the payment rates are different for lessons for several pupils and "individual" lessons for only one pupil at the same time. |
|
Apr 25 |
asked | Default values for a table, how to refactor? |
|
Apr 25 |
asked | best relationship for this design? |
|
Apr 25 |
accepted | Which of tables key to reference? |
|
Apr 25 |
asked | Which of tables key to reference? |
|
Apr 23 |
comment |
A query for a latest version of data I edited my question to make clear that we want only data of a given kind. |
|
Apr 23 |
revised |
A query for a latest version of data of given kind |
|
Apr 23 |
awarded | Commentator |
|
Apr 23 |
comment |
A query for a latest version of data Your code does not restrict query only to fields with a specified kind. Please rewrite the query. I suppose that rewriting it in the most trivial way would make it inefficient. Probably we should use LIMIT 1 instead? |
|
Apr 23 |
asked | A query for a latest version of data |
|
Mar 6 |
awarded | Yearling |
|
Mar 6 |
accepted | Sequential joining of tables in order |
|
Mar 6 |
comment |
Sequential joining of tables in order There is table bunches. I just haven't said it explicitly |
|
Mar 6 |
asked | Sequential joining of tables in order |
|
Mar 5 |
comment |
Two dichotomy views of a table, and means to express this as a stored procudure? Hm, is it worth to create these two dichotomy views? Maybe instead I should create just one view which has calculated archived flag? Then I may query it with WHERE archive or WHERE NOT(archive) |
|
Mar 5 |
asked | Two dichotomy views of a table, and means to express this as a stored procudure? |
|
Mar 4 |
awarded | Critic |
|
Mar 4 |
revised |
Refer to a table with all rows or to the table which restricts allowed rows? added 50 characters in body |
|
Mar 4 |
asked | Refer to a table with all rows or to the table which restricts allowed rows? |
