186 reputation
3
bio website
location
age
visits member for 1 year, 5 months
seen Dec 13 '12 at 16:58

this site sux little bit in my opinion


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
Nov
19
awarded  Teacher