Mysql show create constraint?
- by pvgoddijn
Hi,
Is there a easy way to query a table for its constraints(foreignkeys specificaly)
like show create table, but for the constraints only?
thanks,
pvgoddijn
Search Results
Search found 2 results on 1 pages for 'pvgoddijn'.
Page 1/1 | 1
-
-
comparator with null values.
- by pvgoddijn
Hi, We have some code wich sorts a list of addresses based on the distance between their coordinates. this is done through collections.sort with a custom comparator. However from time to time an adress without coordinates is in the list causing a NullPointerException. My initial idea to fix this was to have the comparator return 0 as dististance for addresses where at least one of the coordinates is null. I fear this might lead to corruption of the order the 'valid' elements in the list. so is returning a '0' values for null data in a comparator ok, or is there a cleaner way to resolve this.Read the article
