r937
SQL Consultant
Devshed Supreme Being (6500+ posts)
- Join Date
- February 25th, 2003
- Last Activity
- Today 09:21 AM
-
Older Activity
-
you have two one-to-many relationships in the same query, so of course the results will multiply, producing what i call "cross join effects" you...Today, 06:39 AM2 replies | 72 view(s)
-
if there were three tables -- players, dates, and player_dates -- then your table would be player_dates, the "association" or "relationship" or...Today, 06:33 AM1 replies | 48 view(s)
-
works for me... and to mitigate the space issue, you might limit it to 3 characters a hierarchy of access rights is pretty hard to implement...July 8th, 2014, 12:36 PM10 replies | 212 view(s)
-
i would typically start with the "natural" key (put in quotes because an abbreviated name that needs a fuller description in a separate table...July 7th, 2014, 08:04 PM10 replies | 212 view(s)
-
you're gonna hate me for saying this, but it would depend on volume testing and query profilingJuly 7th, 2014, 05:07 PM10 replies | 212 view(s)
-
would you please post your solution so that others who come upon this thread will be able to learn from itJuly 6th, 2014, 10:14 AM4 replies | 165 view(s)
-
1. bid_status con: dropping id and using name means all bid rows referencing this table will expand their row length pro: in some cases name is...July 6th, 2014, 10:13 AM10 replies | 212 view(s)
-
it's not just mysql, all databases are the same in this regard do the right thing in the right layerJuly 5th, 2014, 06:35 PM3 replies | 203 view(s)
-
i think you have to run your queries through phpmyadmin one at a time notice it barfed right after the CREATE DATABASE statementJuly 5th, 2014, 10:31 AM1 replies | 130 view(s)
-
queries return results in the form of tables what you are getting is perfectly normal you cannot "suppress" the "duplicated" user data on...July 5th, 2014, 03:49 AM3 replies | 203 view(s)
-
thanks, had it yesterday ;)July 2nd, 2014, 08:45 PM7 replies | 270 view(s)
-
you should actually try this with real (no pun intended) floats "equal" won't happen :)July 2nd, 2014, 07:27 PM7 replies | 270 view(s)
-
because you won't ever get a collision of numbers you have grasped the strategy perfectly... users can keep moving rows around (figuratively of...July 2nd, 2014, 10:50 AM7 replies | 270 view(s)
-
scenario 1 TINYINT is fine scenario 2 i would use FLOATJuly 2nd, 2014, 01:19 AM7 replies | 270 view(s)
-
go to google and search sql streaks there are many articles explaining itJune 29th, 2014, 07:32 PM6 replies | 225 view(s)
-
go to google and search sql streaks there are many articles explaining itJune 29th, 2014, 07:31 PM6 replies | 225 view(s)
-
equally viable you cannot get more unique than unique :)June 29th, 2014, 11:03 AM12 replies | 388 view(s)
-
requinix, combining an auto_increment with another column does make sense, it's a feature of myisam see "fish mammal bird" example here -- MySQL...June 29th, 2014, 04:39 AM12 replies | 388 view(s)
-
go with option 2, random PK you will have to generate it in the app, and also have some code to re-generate a number in the insanely rare but not...June 29th, 2014, 04:36 AM12 replies | 388 view(s)
-
SELECT p.users_id AS parent , c.users_id AS child , c.date , u.name FROM parentTable AS p LEFT OUTER JOIN ( SELECT...June 27th, 2014, 08:04 AM2 replies | 191 view(s)
-
SELECT COALESCE(s1.scName,a.csG1) AS csG1 , COALESCE(s2.scName,a.csG2) AS csG2 , COALESCE(s3.scName,a.csG3) AS csG3 ,...June 21st, 2014, 03:21 PM1 replies | 237 view(s)
-
data pertaining to the email, independent of which user stored the email in the cc:/bcc: list, yes, would require a normalized table, making it...June 21st, 2014, 08:48 AM11 replies | 362 view(s)
-
CREATE TABLE users ( userid INTEGER NOT NULL PRIMARY KEY , foo VARCHAR(37) ); CREATE TABLE emails ( userid INTEGER NOT NULL , email...June 21st, 2014, 07:54 AM11 replies | 362 view(s)
-
perhaps i did not understand your application needs i would be really surprised if different users shared an email so my thought process was...June 20th, 2014, 11:42 PM11 replies | 362 view(s)
-
close :) except it'll be a one-to-many relationship each row will have the email address, as well as a foreign key back to the users tableJune 20th, 2014, 09:29 PM11 replies | 362 view(s)
-
probably would not go well i think your'e right about the FK difficulty got time to test it?June 18th, 2014, 09:15 AM4 replies | 300 view(s)
-
should? hard to say could? certainly INSERTs and UPDATEs are sometimes, but not often, possible with views -- most people prefer using actual...June 18th, 2014, 08:27 AM4 replies | 300 view(s)
-
a trivially minor sin, compared to all the other stuff going on in that query :DJune 17th, 2014, 11:55 AM8 replies | 313 view(s)
-
are you confusing the purpose of GROUP BY versus ORDER BY? are you sure you are grouping on the correct column(s)?? p.s. please format your...June 17th, 2014, 07:58 AM8 replies | 313 view(s)
Latest Reputation Given
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
Query help
August 24th, 201303:09 AMUser / Points
You gave 0 toComment
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 PMUser / Points
You gave 937 toComment
thanks for taking the time to give examples! very helpful for new developers -
Thread / Date
Update first X rows?
August 21st, 201209:29 PMUser / Points
You gave 937 toComment
what dan said -
Thread / Date
Putting condition in ON clause or WHERE clause
August 17th, 201209:18 AMUser / Points
You gave 937 toComment
very nicely explained, great tutorial -
Thread / Date
Trying to get a count of certain records - PHP/MYSQL
January 13th, 201202:04 PMUser / Points
You gave 937 toComment
nice explanation, guelphdad
-
Thread / Date
Problem with slow query
October 18th, 201103:47 PMUser / Points
You gave 2937 toComment
stefan is my tuning hero
-
Thread / Date
Complicated table join question.
September 15th, 201108:29 AMUser / Points
You gave 937 toComment
sweet
-
Thread / Date
Help with a query
June 5th, 201108:21 AMUser / Points
You gave 2937 toComment
lol
-
Thread / Date
Urgent help Find Replace Query
June 21st, 201009:36 AMUser / Points
You gave 937 toComment
nicely explained
-
Thread / Date
Trying to get one column only grouped by a "id"
June 4th, 201011:33 PMUser / Points
You gave 937 toComment
sweeeeet!!!
Latest Reputation Received 423544 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
duplicate row in inner join
July 13th, 201408:34 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
double SUM
June 12th, 201406:24 AMUser / Points
You recieved 0 fromComment
Sniped!
-
Thread / Date
Select distinct column when all criteria from another column are met/found
May 12th, 201401:12 PMUser / Points
You recieved 6351 fromComment
haven't repped you in a while, and it's good to encourage the newbies who make the right calls. -
Thread / Date
Selecting fields from two tables
March 5th, 201405:22 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Query help - Head-To-Head Win/Loss Record
March 1st, 201408:57 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Query help - Head-To-Head Win/Loss Record
March 1st, 201408:52 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Left join weekdays and time interval
February 26th, 201402:51 PMUser / Points
You recieved 10 fromComment
No Comment Made -
Thread / Date
Query for multiple date ranges at the same time
February 13th, 201407:30 AMUser / Points
You recieved 3 fromComment
No Comment Made -
Thread / Date
Using Multiple Selects in One Query
January 15th, 201411:16 AMUser / Points
You recieved 5 fromComment
Wow! Now that is a query! -
Thread / Date
Triggers
January 9th, 201403:49 PMUser / Points
You recieved 0 fromComment
No Comment Made
