whats the diffrerence between SQL and My SQL ?

Question

is MySQL is open source , Free for every one ?

Answer 1

SQL is a database language.

MySQL is a database server and client that use a dialect of SQL.

There is a free / open source version of MySQL.

Answer 2

Two questions?



1. Google search for similarities differences between the two.



2. Yes MySQL is open source, anyone can use it.

There is a great program here that you can use that will install Apache, MySQL and PHP on your Home PC. You can then use your PC as a Website Server for free.



http://www.appservnetwork.com

Answer 3

SQL is a query language used in order to work on database servers

where as MYSQL is a data base server



other data base server includes MSSQL, ORACLE, POSTGRESQL etc



the all use the sql to work on.



MySQL as well as POSTGRESQL is available free of cost and are opensource database servers.



--------edited to make clarification--------



also franklin

MySQL is not created by Microsoft, MS has created MSSQL.

Answer 4

MySQL is free!!!

it is a program, an application that can hold information to be used with many languages such as PHP, C++ and more....



to solve data contained in MySQL, we use a langauge called "SQL".



So, SQL is such a language.



MySQL is an APPLICATION.



:)

Answer 5

Yes MYSQL is free to everyone and it comes under open source project...



Mysql::

1).is a multithreaded, multi-user SQL database management system (DBMS).

2).The basic program runs as a server providing multiuser access to a number of databases.

3).Libraries for accessing MySQL databases are available in all major programming languages with language-specific APIs. In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. The MySQL server and official libraries are mostly implemented in ANSI C/ANSI C++.



4).MySQL is popular for web applications and acts as the database component of the LAMP, MAMP, and WAMP platforms(Linux/Mac/Windows-Apache-MySQL-PHP/Perl/Python), and for open-source bug tracking tools like Bugzilla. Its popularity for use with web application is closely tied to the popularity of PHP, which is often combined with MySQL.



5) cross platform





SQL



1)commonly expanded as Structured Query Language, is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management.



2)SQL is a set-based, declarative query language, not an imperative language such as C or BASIC. However, there are extensions to Standard SQL which add procedural programming language functionality, such as control-of-flow constructs.



3) hardly supports client server architecture....well it is mother of all advanced RDBMS(oracle,mysql,db2)



4).Common criticisms of SQL include a perceived lack of cross-platform portability between vendors, inappropriate handling of missing data (see Null (SQL)), a complex three-valued logic system, and its complex and occasionally ambiguous language grammar and semantics.







hope this helps

Cheers:)

Answer 6

actually SQL is a structured query language... My SQL is a software that has been created by microsoft... we can use SQL commands in My SQL.... My SQL is like Oracle

Answer 7

The differences will be syntax only. the logic is the same