r937
SQL Consultant
Devshed Supreme Being (6500+ posts)
- Join Date
- February 25th, 2003
- Last Activity
- Today 02:03 AM
Basic Information
- Location:
- Toronto Canada
- Occupation:
- freelance SQL consulting
Signature
Statistics
Posts
- Total Posts
- 26,984
- Posts Per Day
- 6.69
General Information
- Last Activity
- Today 02:03 AM
- Join Date
- February 25th, 2003
-
Older Activity
-
at the point shammat posted, it most certainly was not clear that you were aware of the mysql manual now that you admit you've read it, what...March 8th, 2014, 06:32 PM6 replies | 108 view(s)
-
March 8th, 2014, 05:21 PM6 replies | 108 view(s)
-
FYI using "date +1" and "date - 1" is asking for trouble, especially in cases like this, where there's a good chance the date is stored as some kind...March 5th, 2014, 06:42 PM2 replies | 144 view(s)
-
not to be overly critical, but is google broken for you? do a search for "basic mysql tutorial"March 5th, 2014, 04:12 PM1 replies | 105 view(s)
-
it's a dead-simple join you really should take a few moments and learn about joins meanwhile, here's a good example to work from -- SELECT...March 5th, 2014, 04:11 PM3 replies | 197 view(s)
-
there other ways, not necessarily better, but i am familiar with none of them a few thousand rows will return good results, so that can't be your...March 3rd, 2014, 07:07 PM4 replies | 170 view(s)
-
fulltext results are unpredictable when there aren't enough rows in the table could that be it?March 3rd, 2014, 05:25 AM4 replies | 170 view(s)
-
i have no idea, i've never used joomlaMarch 2nd, 2014, 04:32 PM4 replies | 147 view(s)
-
create a new table, with a column called "position" as an auto_increment primary key, and then the other columns then INSERT INTO newtable (list...March 2nd, 2014, 03:27 PM4 replies | 147 view(s)
-
good guess it's the HAVING clauseMarch 1st, 2014, 08:21 PM5 replies | 200 view(s)
-
sure SELECT something , anything , just_not_the_dreaded_evil_select_star FROM driver AS d INNER JOIN card_driver AS cd ON...February 28th, 2014, 11:56 AM6 replies | 170 view(s)
-
oh, wait... "Not actually part of the table"February 28th, 2014, 11:25 AM6 replies | 170 view(s)
-
how come your list of columns doesn't match the columns in the CREATE statements?February 28th, 2014, 11:24 AM6 replies | 170 view(s)
-
these examples are easy to construct SELECT classroom , MAX(student_marks) AS highest_mark , student_last_name FROM classes GROUP ...February 28th, 2014, 11:22 AM12 replies | 223 view(s)
-
because of the joins to different tables, i'd say you're outta luck too bad you have those similarly named columns (item2, item3, item4, item5)...February 28th, 2014, 10:12 AM6 replies | 187 view(s)
-
you should use explicit joins SELECT something , anything , just_not_the_dreaded_evil_select_star FROM table1 INNER JOIN table2...February 28th, 2014, 08:45 AM1 replies | 123 view(s)
-
what simon said... - d table missing - ct table missing - compound index may help i'd like to add... - applying a function like FIND_IN_SET...February 28th, 2014, 08:41 AM12 replies | 223 view(s)
-
yeah, it does, but it doesn't tell me anything substantial that i can go on any chance you could flesh out the query skeleton you posted with the...February 28th, 2014, 08:37 AM6 replies | 187 view(s)
-
i think you should also show the query that this EXPLAIN is for, along with the results of the SHOW CREATE TABLEs for your tables id select_type ...February 28th, 2014, 05:14 AM12 replies | 223 view(s)
-
not with that syntax, no but perhaps if you could explain what those subqueries are supposed to do, we could find a way to make it possibleFebruary 28th, 2014, 05:10 AM6 replies | 187 view(s)
-
use a self-join --SELECT one.PlayerID , two.PlayerID , SUM(CASE WHEN one.Score > two.Score THEN 1 ELSE NULL END) AS W , SUM(CASE...February 28th, 2014, 05:08 AM5 replies | 200 view(s)
-
thanks to you for sticking with me, and not giving up :)February 27th, 2014, 04:19 PM34 replies | 406 view(s)
-
sheeeeeeeeeeeeeeit, man back to the manual :) look up INSERT with the ON DUPLICATE KEY UPDATE optionFebruary 27th, 2014, 10:04 AM34 replies | 406 view(s)
-
may i suggest that you will undoubtedly waste a lot more time trying other people's forum suggestions than you would if you actually took a few...February 27th, 2014, 09:03 AM34 replies | 406 view(s)
-
where did you get ELSE from? did you not read the manual for the syntax? also, tell me again why you want to drop that tableFebruary 27th, 2014, 08:41 AM34 replies | 406 view(s)
-
the full query simply creates the new R2 table based on content from T1 and T2, which are only read, not changed, not droppedFebruary 27th, 2014, 07:50 AM34 replies | 406 view(s)
-
depends why do you feel you need to re-create it?February 27th, 2014, 05:33 AM34 replies | 406 view(s)
-
that means you don't have any rows with oipl only, and you don't have any rows with james onlyFebruary 26th, 2014, 09:04 PM5 replies | 172 view(s)
-
issue a DROP IF EXISTS first, then the CREATE you may have to look up the exact syntax in the manualFebruary 26th, 2014, 08:18 PM34 replies | 406 view(s)
-
you wanted "oipl only or james only" that's exactly what my query looks forFebruary 26th, 2014, 08:17 PM5 replies | 172 view(s)
Latest Reputation Given
Thread / Date
User / Points
Comment
User / Points
Comment
-
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
-
Thread / Date
Trying to get one column only grouped by a "id"
June 4th, 201011:33 PMUser / Points
You gave 937 toComment
sweeeeet!!!
Latest Reputation Received 417193 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
Selecting fields from two tables
March 5th, 201405:22 PMUser / Points
You recieved 937 fromComment
No Comment Made -
Thread / Date
Query help - Head-To-Head Win/Loss Record
March 1st, 201408:57 PMUser / Points
You recieved 937 fromComment
No Comment Made -
Thread / Date
Query help - Head-To-Head Win/Loss Record
March 1st, 201408:52 PMUser / Points
You recieved 937 fromComment
No Comment Made -
Thread / Date
Left join weekdays and time interval
February 26th, 201402:51 PMUser / Points
You recieved 937 fromComment
No Comment Made -
Thread / Date
Query for multiple date ranges at the same time
February 13th, 201407:30 AMUser / Points
You recieved 937 fromComment
No Comment Made -
Thread / Date
Using Multiple Selects in One Query
January 15th, 201411:16 AMUser / Points
You recieved 937 fromComment
Wow! Now that is a query! -
Thread / Date
Triggers
January 9th, 201403:49 PMUser / Points
You recieved 937 fromComment
No Comment Made -
Thread / Date
Query runs to long in spite of index
December 9th, 201304:00 PMUser / Points
You recieved 937 fromComment
Thank you for the help -
Thread / Date
Replace value with null
December 3rd, 201311:12 AMUser / Points
You recieved 937 fromComment
No Comment Made -
Thread / Date
Query to determine duplicates
November 20th, 201303:07 PMUser / Points
You recieved 937 fromComment
No Comment Made
