Finding out why Foreign key creation fail When MySQL is unable to create a Foreign Key, it throws out this generic error message: ERROR 1215 (HY000): Cannot add foreign key constraint – The most useful error message ever. Fortunately, MySQL has this useful command that can give the actual reason about why it could not… Continue reading 5 Reasons MySQL Foreign Key constraints fail to create
Month: August 2020
jQuery DataTable: Sorting dynamic data
jQuery DataTable is a powerful library to super charge your HTML tables. By default DataTable can sort your data based on the content of the cells. But if you are loading your table data dynamically and want to apply a custom sorting based on the DOM data, you can use DataTable’s custom sorting code: data-sort… Continue reading jQuery DataTable: Sorting dynamic data