r937
SQL Consultant
Devshed Supreme Being (6500+ posts)
- Join Date
- February 25th, 2003
- Last Activity
- Today 06:46 AM
Recent Visitors
- BinochinoA133,
- brown71576,
- jonh85711,
- khaiminh1407,
- MrFujin,
- namviet382,
- nghiatm2411,
- uuvancuong,
- vattugiatot24,
- VatTuTot14
-
Older Activity
-
r937 replied to a thread jaccard index query optimization [Related Items based on tags] in MySQL Helpthanks i thought i knew EXPLAINs fairly well, but this one is a bit beyond me, sorry i can see what you're trying to do, though, and i'm not...February 27th, 2015, 08:52 PM6 replies | 272 view(s)
-
always test your query directly in the database, i.e. not via your VB program you have bad sql syntax, you need to fix that first also, you...February 27th, 2015, 04:18 PM2 replies | 229 view(s)
-
r937 replied to a thread jaccard index query optimization [Related Items based on tags] in MySQL Helpanother set of eyes cannot see which indexes you've declared, nor the EXPLAIN for your queryFebruary 27th, 2015, 04:14 PM6 replies | 272 view(s)
-
SELECT DISTINCT c.clientid FROM clients AS c LEFT OUTER JOIN services AS s ON s.clientid = c.clientid WHERE '1st' IN...February 27th, 2015, 01:27 PM2 replies | 101 view(s)
-
i don't understand how it can use a filesort without using temporary otherwise, they look equivalentFebruary 24th, 2015, 07:36 PM4 replies | 188 view(s)
-
it works, and technically it's okay because the missing GROUP BY clause defaults to one large group for the entire result set, but i don't like it ...February 24th, 2015, 04:59 PM4 replies | 188 view(s)
-
looks okay to me too (but i've never needed to create a procedure) have you tried to do it without the variables? INSERT INTO Listings ...February 24th, 2015, 02:43 PM1 replies | 112 view(s)
-
if you recall, i did ask you (post #4) which table Complete was in, and your answer (post #5) didn't mention it, so... also, there's no point in...February 20th, 2015, 04:27 PM11 replies | 396 view(s)
-
in that case would you please dump the tables and provide the CREATE TABLE statements along with a couple dozen INSERT statements so that i can try...February 20th, 2015, 01:14 AM11 replies | 396 view(s)
-
SELECT ph.pname , pi.schtm AS earliest , pi.patname , pi.patid , pi.status FROM physicians AS ph INNER JOIN ( SELECT...February 19th, 2015, 04:59 PM11 replies | 396 view(s)
-
that's an important bit of info please, what table are Complete and PID in? SELECT ph.pname , pi.schtm AS earliest ,...February 19th, 2015, 04:48 PM11 replies | 396 view(s)
-
SELECT users.user_number , users.user_level , users.web_username , login_attempts.host_ip , login_attempts.host_name ,...February 18th, 2015, 09:10 PM2 replies | 200 view(s)
-
dear bobert, if you could go ahead and give us the layout and contents of table1, that'd be greatFebruary 18th, 2015, 09:10 AM6 replies | 303 view(s)
-
presumably the $from and $to values are the availability range you are looking for, looking to find an available room please review the threads i...February 16th, 2015, 09:41 AM3 replies | 174 view(s)
-
see Filtering on startdate and enddate question 2 date ranges. Calculate overlapping time?February 16th, 2015, 07:52 AM3 replies | 174 view(s)
-
look, i understand what is happening might be confusing to you, but you have posted half a dozen different threads on the same problem the...February 16th, 2015, 07:45 AM8 replies | 481 view(s)
-
you can only use the WHERE keyword once, you used it twice (the error occurred exactly where the error message says to look -- "AND where") you...February 15th, 2015, 07:41 PM1 replies | 140 view(s)
-
i just thought i should point out that this particular subquery is poorly designed because the result is always going to be 'au' look at the WHERE...February 14th, 2015, 09:36 AM2 replies | 160 view(s)
-
okay, so you actually ~are~ using NULL in the middle initial if it's missing? that's excellent, sir! SELECT CONCAT_WS('...February 13th, 2015, 04:35 PM4 replies | 201 view(s)
-
conditionally based on what? if the middle initial exists? that would imply it's sometimes NULL, but if that's true, then you would have asked a...February 13th, 2015, 03:59 PM4 replies | 201 view(s)
-
read up on the GROUP_CONCAT function it produces a string of comma-separated values in your case, an example of this string would be 'ice...February 13th, 2015, 01:49 PM5 replies | 341 view(s)
-
okay, try this -- SELECT CASE WHEN GROUP_CONCAT(Item) LIKE '%Hotdog%' THEN 'Yes' ELSE 'No' END AS result FROM ( SELECT...February 13th, 2015, 09:43 AM5 replies | 341 view(s)
-
the error has sort of already been described -- "I have tried the last two syntaxes but each of them errors by not finding the pacient or p.id...February 12th, 2015, 07:22 AM8 replies | 360 view(s)
-
February 12th, 2015, 06:10 AM8 replies | 360 view(s)
-
please do a SHOW CREATE TABLE for all tables involved in your failed INSERT statements -- after, of course, all the ALTER TABLE statementsFebruary 11th, 2015, 05:32 PM8 replies | 360 view(s)
-
load all your data into a "landing" table (a permanent table that receives all rows) then do an INSERT SELECT into your target table, using the...February 11th, 2015, 11:44 AM2 replies | 220 view(s)
-
run your query outside of php, in order to see the real error message your query has syntax errors -- table name St-George contains a special...February 7th, 2015, 06:13 AM2 replies | 378 view(s)
-
SELECT orders.orders_id FROM orders INNER JOIN orders_products ON orders_products.orders_id =orders.orders_id GROUP BY...February 4th, 2015, 04:37 AM2 replies | 321 view(s)
-
okay, so it looks like you can't do it that way i had to go look up the syntax, took me two seconds with google try it like this -- SELECT...February 4th, 2015, 04:31 AM4 replies | 264 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 424098 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
Help with checking a field but only the last 5 entries.
February 18th, 201508:39 PMUser / Points
You recieved 12 fromComment
thanks for the help -
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!
