| bio | website | |
|---|---|---|
| location | ||
| age | 22 | |
| visits | member for | 1 year, 6 months |
| seen | Mar 7 at 21:38 | |
| stats | profile views | 4 |
Junior Developer Laser Red, Studying BSC Computing at Grimsby Institute. Oracle SQL & PL SQL trained, keen PHP, MySQL and jQuery Developer.
|
Feb 19 |
awarded | Popular Question |
|
Feb 12 |
awarded | Notable Question |
|
Sep 20 |
awarded | Popular Question |
|
Jan 11 |
accepted | Multiple left joins or subquery? |
|
Jan 11 |
comment |
Multiple left joins or subquery? Just tested that and it seemed to have worked, I think the DISTINCT fixed the main problem. I didn't have to add those indexes as I already had an index for each. Thanks! |
|
Jan 11 |
comment |
Multiple left joins or subquery? Thanks for your answer, could you please let me know how I can show the table structure in a format like: dba.stackexchange.com/questions/10472/join-three-tables ? Otherwise would the CREATE TABLE queries be okay? |
|
Jan 10 |
asked | Multiple left joins or subquery? |
|
Jan 10 |
accepted | Storing time with milliseconds in database |
|
Jan 10 |
comment |
Storing time with milliseconds in database Thanks I'll do that! |
|
Jan 10 |
comment |
Storing time with milliseconds in database Thanks for your answer, would I need to convert it to a standard format as currently it is in the format 00:00:00:00? Could I set the column to allow that type of format? |
|
Jan 9 |
asked | Storing time with milliseconds in database |
|
Dec 12 |
awarded | Scholar |
|
Dec 12 |
accepted | User system database design |
|
Dec 12 |
comment |
User system database design Thanks I think I will use your idea of a separate lostPassword table. Thanks for the link to SchemaSpy! |
|
Dec 11 |
awarded | Student |
|
Dec 7 |
asked | User system database design |
|
Nov 6 |
awarded | Supporter |