MYSQL Info

1. 1. Basics Of MySQL
2. 2. * What is MySQL? MySQL is a open source Relational Database Management System. MySQL is very fast reliable and flexible Database Management System. It provides a very high performance and it is multi threaded and multi user Relational Database management system.
3. 3. * Installing MySQL on Windows In this section you will learn how to install MySQL 5.0 on windows system. The MySQL 3.21 was the first version for the windows. Windows installer of MySQL includes auto installer with Configuration Wizard that support for easy installation.
4. 4. * MySQL Configuration In this lesson you will read about the configuration of MySQL . The MySQL server configuration normally started during installation process .
5. 5. * Creating account, changing root password and deleting anonymous accounts This MySQL provide the new creating account or you want to change the password then make new user .This lesson you learn how to create new password.
6. 6. * Understanding various MySQL Executable files This lesson you learn how to the execute mysql file. MySQL Provide the executable file and uses the MySQL Client interactive file by this command "shell> mysql db_name ".
7. 7. * MySQL User Interfaces In this section you will read how to define the function Interface, Create function syntax , Drop function Syntax. You can add function with the help of UDF (user defined function) interface. These are complied as object files. After that they can be added to and removed from the server dynamically by using create and Drop function statements.
8. 8. * MySQL Monitoring In this section you can learn how to monitor the MySQL Database. MySQL system store the all of the critical data and easy to maintenance in every cases. It is very popular database and make quick easy to store or its access, and update Data. Working with MySQL Database
9. 9. * Creating/Deleting databases In this section you will learn how to create and delete the database in MySQL. MySQL provides the both commands. In this section you can learn the following things : Creation and Selection of database, Creation of table, Load the data into the table.
10. 10. * MySQL Column type database In this session you will learn how to support number of column in MySQL . MySQL supports the numeric type , Date and time type, and String type (char) database.
11. 11. * Database Designing There are some rules are available for designing the database. These are : MySQL use the alpha numeric character, MySQL limited the 64 characters, MySQL use the underscore (_) to separate word, MySQL is entirely lowercase word, MySQL use the plural table name to indicate multiple value store and singular column names. In this section you will also learn about the Normalization.
12. 12. * Identifiers & Qualifiers In this section you will learn about describing the allowable syntax for identifiers in MySQL. The identifiers are Database, table, index, column and alias name. The following table describes the maximum length for each type of identifier.
13. 13. * Operators & Functions In this section we are describing the function and operators, which are allowed for writing expressions in MySQL. If any expression, which contains NULL then it always produce a NULL value unless else indicated in the documentation for a particular function or operator.
14. 14. * MYSQL String function In this section you can learn about the uses of MySQL String functions. These functions can be used to manipulate the string data. Here we have compiled the almost all String functions that you can use to learn more about string functions supported by MySQL. MySQL Queries
15. 15. * SELECT Statement In this lesson you will be learn how to use SELECT statement in MySQL and you can also learn how to use SELECT statement with WHERE clause. The SELECT statement is used to retrieve the records from the table.
16. 16. * Selecting All columns or specific columns In this section you will be learn how to create database and create a specific columns in MySQL. And you can also learn about Evaluation and Writing Expression.
17. 17. * Data Definition Statements In this section we will describe you the syntax of most of the Data Definition statements supported by MySQL like CREATE DATABASE, CREATE TABLE, ALTER DATABASE, ALTER TABLE etc...
18. 18. * Data Manipulation Statements Data Manipulation Statement is used to retrieve, insert, update and delete the records in a database. All database users will use these commands during routine operation of the database. In this section we are describing the all Data Manipulation Statements :
19. 19. * Joins When you select the data from more than one table this is known as Joining. A join is a SQL query that is used to select the data from more than one table or views. When you define multiple tables or views in the FROM clause of a query the MySQL performs a join that linking the rows from multiple tables together.
20. 20. * Views VIEW is a virtual table, which acts like a table but actually it contains no data. That is based on the result set of a SELECT statement. A VIEW consists rows and columns from one or more than one tables. A VIEW is a query that?s stored as an object. A VIEW is nothing more than a way to select a subset of table?Columns