How to Rename a Table using phpMyAdmin
It is not immediately apparent how you go about changing the name of a MySQL database table via the phpMyAdmin interface, so I thought I...
Read More
Tag: table
How to Duplicate a Table in FlameRobin
October 3, 2011
by Craig Lotter
No Comments
FlameRobin is a lightweight, cross-platform database administration tool for Firebird databases. It is also NOT one of my favourite tools to use because of its...
Read More
MySQL: How to Check if a Table Exists with SQL
February 9, 2011
by Craig Lotter
No Comments
To check if a table exists with SQL in a MySQL database is pretty easy, thanks to the nifty SHOW TABLES command.
Read More
Highlight a Table Row using jQuery
January 26, 2010
by Craig Lotter
No Comments
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...
Read More
MySQL: How to Duplicate a Table
September 10, 2009
by Craig Lotter
No Comments
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...
Read More