Mysql Query Snippets


14 September, 2013   

An example for MySQL Results To Array

14 March, 2013   

PHP code example to process MySQL Timestamp

10 October, 2012   

This query will return the amount of records for the query

Note that to add a new column to the query, just add in an input box to the HTML, the PHP generates an insert for each field.

23 October, 2012   

MySQL code example for sorting data in a GRID

31 December, 2011   

MySQL's MAX aggregate function will find the largest value in a group. here shown an example

16 March, 2014   

How to create mysql table using php. The php script as follows as:

This is an example for Form Based Query

23 November, 2013   

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

05 April, 2015   

A simple PHP script that outputs data into formatted columns.

Basic Database Connection, Random Query, Display Result

11 July, 2013   

Help manage mysql database common task

01 October, 2013   

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

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

30 November, 2014   

Mysql code example for Regular Expression SELECT statement

30 September, 2012   

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

16 October, 2012   

MySQL code example to insert multiple records with one query

20 October, 2012   

Create dynamic variables from a query or a list.

07 December, 2013   

Example code for Oracle Cursor Query

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.