meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 6 months |
| seen | Dec 13 '12 at 16:58 | |
| stats | profile views | 9 |
this site sux little bit in my opinion
|
Dec 5 |
answered | Why do people use MySQL while it has no INTERSECT? |
|
Dec 4 |
revised |
High insert rate on MySQL deleted 26 characters in body |
|
Dec 4 |
answered | High insert rate on MySQL |
|
Dec 3 |
comment |
Dynamically Converted rows into columns (Pivoting) I'm not sure If I understood your question correctly but you want to get rating of each staff member as one separate row with columns for rating on each criteria (question)? |
|
Dec 2 |
comment |
Use of CASE statement in a MySQL query @a1ex07 I used 'may' because you need larger number of record to see performance issues. Your query will at the certain point cause performance problems but it may work depending on the use case. With 10,000 projects and 500,000 tasks your query is unusable my is taking 0.05s With 1,000 projects and 5,000 tasks your query is taking 0.9s mine 0.02s. Instead of defending your solution because it is yours try using this forum to learn something new. |
|
Dec 2 |
revised |
Use of CASE statement in a MySQL query deleted 24 characters in body |
|
Dec 2 |
revised |
Use of CASE statement in a MySQL query added 3 characters in body |
|
Dec 2 |
revised |
Use of CASE statement in a MySQL query added 15 characters in body |
|
Dec 1 |
comment |
Use of CASE statement in a MySQL query @a1ex07 It proves that "Your solution may cause performance problems if there will be larger number of records" |
|
Dec 1 |
comment |
Use of CASE statement in a MySQL query @a1ex07 It will use index on (SELECT DISTINCT id_task FROM PROJECT_HAS_TASK) but will not use index on the join statement. Try building those tables and checking EXPLAIN on both statements yours will require three operations and on one there will be no index used. |
|
Nov 29 |
answered | Use of CASE statement in a MySQL query |
|
Nov 28 |
comment |
how to retrieve rows of different dates using IN clause @RolandoMySQLDBA How do you find the time to write all those very useful and very detailed answers? kudos |
|
Nov 27 |
revised |
Resolving DUPLICATE for a column with UNIQUE misspelled user name |
|
Nov 27 |
answered | Update field with new string made from characters in existing value |
|
Nov 27 |
revised |
Resolving DUPLICATE for a column with UNIQUE added 1 characters in body |
|
Nov 26 |
comment |
Resolving DUPLICATE for a column with UNIQUE Use stored procedure which will check if given value already exists and in such case will return updated value so it will be something like ... ON DUPLICATE KEY UPDATE title = myTitleChecker(VALUES(title)), abr = myAbrChecker(VALUES(abr)), myNameChecker(VALUES(name)); |
|
Nov 26 |
awarded | Editor |
|
Nov 26 |
revised |
Resolving DUPLICATE for a column with UNIQUE deleted 4 characters in body |
|
Nov 26 |
awarded | Supporter |
|
Nov 26 |
answered | Resolving DUPLICATE for a column with UNIQUE |
