Tag Archives: table

MySQL: How to Check if a Table Exists with SQL

To check if a table exists with SQL in a MySQL database is pretty easy, thanks to the nifty SHOW TABLES command. Continue reading

Posted in MySQL | Tagged , show tables, | View Comments

Highlight a Table Row using jQuery

Using jQuery to highlight a table row on mouse over is pretty simple to achieve, and today I’ll quickly demonstrate how you can achieve this neat effect using the addClass and removeClass jQuery functionalities. Continue reading

Posted in Technology & Code, Tutorials | Tagged , , , , , , | View Comments

MySQL: Duplicate a Table

Well funnily enough, it’s actually pretty damn simple. The CREATE TABLE IF NOT EXISTS phrase is key here and combining this with a select statement will in fact create a copy of your existing table, taking all the data from your source table and dumping it into your newly created clone table. Continue reading

Posted in Technology & Code, Tutorials | Tagged , , , , , | View Comments