r937 - DevShed Author Bio

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

Join Date: February 25th, 2003

Current Activity: Viewing Forum MySQL Help

Last Activity: Today 03:26 AM

Recent Visitors

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

This page has had 13,412 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 error generating list of items in s1 NOT IN table s2 in MySQL Help

both of these are extremely problematic (i.e. wrong) if items.startdate is DATETIME if you're looking for something that is easy to write,...

see more

September 20th, 2017, 05:45 AM
6 replies | 132 view(s)
r937 replied to a thread error generating list of items in s1 NOT IN table s2 in MySQL Help

NOT IN expects a single column of values -- you're feeding it more than one column when the subquery uses select s2.* change it to select...

see more

September 20th, 2017, 04:15 AM
6 replies | 132 view(s)
r937 replied to a thread Unknown column error in MySQL Help

perhaps your single quotes were in the wrong place try it like this: INSERT INTO article_acc (uid, aid, user) VALUES($userid, $article_number,...

see more

September 15th, 2017, 02:23 PM
7 replies | 201 view(s)
r937 replied to a thread Unknown column error in MySQL Help

it's a string... put single quotes around it

see more

September 15th, 2017, 11:37 AM
7 replies | 201 view(s)
r937 replied to a thread Mysql query help in MySQL Help

how do you know which one is the latest? you don't have a time stamp column!!

see more

September 14th, 2017, 04:37 AM
1 replies | 107 view(s)
r937 replied to a thread Assistance with Joins in mysql in MySQL Help

this is what i call the "filter" condition -- it filters the rows being returned to the join one very strong suggestion i have for writing joins...

see more

September 13th, 2017, 07:27 AM
2 replies | 115 view(s)
r937 replied to a thread data limit reached with GROUP_CONCAT in MySQL Help

at 0:20 -- "you think you own me? oh, i forgot, you do own me" https://www.youtube.com/watch?v=aQgCtSMs15Q the whole commercial is glorious

see more

September 12th, 2017, 02:20 PM
4 replies | 167 view(s)
r937 replied to a thread join table-name with table on other database on same server in MySQL Help

you cannot your error was in designing a separate table for each property you will have to run the queries separately and join the results in...

see more

September 6th, 2017, 10:00 AM
3 replies | 214 view(s)
r937 replied to a thread How to merge decimal data from one table to another in MySQL Help

sure, just put the GREATEST expression into the SELECT clause

see more

August 25th, 2017, 06:20 PM
6 replies | 485 view(s)
r937 replied to a thread How to merge decimal data from one table to another in MySQL Help

wait, never mind, i think the problem is NULLs in job_value try using COALESCE function -- SELECT jb_job_data.id as jobid ...

see more

August 25th, 2017, 08:01 AM
6 replies | 485 view(s)
r937 replied to a thread How to merge decimal data from one table to another in MySQL Help

please show some sample data to illustrate what you are getting

see more

August 25th, 2017, 07:40 AM
6 replies | 485 view(s)

No More Results

Latest Reputation Given

Thread / Date

User / Points

Comment

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

Latest Reputation Received 424681 point(s) total

Thread / Date

User / Points

Comment

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.
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

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

 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

Thread / Date

 Query help

User / Points

Comment

Thread / Date

 Display 2 queries in the same table?

User / Points

Comment

Latest Reputation Received 424681 point(s) total

Thread / Date User / Points Comment

Thread / Date

 Unknown column error

User / Points

Comment

Thread / Date

 Query works but creating VIEW it crash

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

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

Thread / Date

User / Points

Comment

Thread / Date

User / Points

Comment