Select Tables Snippets


This is a very handy query that sorts your tables by their physical size in megabytes. Just be sure to edit the query to include the database name.

30 August, 2011   

Calculates the total size of a MySQL database in KB/MB or GB...

If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.

12 January, 2012   

Example for Dumping a database to HTML tables

23 October, 2012   

MySQL code example to optimize all tables of database

24 December, 2014   

Example shows here how to select from multiple mySQL tables.

How to get number of rows in tables of database

07 January, 2016   

The INNER JOIN keyword return rows when there is at least one match in both tables.

30 December, 2010   

Class to back up entire databases and email them out, or individual tables

09 February, 2011   

Class to back up entire databases and email them out, or individual tables.

This code will show you how to save data from gridview to xml file

15 July, 2013   

This code will be used to bind an xml file to gridview

Cross Browser Vertically and Horizontally Centered Images in CSS without Tables

MySQL code example showing how to SELECT within a SELECT (a subselect).

12 January, 2014   

This is a pretty simple little snippet, but it help understanding how to use relational tables w/in PHP.

30 November, 2014   

Mysql code example for Regular Expression SELECT statement

09 May, 2011   

This is a general code to use when selecting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match. This MYSQL Code using in PHP

19 September, 2013   

Function to test for the existence of at least 1 matching row, without having to count them all!

21 December, 2013   

Great page for testing the style guide for a website.

31 October, 2011   

Declarations: Option Explicit On Imports System.Data.OleDb