How to add new functions to MySQL

0 comments. Read How to add new functions to MySQL ( 6 pages )

Incremental MySQL Backups

Backing up a database is something that should be done regularly on a dynamic driven website. You simply never know when the server is going to crash, or your database becomes corrupted. Therefore, it is a wise decision to take precautions and backup your database as often as possible.

0 comments. Read Incremental MySQL Backups ( 1 pages )

SQL Injection - The common security breach in websites.

SQL injection is most common methodology employed by a hacker to exploit vulnerabilities in software applications. Vulnerabilities are basically weak links in the software that exposes unauthorized data/information to a user. SQL injection occurs when the user input is incorrectly filtered for embedded SQL statements.

The technique is powerful enough not only to expose the information to the user but also modify and delete the content which could prove disastrous to the company.

0 comments. Read SQL Injection - The common security breach in websites. ( 1 pages )

SQL SELECT Query Statements with GROUP BY

A collection of 20 FAQs on MySQL SELECT query statements and basic features. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views; sorting and counting query outputs; grouping outputs and applying group functions.

0 comments. Read SQL SELECT Query Statements with GROUP BY ( 1 pages )

Accessing MySQL using PERL

Starting from Perl 5 it has become very easy to write database applications using DBI. DBI stands for Database independent interface for Perl which means DBI provides an abstraction layer between the Perl code and the underlying database, allowing you to switch database implementations really easily.

0 comments. Read Accessing MySQL using PERL ( 1 pages )

Connecting to a MySQL Database Using ASP or ADO

This example describes using ASP/ADO to connect to a MySQL Database.

0 comments. Read Connecting to a MySQL Database Using ASP or ADO ( 1 pages )

Altering Existing Table Structures

How to alter the structure of a mysql database table.

0 comments. Read Altering Existing Table Structures ( 1 pages )

Creating Indexes in MySQL

This tutorial shows you how to create a primary key or index on a MySQL table field.

0 comments. Read Creating Indexes in MySQL ( 1 pages )

MySQL Column types

The basics of working with column data types in mysql. The list of column types, what they mean, and where and how to use them.

0 comments. Read MySQL Column types ( 4 pages )