My Sql Dump Snippets


18 January, 2012   

You can combine with SQL JOIN clause to show department name with count.

28 June, 2014   

Starting in Oracle 9i, you can use the case statement within an SQL statement. It has the functionality of an IF-THEN-ELSE statement.

05 May, 2012   

ASP code example with Sql Statement

PHP code example to get All-Time Number of MySQL Queries

16 February, 2013   

Binds a php variable to an SQL statement using the bindParam() method

This function builds an HTML select list from from data retrieved from a mySQL table.

18 June, 2012   

An example of Stored PL/SQL blocks

15 June, 2014   

Example for updating a record in a database with perl and the DBU module.

The mysql_fetch_assoc "converts" a row from a table into an associative array. The mysql_insert_array "converts" an associative array into a row in a table.

31 July, 2012   

Boiler Plate for T-Sql Error handling

13 November, 2011   

Boiler Plate for T-Sql Error handling

14 May, 2011   

This is a general code to use when updating 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.

01 October, 2013   

This class has lots of common functionality built right into it. It also supports Mysql and Sphinx.

Make a MySQL Database called "db" with a table named "variables" with three rows ("id", "title", and "content"). Insert your data. Then call the page by going variables.php?id=1 etc.

14 May, 2011   

This is a general code to use when deleting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. A variation of the code would be not to delete the record (as you tend to always need to restore or retrieve it sooner or later) you can add a 'status' field. If status='d' then it is...

05 May, 2012   

ASP code example to return a long representing the record count returned by an SQL statement

09 May, 2011   

This is a general code to use when inserting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. An extention of this code would be to make sure the entry you are adding to the database doesn't already exist (to save dupicate entries). Note: This code requires you to connect to the MySQL...

09 February, 2012   

Syntax for both the column and table aliases

19 March, 2011   

Showing here an example of PL SQL Query

12 January, 2012   

Example for Dumping a database to HTML tables