Tag: database

MYSQL VIEW Query

Mysql support view from version 5.x, View features gives the sign of SQL standard 2003. View is nothing but a virtual table on based on result set of an MYSQL statement. Its also have rows and column like a real table but the field s in view may be one or more than one tables in the same database. we can apply MYSQL function on view it seems like a single table. View queries process in two wa

Basic of MySQL

MYSQL is a database as other databases like MS Excel,MS-SQL,ORACAL,PL-SQL .MYSQL is freeopen source database management system .It has good reputation in terms of performance , reliability,and ease of use.MySQL is most popular now a days. A Database is nothing but storage place to keep things for security and further use. Technologically a database is a place to store information. As informatio