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 10:15 AM

Recent Visitors

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

This page has had 15,299 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

no... google NULL

see more

Yesterday, 03:32 PM
4 replies | 147 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 | 202 view(s)
r937 replied to a thread database structure for many attributes in MySQL Help

yes yes, it's called EAV -- entity-attribute-value it's very efficient for storing all kinds of different attributes, but please BE WARNED...

see more

May 15th, 2018, 10:26 AM
4 replies | 147 view(s)
r937 replied to a thread php's date('c') ISO 8601 date in MySQL Help

i tested various formats, and discovered how to do it did you? test anything, i mean

see more

May 3rd, 2018, 10:00 AM
11 replies | 372 view(s)
r937 replied to a thread php's date('c') ISO 8601 date in MySQL Help

1. DATETIME 2. inability to do date calculations

see more

May 3rd, 2018, 03:39 AM
11 replies | 372 view(s)
r937 replied to a thread A date question. Find prospects who joined within the past 7 days in MySQL Help

the date seven days ago is CURRENT_DATE - INTERVAL 7 DAY if you use NOW, which is equivalent to CURRENT_TIMESTAMP, you might miss some minutes

see more

April 27th, 2018, 03:33 AM
4 replies | 239 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 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

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