r937
SQL Consultant
Devshed Supreme Being (6500+ posts)
- Join Date
- February 25th, 2003
- Current Activity
- Viewing Forum MySQL Help
- Last Activity
- Today 02:53 PM
Recent Visitors
- adgroup14,
- adgroup16,
- antruong02,
- antruong06,
- dailyxetaifuso,
- micahn,
- nguyentrungvd9,
- SGC3,
- Triple_Nothing,
- truongan8915
-
Older Activity
-
in the ON clause, change your DATE_FORMAT() to DATE() smooove ;o)September 19th, 2016, 07:00 PM12 replies | 296 view(s)
-
in order to diagnose your data problems, please run this -- SELECT m.the_day , MAX(o.totalOrderAmount) FROM ( SELECT CURRENT_DATE -...September 19th, 2016, 09:15 AM12 replies | 296 view(s)
-
make sure that 0 is one of the numbers in your numbers table run this to see how to get the first date of the current month -- SELECT...September 19th, 2016, 02:46 AM12 replies | 296 view(s)
-
you need a numbers table... see Loop for seqential records with dates once you have it installed, do a SHOW CREATE TABLE and then i can show you...September 17th, 2016, 06:00 PM12 replies | 296 view(s)
-
how is it different? i suggested you should use an outer join, and you used an outer join!September 15th, 2016, 10:58 AM3 replies | 270 view(s)
-
you're using inner joins -- no results unless all tables match on joined columns try outer joins -- results even if no match in some table(s)September 14th, 2016, 07:17 AM3 replies | 270 view(s)
-
by the way, if you have -- PRIMARY KEY (accounts_id, type, id), INDEX fk__inc_accounts1_idx (accounts_id ASC)) then the index is redundant,...September 13th, 2016, 06:42 PM3 replies | 173 view(s)
-
no, it isn't -- an auto_increment is always a surrogate keySeptember 13th, 2016, 06:41 PM3 replies | 173 view(s)
-
September 13th, 2016, 06:40 PM3 replies | 173 view(s)
-
nothing in particular... i'm sure there are, literally, hundreds of tutorials out there... try doing EXPLAINs on some of your queries, and...September 13th, 2016, 06:38 PM3 replies | 168 view(s)
-
do it this way -- SELECT CallAgent , AgentColour , COUNT(*) AS colour_count FROM Table GROUP BY CallAgent ,...September 13th, 2016, 11:06 AM2 replies | 176 view(s)
-
September 13th, 2016, 03:03 AM3 replies | 168 view(s)
-
there are two "regards" -- check how the scenarios differ mysql and standard sql agree on one, disagree on the otherSeptember 8th, 2016, 06:35 PM7 replies | 321 view(s)
-
both being the same in standard SQL? noSeptember 8th, 2016, 01:36 PM7 replies | 321 view(s)
-
where did you get "probably" from? both MySQL and standard SQL would evaluate that UPDATE the same way... guaranteed differentSeptember 8th, 2016, 10:29 AM7 replies | 321 view(s)
-
so you should be okaySeptember 7th, 2016, 08:49 PM7 replies | 321 view(s)
-
WHERE EXISTS simply checks whether the subquery returns any rows (it actually stops executing as soon as it finds the first row, and returns TRUE)...September 7th, 2016, 03:45 AM4 replies | 281 view(s)
-
what you're doing is the same as SELECT productName FROM products WHERE 1=1 your WHERE EXISTS will return true (same as 1=1) whenever the UNION...September 6th, 2016, 06:13 PM4 replies | 281 view(s)
-
i do not understand why you want it that way surely there is ~some~ work that could or should be done in the front-end language (e.g. php) i...August 30th, 2016, 10:42 AM2 replies | 312 view(s)
-
thanks for saying "somewhere else" -- nobody's supposed to know who that reprobate guy really is ;)August 29th, 2016, 06:58 PM8 replies | 406 view(s)
-
backticks are used to delimit identifiers you still need single quotes to delimit character stringsAugust 29th, 2016, 06:55 PM3 replies | 260 view(s)
-
don't forget to update your reddit page ;)August 29th, 2016, 06:11 PM8 replies | 406 view(s)
-
it's a pretty common error -- you're using single quotes around your identifier names, rather than backticks change this -- $sql2 = "UPDATE...August 29th, 2016, 05:10 PM3 replies | 260 view(s)
-
no, i meant adding a join to the main query SELECT SUM(pa.depositmade_num) AS NumDeposit , SUM(pa.depositmade_amt) AS AmtDeposit ,...August 29th, 2016, 04:12 PM8 replies | 406 view(s)
-
doesn't help, no could you try explaining in english what the HAVING clause is trying to do? e.g. make sure overall totals calculated only for...August 29th, 2016, 02:10 PM8 replies | 406 view(s)
-
could you explain why you need a different copy of the activity table in the HAVING clause? that calculation should be in either the SELECT clause...August 29th, 2016, 04:00 AM8 replies | 406 view(s)
Latest Reputation Given
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
Security Update: Password Expiry Dates
April 26th, 201609:28 AMUser / Points
You gave 1 toComment
No Comment Made -
Thread / Date
stupid dates!
March 8th, 201603:26 PMUser / Points
You gave 4287 toComment
No Comment Made -
Thread / Date
2 tables almost identical but one throws an error
January 30th, 201606:28 AMUser / Points
You gave 4286 toComment
No Comment Made -
Thread / Date
Question about MySQL
November 9th, 201504:48 PMUser / Points
You gave 4286 toComment
No Comment Made -
Thread / Date
a big mysql table issue
May 7th, 201501:43 PMUser / Points
You gave 0 toComment
love you too <3 -
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
Latest Reputation Received 424681 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
select 0 for the day that do not have a value
September 20th, 201602:38 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
wrong result from subquery in WHERE EXISTS
September 7th, 201605:37 AMUser / Points
You recieved 0 fromComment
why does it show 0 in my rep power :-s. anyway, thanks -
Thread / Date
receive second SELECT of UNION ALL as different column names
August 30th, 201603:58 PMUser / Points
You recieved 10 fromComment
Thanks for helping! -
Thread / Date
updating time only in datetime field
June 11th, 201611:11 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Selecting records based on a future datetime
June 11th, 201609:52 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Optimizing / efficient Mysql Query
May 16th, 201610:29 AMUser / Points
You recieved 10 fromComment
Thank you! -
Thread / Date
Security Update: Password Expiry Dates
April 25th, 201604:28 PMUser / Points
You recieved 10 fromComment
Ah, thanks! 1786 - a good year. Mozart's "The Marriage of Figaro" premiered that year! -
Thread / Date
sql query help
April 21st, 201609:43 AMUser / Points
You recieved 10 fromComment
Thank you! -
Thread / Date
Getting wrong result merging tables
January 19th, 201606:20 PMUser / Points
You recieved 0 fromComment
no where for me to add but u are a life saver -
Thread / Date
Query excludes results with partially empty entries
January 12th, 201608:04 PMUser / Points
You recieved 0 fromComment
Ya, I've no clue where that came from...
