MySQL is (as of July 2013) the world's most widely used open-source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases, though SQLite probably has more total embedded deployments. It is named after co-founder Michael Widenius's daughter, My. The SQL phrase stands for Structured Query Language.
MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other “AMP'' stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python." Free-software-open source projects that require a full-featured database management system often use MySQL.
For commercial use, several paid editions are available, and offer additional functionality. Applications which use MySQL databases include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software. MySQL is also used in many high-profile, large-scale websites, including Wikipedia, Google (though not for searches), Facebook, Twitter, Flickr, and YouTube.
Figure: MySQL command prompt window
Project:
This paper is on making some accounting package using various functions and commands of MySQL. The report envisages producing Sales Book and Purchase Book using MySQL.
Before starting the main discussions, a brief description of Sales and Purchase book is needed.
Sales Book:
Sales book records daily sales records. It takes into consideration the return units. Thus we can get Net Sales by subtracting Total Sales Return from the Total Sales amount.
Purchase Book:
Purchase book records daily purchase records. Like sales book it calculates Net Purchase by subtracting Total Purchase Return from the Total Purchase.
For the project, the requirements are as follows-
A Database and
Several tables
So we will prepare-
A database named “California” (any other name will also do)
Tables named-
Inventory
Sales and