Ever wanted to create an unlimited levels menu using PHP and MySQL in Dreamweaver? Things are easier than it sounds if you use the Creative DW Menu Pack developer extension – you just need a database and the extension will do the rest.

Many people tell me they aren’t very fond of scripts, because the install frightens them a bit. And it’s true: creating a database, importing tables, your site’s root path… if you don’t know what you’re doing, this looks pretty complicated.

Most web servers uses MySQL data base to store data for thier websites. Some website with high traffic makes very strong load of MySQL data base servers.

In this tutorial I will give you example configuration to setup cross-server replication in MySQL. The normal replication concept is pretty much explained in the term so I will not focus much on it.

In tis tutorial we will show you some very basic SQL queries for extracting the exact information that we need from our database.

We will continue from our previous tutorial for How to Import Excel XLS file into MySql database into the exact solution of the problem - Converting the file into CSV (Comma Separated Value) and next easily importing into MySql.

Quite often all of us have to get the data from some Excel table and to fill into MySql database. There is not implemented such standard converting features both on MS Excel and MySql server.

In this tutorial I will show you how to use Group By Function in MySql. Group by is very powerful function which can help you to get an result from MySql database in very specific view, format and order.

To be honest this won’t be a tutorial, but a list with useful MySQL commands common used to create, mange and maintain MySQL databases, as well as many PHP and Perl API functions you can use to interface with MySQL.

Recently I used to be in a group that had a task to migrate few servers without downtime, and by mistake made by one of our system administrators one of the servers went live with outdated database.

SQL wildcards are used when searching for data in a database. They can substitute one or more characters when working with string types.

This tutorial will show you how to restore MS SQL database a backup on a new server. I presume you have backup file already.

This is the fourth part of MS SQL backup maintenance plan tutorial, and continues from Create MS SQL Shrink Databases Task one.

This is the third part of MS SQL backup maintenance plan tutorial and continues from Create MS SQL Back Up Database Task.

This is the second part of MS SQL backup maintenance plan tutorial. Here we will discuss how to create and setup MS SQL Back Up Database Task.

Probably one of the worst things that can happen is to loose data especially a database which is dynamically changed.

Basically stored procedures are functions that you can create in a database and use multiple times. Using stored procedures is considered a good practice and holds many advantages.

This tutorial is about how to create, update and delete views in MS SQL 2008. In SQL views are basically virtual tables based on the result of some SQL statement.

The UNION, EXCEPT and INTERSECT operators can be used to provide a single result set from multiple SQL queries.

This how-to is about how to create database diagrams using MS SQL Server Sometimes the best way to visualize data is by using a diagram.