MySQL Database Tutorial

Introduction: MySQL The MySQL database package consists of the following: 1. The MySQL server: This is the heart of MySQL. You can consider it a program that stores and manages your databases. 2. MySQL client programs: MySQL comes with many client programs. The one with which we'll be dealing a lot is called mysql (note: smallcaps). This provides an interface through which you can issue SQL statements and have the results displayed. 3. MySQL client Library: This can help you in writing client programs in C. (We won't be taking about this in our tutorial). Creating MySQL database on Windows system 1. Invoke the mysql client program by typing mysql at the prompt. 2. The prompt is changed to a mysql> prompt. Type: create database employees;