MySQL, pronounced either "My S-Q-L" or "My Sequel," is an open source relational database management system. It is based on the structure query language (SQL), which is used for adding, removing, and modifying information in the database. Standard SQL commands, such as ADD, DROP, INSERT, and UPDATE can be used with MySQL.
In this tutorial you will know how to use SQL to access and manipulate data in myaql database. There are lots of database like- MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems.
Activities of SQL
? SQL can execute queries against a database
? SQL can retrieve data from a database
? SQL can insert records in a database
? SQL can update records in a database
? SQL can delete records from a database
? SQL can create new databases
? SQL can create new tables in a database
? SQL can create stored procedures in a database
? SQL can create views in a database
? SQL can set permissions on tables, procedures, and views
SQL is a standard language used to access data in Database Management Systems. Almost all databases implement the standard version of SQL, making it portable across database management systems.Although there are lots of version but they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner. SQL Syntext:
SELECT fieldname FROM tablename WHERE columnname <> 'Bangladesh';