How To Get the Structure of All Tables in a MySQL Database Using mysqldump

Author: , December 2nd, 2018

mysqldump -u {yourUserNameHere} -p –no-data –compact {yourDatabaseHere}

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

Author: , May 16th, 2018

SELECT FROM tableOne t1 LEFT JOIN tableTwo t2 ON = WHERE IS NULL The “WHERE IS NULL clause” restricts the results to only those rows where the id returned from tableTwo is null. 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. 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. 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 […]