r937
SQL Consultant
Devshed Supreme Being (6500+ posts)
- Join Date
- February 25th, 2003
- Last Activity
- Yesterday 06:12 PM
Recent Visitors
- BinochinoA133,
- jonh85711,
- khaiminh1407,
- MrFujin,
- namviet382,
- nghiatm2411,
- tobishop1990,
- uuvancuong,
- vattugiatot24,
- VatTuTot14
-
Older Activity
-
interesting thought i guess intuitivity is relative to one's predispositions and/or experiences shouldn't both queries in theory have the same...Yesterday, 03:54 PM2 replies | 50 view(s)
-
pretty sure you can but if you're good to go, then okay :)January 21st, 2015, 01:45 PM13 replies | 391 view(s)
-
r937 replied to a thread Why does this query take so long to run? Mysql says Query took 0.0058 sec! in MySQL Helpseeing as how OP posted a screengrab of phpmyadmin -- at least, that's what it looks like to me-- then i'm gonna go with yesJanuary 20th, 2015, 09:40 AM4 replies | 224 view(s)
-
r937 replied to a thread Why does this query take so long to run? Mysql says Query took 0.0058 sec! in MySQL Helpwhy do you have a DATETIME column with the time portion set to 00:00:00, as well as an INTEGER column containing an actual unix datetime value? as...January 20th, 2015, 04:55 AM4 replies | 224 view(s)
-
sorry, i cannot help you, maybe someone else never used table designer i'll guess, though, that perhaps the word CHECK is not needed?January 19th, 2015, 05:14 PM13 replies | 391 view(s)
-
i'm sorry, i do not understand "not happy" please show entire CREATE TABLE statement and the accompanying error messageJanuary 19th, 2015, 02:02 PM13 replies | 391 view(s)
-
use CHAR(1) and declare a CHECK CONSTRAINTJanuary 18th, 2015, 12:39 PM13 replies | 391 view(s)
-
this is obviously a homework question, and as such, we won't just simply provide a solution what have you tried? show us your thinking processJanuary 16th, 2015, 05:08 AM1 replies | 136 view(s)
-
if you join classes to both scheduled_classes and waitlist, you will end up with partial cross join effects so... no, the correlated subqueries...January 14th, 2015, 10:40 AM8 replies | 201 view(s)
-
also, the second last WHERE condition makes the last one redundantJanuary 14th, 2015, 09:53 AM8 replies | 201 view(s)
-
i am working on a solution but it will be a while longerJanuary 12th, 2015, 11:51 AM40 replies | 531 view(s)
-
this is a brilliant answer and i need to think on it for a momentJanuary 11th, 2015, 04:51 PM40 replies | 531 view(s)
-
it's not a problem, but the query will have to have 4 self-left-outer-joinsJanuary 11th, 2015, 02:31 PM40 replies | 531 view(s)
-
thanks for the sample data, but, and please don't take this the wrong way, i coulda made that up too you see, i am still confused, because the...January 11th, 2015, 11:07 AM40 replies | 531 view(s)
-
also, where did columns f1 and f2 come from?January 10th, 2015, 06:25 PM40 replies | 531 view(s)
-
i cannot look at the query until i see actual sample data in several rows in both tablesJanuary 10th, 2015, 06:23 PM40 replies | 531 view(s)
-
- The columns of ft_req do not have to be NOT NULL, as you mention. I simply need to enter a value between 0 and 1115 in each field. what does the...January 10th, 2015, 05:47 PM40 replies | 531 view(s)
-
those would be two separate queries the first is easier -- SELECT f.id , f.name FROM feats_g AS f LEFT OUTER JOIN pcfeats AS p ...January 10th, 2015, 04:46 PM40 replies | 531 view(s)
-
SELECT p.employee_number , p.role_comp_emp_final_rating , emp.lov_text_en AS emp_final , p.role_comp_lm_final_rating ,...January 6th, 2015, 04:36 AM1 replies | 136 view(s)
-
excellent... because that's exactly what you need to get "one row per item with tags as a string"January 5th, 2015, 04:21 PM14 replies | 465 view(s)
-
did you look up the GROUP_CONCAT function?January 5th, 2015, 02:21 AM14 replies | 465 view(s)
-
no, i'm not suggesting that here is what i'm suggesting -- CREATE TABLE items ( itemid INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT , title ...January 4th, 2015, 04:51 AM14 replies | 465 view(s)
-
think it through... there'd be the same number of tables, but there would be one fewer join on retrieval the foreign keys would still exist...January 3rd, 2015, 06:57 AM14 replies | 465 view(s)
-
as i suggested on, ahem, another forum, you shopuld look up the GROUP_CONCAT functionJanuary 3rd, 2015, 06:55 AM14 replies | 465 view(s)
-
i agree, except that in the item_tags table, i would use the tag itself, and not an id for the tagJanuary 3rd, 2015, 06:21 AM14 replies | 465 view(s)
Latest Reputation Given
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
closest join
July 24th, 201403:14 PMUser / Points
You gave 3937 toComment
3000 bonus points for xaprb link -
Thread / Date
Query help
August 24th, 201304:09 AMUser / Points
You gave 0 toComment
i would have expected some kind of suggestion for a new data model and not just the usual diatribe/rant about what's wrong with the current one -
Thread / Date
Display 2 queries in the same table?
November 6th, 201208:56 PMUser / Points
You gave 937 toComment
thanks for taking the time to give examples! very helpful for new developers -
Thread / Date
Update first X rows?
August 21st, 201210:29 PMUser / Points
You gave 937 toComment
what dan said -
Thread / Date
Putting condition in ON clause or WHERE clause
August 17th, 201210:18 AMUser / Points
You gave 937 toComment
very nicely explained, great tutorial -
Thread / Date
Trying to get a count of certain records - PHP/MYSQL
January 13th, 201203:04 PMUser / Points
You gave 937 toComment
nice explanation, guelphdad
-
Thread / Date
Problem with slow query
October 18th, 201104:47 PMUser / Points
You gave 2937 toComment
stefan is my tuning hero
-
Thread / Date
Complicated table join question.
September 15th, 201109:29 AMUser / Points
You gave 937 toComment
sweet
-
Thread / Date
Help with a query
June 5th, 201109:21 AMUser / Points
You gave 2937 toComment
lol
-
Thread / Date
Urgent help Find Replace Query
June 21st, 201010:36 AMUser / Points
You gave 937 toComment
nicely explained
Latest Reputation Received 424086 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
MySQL returning zeros
November 19th, 201406:01 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
MySQL returning zeros
November 11th, 201408:32 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
My Sql Remove everything after the first word
October 20th, 201407:42 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
combine 2 mysql
October 20th, 201407:25 AMUser / Points
You recieved 3 fromComment
No Comment Made -
Thread / Date
LEFT OUTER JOIN or UNION?
September 8th, 201409:02 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
A million tables in a database?
August 31st, 201404:42 PMUser / Points
You recieved 535 fromComment
Totally and completely agree! -
Thread / Date
Case Statement On Thread
July 28th, 201409:21 AMUser / Points
You recieved 4 fromComment
No Comment Made -
Thread / Date
duplicate row in inner join
July 13th, 201409:34 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
double SUM
June 12th, 201407:24 AMUser / Points
You recieved 0 fromComment
Sniped!
-
Thread / Date
Select distinct column when all criteria from another column are met/found
May 12th, 201402:12 PMUser / Points
You recieved 6351 fromComment
haven't repped you in a while, and it's good to encourage the newbies who make the right calls.
