Find Database Snippets


30 October, 2013   

Example code showing how to make an array of files you find

13 April, 2011   

Connecting to a MySQL database to make the data from the database available in your Web application, can be done in many different ways. Here are two often used methods.

MySQL code to find all duplicates in a database column(s)n.

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.

24 September, 2012   

Connects to a database, and runs a query

30 August, 2011   

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

I would like to find the position of the last occurrence of a character in a string and print every thing after that.

28 November, 2013   

Edit database using vb + access

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.

05 July, 2012   

Backup MySQL Database to SQL File with mysqldump

24 August, 2013   

MySQL code to find duplicate records in table

11 August, 2012   

MySQL code to find and replace string

Exam code to backup MySQL Database to SQL File

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

11 December, 2012   

MySql script to find invalid email addresses

04 February, 2015   

Finds database users with deadly system privileges assigned to them.

13 October, 2013   

To create 'examples' database on your MySQL server you should run the following script

Below shown how to Back Up and Restore a MySQL Database

29 December, 2012   

How to Back Up and Restore a MySQL Database

The below snippet will create a MySQL user and grant them all permissions on the given database.