147 reputation
25
bio website
location
age 23
visits member for 2 years, 9 months
seen Feb 9 at 16:39

Junior Developer Laser Red, Studying BSC Computing at Grimsby Institute. Oracle SQL & PL SQL trained, keen PHP, MySQL and jQuery Developer.


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