r937
SQL Consultant
Devshed Supreme Being (6500+ posts)
- Join Date
- February 25th, 2003
- Last Activity
- Today 03:44 AM
-
Older Activity
-
your php variables need to be enclosed in single quotesYesterday, 11:04 AM3 replies | 83 view(s)
-
that question is more appropriate for the php forum, not mysqlJuly 28th, 2014, 08:12 AM6 replies | 171 view(s)
-
if you do not want to change the design of the table, you could do the translation of numbers into text in phpJuly 28th, 2014, 04:58 AM6 replies | 171 view(s)
-
you've already decided on the solution, so why are you asking us?July 27th, 2014, 05:29 PM10 replies | 183 view(s)
-
sorry, not familiar with the "without any luck" error message could you describe what actually happened? hint: check the manual for syntax......July 27th, 2014, 11:24 AM1 replies | 64 view(s)
-
you cannot say "equals null" -- nothing is equal to null, not even another null you have to say IS NULLJuly 27th, 2014, 11:18 AM1 replies | 85 view(s)
-
SELECT t.TopicName , DATE_FORMAT(t.TopicActiveDate, '%M-%d-%Y') AS ActiveDate , COALESCE(m.msg_count,0) AS msg_count ,...July 25th, 2014, 10:52 AM4 replies | 185 view(s)
-
this is really tough... you've violated First Normal Form and are now reaping the benefits perhaps the easiest would be to do the translation in...July 25th, 2014, 08:59 AM6 replies | 171 view(s)
-
please start by reviewing this thread ==> 2 date ranges. Calculate overlapping time? apply the formula to your situation and let us know how it...July 25th, 2014, 05:00 AM2 replies | 98 view(s)
-
please show how the three tables are related (primary and foreign keys)July 25th, 2014, 04:54 AM4 replies | 185 view(s)
-
push grouping into subquery derived table in FROM clause versus correlated subquery in SELECT clause -- only a comparison of the EXPLAINs will decide...July 24th, 2014, 08:10 PM3 replies | 122 view(s)
-
July 24th, 2014, 05:20 PM3 replies | 135 view(s)
-
this would be where you use a subquery to pre-collapse one of the 1-to-many relationships, so that they don't "cross join" with the other oneJuly 24th, 2014, 05:18 PM3 replies | 122 view(s)
-
okay, sorry for the confusion TL;DR -- aliases are required in the FROM clause, recommended as hell in the SELECT clause you will smile when...July 24th, 2014, 09:56 AM5 replies | 128 view(s)
-
i think your counts in that query will be largely wrong :)July 24th, 2014, 09:11 AM5 replies | 128 view(s)
-
some pointers here ==> https://www.google.ca/?gws_rd=ssl#q=site:forums.devshed.com+joining+to+the+same+table+twiceJuly 24th, 2014, 08:44 AM5 replies | 128 view(s)
-
please show the original "very heavy" query, along with an EXPLAIN on itJuly 24th, 2014, 06:28 AM10 replies | 183 view(s)
-
no i fully expect them to i've just learned to always consider every possibility :) execution time is easy, just run them (remembering to...July 24th, 2014, 04:08 AM5 replies | 157 view(s)
-
why wouldn't 456789 match 4567890454? why wouldn't 456789 match 456? why wouldn't 90 also match 4567890454?July 24th, 2014, 04:06 AM11 replies | 218 view(s)
-
both look okay to me, but i'm not really a DBA how does execution time compare? oh, and do they actually produce the same results?July 23rd, 2014, 05:49 PM5 replies | 157 view(s)
-
i'm pretty sure this was a typo --ON set.bjt_id=set.id have you tried doing it the normal way? SELECT bet.* , set.otherColumn FROM...July 23rd, 2014, 11:37 AM5 replies | 157 view(s)
-
could you show us some represenative strings in both tables please, some that will match and some that won't having a hard time figuring out what...July 23rd, 2014, 11:32 AM11 replies | 218 view(s)
-
sorry, we do not do homework assignments on this siteJuly 19th, 2014, 03:16 PM1 replies | 160 view(s)
-
so, what indexes have you created? presumably that will work however, you don't need code in the SELECT clause because you already know what...July 19th, 2014, 03:14 PM3 replies | 169 view(s)
-
July 19th, 2014, 01:59 PM3 replies | 169 view(s)
-
July 19th, 2014, 01:58 PM2 replies | 161 view(s)
-
you have two one-to-many relationships in the same query, so of course the results will multiply, producing what i call "cross join effects" you...July 13th, 2014, 06:39 AM2 replies | 292 view(s)
-
if there were three tables -- players, dates, and player_dates -- then your table would be player_dates, the "association" or "relationship" or...July 13th, 2014, 06:33 AM1 replies | 238 view(s)
-
works for me... and to mitigate the space issue, you might limit it to 3 characters a hierarchy of access rights is pretty hard to implement...July 8th, 2014, 12:36 PM10 replies | 396 view(s)
-
i would typically start with the "natural" key (put in quotes because an abbreviated name that needs a fuller description in a separate table...July 7th, 2014, 08:04 PM10 replies | 396 view(s)
Latest Reputation Given
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
closest join
July 24th, 201402:14 PMUser / Points
You gave 3937 toComment
3000 bonus points for xaprb link -
Thread / Date
Query help
August 24th, 201303: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, 201207: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, 201209:29 PMUser / Points
You gave 937 toComment
what dan said -
Thread / Date
Putting condition in ON clause or WHERE clause
August 17th, 201209: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, 201202:04 PMUser / Points
You gave 937 toComment
nice explanation, guelphdad
-
Thread / Date
Problem with slow query
October 18th, 201103:47 PMUser / Points
You gave 2937 toComment
stefan is my tuning hero
-
Thread / Date
Complicated table join question.
September 15th, 201108:29 AMUser / Points
You gave 937 toComment
sweet
-
Thread / Date
Help with a query
June 5th, 201108:21 AMUser / Points
You gave 2937 toComment
lol
-
Thread / Date
Urgent help Find Replace Query
June 21st, 201009:36 AMUser / Points
You gave 937 toComment
nicely explained
Latest Reputation Received 423548 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
Case Statement On Thread
July 28th, 201408:21 AMUser / Points
You recieved 4 fromComment
No Comment Made -
Thread / Date
duplicate row in inner join
July 13th, 201408:34 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
double SUM
June 12th, 201406:24 AMUser / Points
You recieved 0 fromComment
Sniped!
-
Thread / Date
Select distinct column when all criteria from another column are met/found
May 12th, 201401: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. -
Thread / Date
Selecting fields from two tables
March 5th, 201405:22 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Query help - Head-To-Head Win/Loss Record
March 1st, 201408:57 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Query help - Head-To-Head Win/Loss Record
March 1st, 201408:52 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Left join weekdays and time interval
February 26th, 201402:51 PMUser / Points
You recieved 10 fromComment
No Comment Made -
Thread / Date
Query for multiple date ranges at the same time
February 13th, 201407:30 AMUser / Points
You recieved 3 fromComment
No Comment Made -
Thread / Date
Using Multiple Selects in One Query
January 15th, 201411:16 AMUser / Points
You recieved 5 fromComment
Wow! Now that is a query!
