network profile
| bio | website | gunsightsoftware.com |
|---|---|---|
| location | Fort Collins, CO | |
| age | 35 | |
| visits | member for | 1 year, 7 months |
| seen | Mar 10 at 6:32 | |
| stats | profile views | 12 |
Not much to say :-)
|
Apr 29 |
awarded | Notable Question |
|
Mar 19 |
awarded | Notable Question |
|
Feb 28 |
awarded | Notable Question |
|
Jan 17 |
awarded | Notable Question |
|
Dec 27 |
awarded | Popular Question |
|
Oct 19 |
awarded | Yearling |
|
Oct 11 |
awarded | Popular Question |
|
Oct 8 |
awarded | Commentator |
|
Oct 8 |
accepted | Foreign Key Constraint fails |
|
Oct 8 |
comment |
Foreign Key Constraint fails Ah that was the problem. I guess now that I read the error message about failing on a child row instead of the actual constraint relationship itself, it makes sense. Thanks! |
|
Oct 8 |
comment |
Foreign Key Constraint fails Both tables already exist. The above code is the create table code. I'm just trying to add the foreign key. |
|
Oct 8 |
asked | Foreign Key Constraint fails |
|
Oct 4 |
accepted | Test MySQL credentials from Linux command line? |
|
Oct 4 |
accepted | Do MySQL sub-queries essentially use as much overhead as separate queries? |
|
Sep 25 |
accepted | SELECT LIMIT 1 per column value? |
|
Sep 25 |
comment |
SELECT LIMIT 1 per column value? yes, pretend like perhaps there were other columns in the table and I wanted to grab the comment from the user that was first alphabetically and posted the nearest the NOW(). So sort of like ORDER BY multiple columns, but obviously using ORDER BY in this query would simply reorder the results, not actually manipulate which rows are SELECTED. |
|
Sep 25 |
comment |
SELECT LIMIT 1 per column value? Are there any other ways to specify which row gets pulled for a user_id? Any way to specify an ORDER BY kind of? |
|
Sep 25 |
asked | SELECT LIMIT 1 per column value? |
|
Sep 14 |
asked | Do MySQL sub-queries essentially use as much overhead as separate queries? |
|
Sep 14 |
awarded | Popular Question |
