r937 - DevShed Author Bio

r937 
SQL Consultant
Devshed Supreme Being (6500+ posts)
              

Join Date: February 25th, 2003

Last Activity: Today 08:46 PM

Recent Visitors

The last 10 visitor(s) to this page were:

This page has had 15,494 visits

About Me

r937's Activity

Reputation

Basic Information

Signature

rudy.ca | @rudydotca
Buy my SitePoint book: Simply SQL

Contact

Statistics

Posts

General Information

Older Activity
r937 replied to a thread Is INSERT SELECT a good idea or would it be a better option to do this with 2 queries in MySQL Help

you know what else is super simple? run a query, and then write a loop over the results, issuing a separate simple query for each row returned by...

see more

Yesterday, 10:00 AM
11 replies | 155 view(s)
r937 replied to a thread Is INSERT SELECT a good idea or would it be a better option to do this with 2 queries in MySQL Help

columns used in searching/filtering, then columns used in grouping or sorting yes

see more

Yesterday, 12:50 AM
11 replies | 155 view(s)
r937 replied to a thread How to get the number of active prospects in the account in MySQL Help

yes, i acknowledged that, didn't i but did you not see the advantage of clarity in purpose? don't you agree my sql makes more sense? if you were...

see more

June 16th, 2018, 06:43 PM
7 replies | 183 view(s)
r937 replied to a thread How to get the number of active prospects in the account in MySQL Help

i would have written the FROM clause slightly differently SELECT COUNT(*) AS active_prospects FROM launch_owners INNER JOIN launch_launches...

see more

June 16th, 2018, 04:01 AM
7 replies | 183 view(s)
r937 replied to a thread Need help to make query 100% optimized and index tables in MySQL Help

well spotted, good sir... waiting to hear OP's reason before rescinding my seal oh, and INT(3) holds exactly the same range of numbers as INT(9)...

see more

June 11th, 2018, 10:19 AM
14 replies | 372 view(s)
r937 replied to a thread joining results from two tables in MySQL Help

bravo, good sir so few people understand foreign key relationships

see more

June 11th, 2018, 10:16 AM
5 replies | 204 view(s)
r937 replied to a thread Need help to make query 100% optimized and index tables in MySQL Help

here ya go --

see more

June 11th, 2018, 01:48 AM
14 replies | 372 view(s)
r937 replied to a thread database structure for many attributes in MySQL Help

yes, those are the valid combinations and note, there are no duplicates in fact you don't even need the DISTINCT, and there still won't be...

see more

May 31st, 2018, 09:38 AM
15 replies | 561 view(s)
r937 replied to a thread database structure for many attributes in MySQL Help

that's unpossible, since you are using DISTINCT could you do a SHOW CREATE TABLE for each table please, and maybe dump a few rows of each

see more

May 30th, 2018, 04:35 PM
15 replies | 561 view(s)
r937 replied to a thread database structure for many attributes in MySQL Help

inner joins, not left joins post your query if you have any problems

see more

May 30th, 2018, 11:35 AM
15 replies | 561 view(s)
r937 replied to a thread database structure for many attributes in MySQL Help

no they wouldn't you don't have to follow my advice, but you also don't have to follow the advice of anyone who says every table has to have a...

see more

May 30th, 2018, 09:20 AM
15 replies | 561 view(s)
r937 replied to a thread database structure for many attributes in MySQL Help

that product association tables breaks one of the normal forms, i forget which one, but you shouldn't have two attributes on the same row for...

see more

May 29th, 2018, 11:53 AM
15 replies | 561 view(s)
r937 replied to a thread database structure for many attributes in MySQL Help

no... google NULL

see more

May 25th, 2018, 03:32 PM
15 replies | 561 view(s)
r937 replied to a thread Strange query issue in MySQL Help

another allowed exception is for derived tables, because you can see exactly which columns are being returned by inspection of the subquery-- ...

see more

May 22nd, 2018, 04:36 AM
8 replies | 331 view(s)

No More Results

Latest Reputation Given

Thread / Date

User / Points

Comment

Thread / Date

 How to get the number of active prospects in the account
June 17th, 201804:10 AM

User / Points
You gave 4331 to
kicken

Comment
thanks, i'm glad someone agrees ;o)
Thread / Date

 Update table field
January 8th, 201803:29 PM

User / Points
You gave 4288 to
benanamen

Comment
harsh but true
Thread / Date

 Is this table designed properly to store millions of records?
September 13th, 201707:59 AM

User / Points
You gave 0 to
requinix

Comment
masterful
Thread / Date

 Join on part of text col
July 21st, 201710:18 AM

User / Points
You gave 0 to
requinix

Comment
No Comment Made
Thread / Date

 Security Update: Password Expiry Dates
April 26th, 201609:28 AM

User / Points
You gave 1 to
SimonJM

Comment
No Comment Made
Thread / Date

 stupid dates!
March 8th, 201603:26 PM

User / Points
You gave 4287 to
Frank Grimes

Comment
No Comment Made
Thread / Date

 2 tables almost identical but one throws an error
January 30th, 201606:28 AM

User / Points
You gave 4286 to
requinix

Comment
No Comment Made
Thread / Date

 Question about MySQL
November 9th, 201504:48 PM

User / Points
You gave 4286 to
element121

Comment
No Comment Made
Thread / Date

 a big mysql table issue
May 7th, 201501:43 PM

User / Points
You gave 0 to
MrFujin

Comment
love you too <3
Thread / Date

 closest join
July 24th, 201402:14 PM

User / Points
You gave 3937 to
MrFujin

Comment
3000 bonus points for xaprb link

Latest Reputation Received 428833 point(s) total

Thread / Date

User / Points

Comment

Thread / Date

 Strange query issue
May 22nd, 201808:29 AM

User / Points
You recieved 4150 from
kicken

Comment
Forgot about that
Thread / Date

 Order of multi-key indexes
March 20th, 201807:53 PM

User / Points
You recieved 0 from
requinix

Comment
No Comment Made
Thread / Date

 Update table field
January 12th, 201812:53 AM

User / Points
You recieved 0 from
pwpx2

Comment
No Comment Made
Thread / Date

 Trying to subtract
November 27th, 201712:51 PM

User / Points
You recieved 2 from
SGC3

Comment
Thanks!
Thread / Date

 Concat Help
November 18th, 201708:04 AM

User / Points
You recieved 0 from
nrt453

Comment
great thank you
Thread / Date

 Unknown column error
September 15th, 201703:54 PM

User / Points
You recieved 0 from
pwpx2

Comment
No Comment Made
Thread / Date

 Query works but creating VIEW it crash
August 9th, 201703:40 AM

User / Points
You recieved 0 from
smaa

Comment
No Comment Made
Thread / Date

 LEFT JOIN tables
April 8th, 201705:14 PM

User / Points
You recieved 0 from
pwpx2

Comment
No Comment Made
Thread / Date

 MYSQL Query Help
January 23rd, 201707:14 AM

User / Points
You recieved 0 from
fabzster

Comment
Many thanks this is exactly what I was looking for
Thread / Date

 Hex Conversion wrong result
January 4th, 201702:15 PM

User / Points
You recieved 0 from
pwpx2

Comment
great help.

Dev Shed Forums

r937  SQL Consultant Devshed Supreme Being (6500+ posts)                Twitter

Recent Visitors

Basic Information

Signature

Contact

Statistics

Posts

General Information

Latest Reputation Given

Thread / Date User / Points Comment

Thread / Date

 How to get the number of active prospects in the account

User / Points

Comment

Thread / Date

 Update table field

User / Points

Comment

Thread / Date

 Is this table designed properly to store millions of records?

User / Points

Comment

Thread / Date

 Join on part of text col

User / Points

Comment

Thread / Date

 Security Update: Password Expiry Dates

User / Points

Comment

Thread / Date

 stupid dates!

User / Points

Comment

Thread / Date

 2 tables almost identical but one throws an error

User / Points

Comment

Thread / Date

 Question about MySQL

User / Points

Comment

Thread / Date

 a big mysql table issue

User / Points

Comment

Thread / Date

 closest join

User / Points

Comment

Latest Reputation Received 428833 point(s) total

Thread / Date User / Points Comment

Thread / Date

 Strange query issue

User / Points

Comment

Thread / Date

 Order of multi-key indexes

User / Points

Comment

Thread / Date

 Update table field

User / Points

Comment

Thread / Date

 Trying to subtract

User / Points

Comment

Thread / Date

 Concat Help

User / Points

Comment

Thread / Date

 Unknown column error

User / Points

Comment

Thread / Date

 Query works but creating VIEW it crash

User / Points

r937 
SQL Consultant
Devshed Supreme Being (6500+ posts)
              

Thread / Date

User / Points

Comment

Thread / Date

User / Points

Comment