r937 - DevShed Author Bio

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

Join Date: February 25th, 2003

Last Activity: Today 02:00 PM

Recent Visitors

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

This page has had 15,670 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 database structure for many attributes in MySQL Help

huge mistake google First Normal Form

see more

June 29th, 2018, 03:31 PM
18 replies | 790 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

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

June 19th, 2018, 10:00 AM
11 replies | 295 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

June 19th, 2018, 12:50 AM
11 replies | 295 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