How To Select Rows in MySQL with No Matching Entry in Another Table

Author: , May 16th, 2018

SELECT t1.id FROM tableOne t1 LEFT JOIN tableTwo t2 ON t1.id = t2.id WHERE t2.id IS NULL The “WHERE t2.id IS NULL clause” restricts the results to only those rows where the id returned from tableTwo is null. tableTwo.id will be NULL for all records from tableOne where the id is not found in tableTwo.

How To Select the First Table Cell in the First Row Using CSS

Author: , April 19th, 2014

table.myTable > tbody > tr:first-child > td:first-child

How To Disable Sort in DataTables

Author: , July 10th, 2013

To turn off Sort completely, use the ‘bSort’: false option. http://datatables.net/usage/features#bSort To have sorting turned off to begin with, but the user can still click on the columns to sort, use the ‘aaSorting’: [] (i.e. empty array) option. http://datatables.net/examples/basic_init/table_sorting.html Happy Coding!

How To Create a Responsive Table Using jQuery

Author: , April 19th, 2013

The jQuery 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 jQuery(document).ready(function() {     function watchWindow() {   […]

How To Copy Data From Table To Table Using MySQL

Author: , June 8th, 2011

1 2 CREATE TABLE newTable LIKE oldTable; INSERT INTO newTable SELECT * FROM oldTable; CREATE TABLE newTable LIKE oldTable; INSERT INTO newTable SELECT * FROM oldTable; 1 INSERT INTO newtable (`name`, `address1`, `address2`, `city`, `state`, `zip`, `phone`) SELECT `name`, `address1`, `address2`, `city`, `state`, `zip`, `phone` FROM oldtable; INSERT INTO newtable (`name`, `address1`, `address2`, `city`, `state`, […]

How To Fix Safari And IE7 Table Rendering Problems

Author: , May 30th, 2011

I was having trouble with a table not sizing properly. The width of the table was much wider that the content. It tuns out that both Safari and IE7 have trouble with COLSPAN. Worked just fine in FF and IE8. The fix was to make the COLSPAN into a single cell and place another table […]