Right Sidebar

Pages

Tuesday, 6 November 2012

Differences between SQL and MySQL

SQL stands for "Structured Query Language", and is just a definition of a computer language ( not a computer application) that can be used to access data stored in relational databases. SQL is not itself a standalone computer application, but is rather part of many relational DB programs such as MySQL, Oracle, Sybase, Microsoft SQL Server, etc.

  • 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

    MySQL is the most popular because it is free,  because it is an open source management system, you don’t pay anything to use it.MySQL is an actual computer application you can download and install. It is the most popular open-source database management system. In addition to having an SQL interpreter, MySQL also has a database manager component, GUI database viewers, session monitoring tools, etc.


  • SQL stands for Structured Query Language. It's a standard language for accessing and manipulating databases.
    MySQL is a database management system, like SQL Server 2005, Oracle, Informix, Postgres etc. MySQL is a RDMS (Relational Database Management System). All types of RDMB use SQL.


    SQL is used to manipulate database or to create a database. It's actually a common language. MySQL is an actual computer application. You must need to download or collect it and install it. MySQL is one of the most popular open source database management system. MySQL has an SQL interpreter.
    MySQL can be used as the back engine database for several kinds of applications and it's one of the best choice for many web programmers for web-base application.
     

    0 comments:

    Post a Comment