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 05:16 PM

Recent Visitors

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

This page has had 15,055 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 need help with an update query in MySQL Help

yup, that helps, i'm not sure why i was confused UPDATE global SET provispass = ( SELECT value FROM sysadmin_options ...

see more

April 14th, 2018, 05:58 AM
4 replies | 595 view(s)
r937 replied to a thread need help with an update query in MySQL Help

a bit confused here, could you please do a SHOW CREATE TABLE for each table

see more

April 12th, 2018, 12:39 PM
4 replies | 595 view(s)
r937 replied to a thread Is this SQL in loop avoidable? in MySQL Help

sorry, friend, i don't do php

see more

April 9th, 2018, 04:35 AM
6 replies | 219 view(s)
r937 replied to a thread Why can I use a "replace" field in select? in MySQL Help

but a good one note this also applies in the version i posted, where the function is in the subquery and the WHERE condition is in the outer query

see more

April 5th, 2018, 03:14 PM
6 replies | 436 view(s)
r937 replied to a thread Remove url text in MySQL Help

you need only one REPLACE CASE WHEN = '' THEN NULL ELSE REPLACE( , "www.oldsite.com", "www.newsite.com") END AS

see more

April 4th, 2018, 01:35 PM
9 replies | 384 view(s)
r937 replied to a thread Why can I use a "replace" field in select? in MySQL Help

i know y'all are going to say whoa, that's extra coding, but with a good text or sql editor, the effort is trivial by the way, it's called a...

see more

April 3rd, 2018, 01:30 PM
6 replies | 436 view(s)
r937 replied to a thread Remove url text in MySQL Help

this -- () is invalid try using the keyword NULL (no quotes) instead

see more

April 3rd, 2018, 10:38 AM
9 replies | 384 view(s)
r937 replied to a thread Oracle vs MYSQL - different row number returned in MySQL Help

no, both interpret it the same... and both even ignore the parentheses

see more

April 2nd, 2018, 05:42 PM
4 replies | 235 view(s)
r937 replied to a thread Oracle vs MYSQL - different row number returned in MySQL Help

i'd put money on the tables ~not~ having the same data in the two databases p.s. do yourself a favour, learn explicit joins, e.g. INNER JOIN

see more

April 2nd, 2018, 04:06 AM
4 replies | 235 view(s)
r937 replied to a thread group_concat to count the number of subs? in MySQL Help

you don't ~have~ to you get the same results with INNER joins in other words, you're asking for results where the right table in a left outer...

see more

April 1st, 2018, 03:26 PM
14 replies | 431 view(s)
r937 replied to a thread group_concat to count the number of subs? in MySQL Help

so for "how many launch products does each launch launch have? exactly one?" you're saying exactly one? okay both LEFT joins should be INNER......

see more

April 1st, 2018, 02:12 PM
14 replies | 431 view(s)
r937 replied to a thread group_concat to count the number of subs? in MySQL Help

and products?

see more

April 1st, 2018, 03:11 AM
14 replies | 431 view(s)
r937 replied to a thread group_concat to count the number of subs? in MySQL Help

how many launch plcs does each launch launch have? exactly one? maybe one? possibly more than one? how many launch products does each launch...

see more

March 31st, 2018, 04:14 PM
14 replies | 431 view(s)
r937 replied to a thread group_concat to count the number of subs? in MySQL Help

definitely not a job for GROUP_CONCAT and you don't need a join, if it's just a count, and you know which launch you want the count for SELECT...

see more

March 30th, 2018, 11:58 AM
14 replies | 431 view(s)

No More Results

Latest Reputation Given

Thread / Date

User / Points

Comment

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

Latest Reputation Received 424683 point(s) total

Thread / Date

User / Points

Comment

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

 Access violation
December 19th, 201610:39 AM

User / Points
You recieved 0 from
requinix

Comment
...huh

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

 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

Thread / Date

 Query help

User / Points

Comment

Latest Reputation Received 424683 point(s) total

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

Comment

Thread / Date

 LEFT JOIN tables

User / Points

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

Thread / Date

User / Points

Comment

Thread / Date

User / Points

Comment