Database Query Snippets

24 September, 2012   

Connects to a database, and runs a query

Basic Database Connection, Random Query, Display Result

An example code to restore MSSQL database from backup

Asp.Net code snippet for Database Query Within WebServices

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.

PHP & Mysql based code to Print table with client-side sorting function.

01 October, 2013   

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

23 October, 2012   

MySQL code example for sorting data in a GRID

14 September, 2013   

An example for MySQL Results To Array

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.

Oracle 10G has enhanced the flashback feature further and has turned it into a much more powerful feature by introducing a number of additional function. Some of the more common ones are discussed here. - Flashback Table - Flashback Drop - Flashback Database

30 September, 2012   

This query will show you how to select only distinct (unique) entries from a database

10 October, 2012   

This query will return the amount of records for the query

23 November, 2013   

You can search and replace fields by below query in MySQL Database

30 August, 2011   

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

15 June, 2014   

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

07 April, 2013   

A simple example code for user login with a login form and database query

This is an example for Form Based Query

18 June, 2013   

Define few variables with your MySQL database connection settings and connect to MySQL database using mysql_connect() and mysql_select_db() functions.

20 October, 2012   

Create dynamic variables from a query or a list.