Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: csmith3pmg
- Order by date
-
optional relationships
According to the documentation: Starting from version 3.23.50, InnoDB does not check foreign key constraints on those foreign key or referenced key values which contain a NULL column. If you are running into problems with NULLs being compared with your foreign key constraint then you may need...- csmith3pmg
- Post #2
- Forum: MySQL
-
MYSQL Problems with "order by"
I have a table made up of Year, Week, Name, ID, and then several numeric fields defined as either smallint(3) or smallint(4). I am trying to create two result sets from very similar queries the first is working and the second is not. The first is: select Name, ID, Sum(1stNumField) as Num1...- csmith3pmg
- Thread
- Replies: 1
- Forum: MySQL
