r937 - DevShed Author Bio

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

Join Date: February 25th, 2003

Last Activity: Yesterday 07:27 PM

Recent Visitors

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

This page has had 12,877 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 Displaying query if date has a value or is null in MySQL Help

another possibility is that jobs without a start date don't have a contractor or driller yet when you use inner joins like you did, jobs that...

see more

Yesterday, 02:56 PM
6 replies | 198 view(s)
r937 replied to a thread Displaying query if date has a value or is null in MySQL Help

yeah, but i just don't believe that try running your query outside of php -- i'm guessing it's your display logic that's at fault

see more

Yesterday, 02:53 PM
6 replies | 198 view(s)
r937 replied to a thread Displaying query if date has a value or is null in MySQL Help

your query as posted does exactly that

see more

Yesterday, 07:23 AM
6 replies | 198 view(s)
r937 replied to a thread mother of all querys in MySQL Help

1. if you specify job.job_status_id = '2' then you don't really need to join to job_status at all, assuming 2 corresponds to 'Complete' 2. if you...

see more

July 22nd, 2017, 10:09 AM
4 replies | 215 view(s)
r937 replied to a thread UNIQUE CONTRAINT on two columns? in MySQL Help

you got the wrong columns in your unique constraint, mister requinix it should be class_key and student_key aside to Frank -- why the...

see more

July 11th, 2017, 02:28 PM
3 replies | 183 view(s)
r937 replied to a thread Special access in MySQL Help

if article id is primary key, then there will be either 0 or 1 article "matching his userid with article id" -- not more

see more

July 7th, 2017, 01:04 PM
1 replies | 379 view(s)
r937 replied to a thread Use values in one table to update another table in MySQL Help

moderator note: your pictures aren't working (i deleted two other posts) use the "Go Advanced" button and upload your images there better yet,...

see more

July 7th, 2017, 09:26 AM
4 replies | 235 view(s)
r937 replied to a thread LAST_VALUE() and PARTITION BY in MySQL Help

you can have it either way i just gave you the equivalent of what you posted

see more

July 5th, 2017, 02:39 PM
4 replies | 245 view(s)
r937 replied to a thread LAST_VALUE() and PARTITION BY in MySQL Help

SELECT invoice.id , invoice.account , invoice.`date` , invoice.date_type , invoice.value , invoice.adj_value ,...

see more

July 5th, 2017, 12:53 PM
4 replies | 245 view(s)
r937 replied to a thread Do you know how to show a record's details in Sequel pro the way php myamin does? in MySQL Help

simon you are heartless <3 i can't help with the question but i do know what it means... 4.5.1.6.2 Displaying Query Results Vertically

see more

July 2nd, 2017, 03:38 PM
2 replies | 716 view(s)
r937 replied to a thread Debugging mysqli prepared statement insert in MySQL Help

give us a chance... echo the sql string that you execute

see more

June 28th, 2017, 04:04 AM
7 replies | 463 view(s)

No More Results

Latest Reputation Given

Thread / Date

User / Points

Comment

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
Thread / Date

 Query help
August 24th, 201303:09 AM

User / Points
You gave 0 to
Jacques1

Comment
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 PM

User / Points
You gave 937 to
regany

Comment
thanks for taking the time to give examples! very helpful for new developers
Thread / Date

 Update first X rows?
August 21st, 201209:29 PM

User / Points
You gave 937 to
airforcemook

Comment
what dan said

Latest Reputation Received 424681 point(s) total

Thread / Date

User / Points

Comment

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.
Thread / Date

 Access violation
December 19th, 201610:39 AM

User / Points
You recieved 0 from
requinix

Comment
...huh
Thread / Date

 Query table with two foreign keys linked to 2 additional tables
November 4th, 201603:05 PM

User / Points
You recieved 0 from
xerces1024

Comment
No Comment Made
Thread / Date

 How do you assign a single table to different columns after joining?
October 27th, 201604:28 PM

User / Points
You recieved 0 from
Varsh

Comment
No Comment Made
Thread / Date

 select 0 for the day that do not have a value
September 20th, 201602:38 AM

User / Points
You recieved 0 from
jojoba

Comment
No Comment Made
Thread / Date

 wrong result from subquery in WHERE EXISTS
September 7th, 201605:37 AM

User / Points
You recieved 0 from
jojoba

Comment
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 PM

User / Points
You recieved 10 from
Will-O-The-Wisp

Comment
Thanks for helping!
Thread / Date

 updating time only in datetime field
June 11th, 201611:11 AM

User / Points
You recieved 0 from
Frank Grimes

Comment
No Comment Made

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

 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

Thread / Date

 Query help

User / Points

Comment

Thread / Date

 Display 2 queries in the same table?

User / Points

Comment

Thread / Date

 Update first X rows?

User / Points

Comment

Latest Reputation Received 424681 point(s) total

Thread / Date User / Points Comment

Thread / Date

 LEFT JOIN tables

User / Points

Comment

Thread / Date

 MYSQL Query Help

User / Points

Comment

Thread / Date

 Hex Conversion wrong result

User / Points

Comment

Thread / Date

 Access violation

User / Points

Comment

Thread / Date

 Query table with two foreign keys linked to 2 additional tables

User / Points

Comment

Thread / Date

 How do you assign a single table to different columns after joining?

User / Points

Comment

Thread / Date

 select 0 for the day that do not have a value

User / Points

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

Thread / Date

User / Points

Comment

Thread / Date

User / Points

Comment