Welcome. This MySQL tutorial is a guide for new MySQL users, providing a reference of very basic , step by step, instructions on how to get started. This MySQL help page also gives more advanced users assistance in upgrading and running multiple versions of MySQL on a computer at the same time.

MySQL is an SQL based relational database management system (DBMS) that runs under a broad array of operating systems. MySQL is frequently used by PHP and Perl scripts. The SQL commands discussed in this tutorial apply to MySQL operating under all operating systems. Only the installation instructions are Windows specific. The focus is on Windows XP Professional and Windows 2000 Professional machines.

We'll be covering the installation of MySQL versions 5.0.18, 4.1.16 and 4.0.21 as well as how to configure everything so they'll all be able to run on your system at the same time. Plus, the data directories will be moved to another location in order to make backups easier. If you only want to install one version of MySQL, ignore the instructions relating to the other versions.

If your operating system or versions of MySQL are different, the instructions should still work, but keep an eye out for slight differences, like which working directory you'll need to be in.

Contents

• Introduction:- MySQL is the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create dynamic and powerful server applications. here some introduction about Mysql.
• Windows 2000 and Windows XP Installation:-Here steps for Upgraging and Installing of Windows 2000 and Windows XP.
• Quick Tips for Other Windows Operating Systems:-Here some Tips for Other Windows Operating Systems for Upgraging and Installing
• Start the Client:- Here some steps for How to Start the Client.Here Syntax is also given to Start the Client
• Tighten Security:- MySQL has good security controls, but the default installation is wide open. Here We Discuss security Issues of MySql
• Creating a Simple Database and Displaying its Structure:-In this section of the MySQL tutorial we will learn how to create a database.The commands for creating a database in Windows and Linux are the same. However, the prelimnary commands in Linux are slightly more complex. Since this tutorial is meant for the complete newbie,We will discuss the Windows and Linux systems separately.
• Putting Data into a Table:- Here some steps for Inserting data in MySQL tables. The INSERT SQL statement impregnates our table with data. Here is a general form of INSERT.
• Adding Fields:- Here some steps for Adding Fields in MySQL tables.We can add one field at a time or more than one field at a time
• MySql Join:- we have only been getting data from one table at a time. This is fine for simple takes, but in most real world MySQL usage you will often need to get data from multiple tables in a single query. The act of joining in MySQL refers to smashing two or more tables into a single table
• Multi-line Command Entry:- Here We Discuss the Multi-line Command Entry. The MySQL command line interface allows you to put a statement on one line or spread it across multiple lines. There's no difference in syntax between the two
• Insert Some More Records into the Table:- MySQL has a useful command buffer With the use of this we can Insert Some More Records into the Table
• Updating Existing Records:- Here some steps for updates the data in tables . The SQL UPDATE command updates the data in tables. Its format is quite simple
• Deleting Records:- Here some steps for Deleting entries from tables. The SQL delete statement requires the table name and optional conditions for Delecting Records.
• Time to Call it Quits
• In Closing