ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Differences between SQL and MySQL

Updated on July 13, 2011

Many programmer and many students have a little confusion about the difference between SQL and MySQL. It's a common question to the new programmer about the differences between them. If you browse several blog or blog posts or forum posts related to SQL and MySQL, you may notice several questions like What is the difference between SQL and MySQL? or What is the main difference SQL and MySQL? or Mention the simple difference between SQL and MySQL. or Is SQL is a part of MySQL? or Why MySQL differs from SQL? or Does SQL and MySQL are the same? etc. To answers this type of questions, this page is written. Moreover, most interview board asks these type of questions at the interview time. So, to know about these types of question's answers, just read the followings...

Differences between SQL and MySQL

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.

All these are the differences between SQL and MySQL. If you want to mention further differences, you may add them to the comment section.

© Written by rancidTaste

If you are enjoyed this post, please consider to give a thumbs up and leave a comment. You may Subscribe to rancidTaste's RSS feed to get new pages which will be delivered to your feed reader. You can also read more hubs by rancidTaste.

Want to express your knowledge and ideas, click here to join Hubpages.

It's simple, just like 1-2-3

Comments

    0 of 8192 characters used
    Post Comment

    • agvulpes profile image

      Peter 7 years ago from Australia

      Thanks rancidTaste that cleared up my query.

    • profile image

      deepak 7 years ago

      my understanding on the above description: as you install My SQL, "SQL" interpreter will come along with the product.

    • profile image

      ccc 7 years ago

      nice

    • profile image

      thiyagarajan 7 years ago

      i am reading and learning the sql and mysql server

    • profile image

      7 years ago

      thank you for posting!

    • profile image

      bala murugan.R 7 years ago

      iam reading sql and mysql

    • profile image

      Welwisher 7 years ago

      Give the exact diference ok!

    • profile image

      selgovdeeprag 7 years ago

      ya its useful:)

      but pls give the main difference...

    • profile image

      Pooja 7 years ago

      Nice tutorial, now I know the the exact difference.

      Thanks,

    • profile image

      pankaj 7 years ago

      Hey, I have one question. If MySQL is interprets SQL, then can we create table is MySQL?

    • profile image

      James Chiran 6 years ago

      Not clear about difference.

    • profile image

      umar 6 years ago

      superb man great love it

    • profile image

      kainat 6 years ago

      well nice ... sql is language and mysql is a system ... ( Got the difference ........ the above ones )

    • profile image

      nishant 6 years ago

      excellent. simple language. to the point

    • profile image

      STUDENT 6 years ago

      thank you... it helped.

    • profile image

      Boopathi 6 years ago

      well.. it is nice ans... i know mysql and sql(basic).. i expect more ans... ple contact my id boopathi.info@yahoo.in .. thank you...

    • profile image

      MF 6 years ago

      Kidillam...

    • profile image

      akshar 6 years ago

      thanks a lot...understood the difference...

    • profile image

      HAROON 6 years ago

      MORE EXPLANATION IS REQUIRED

    • profile image

      ramkishor sahu 6 years ago

      yes....this is the main difference i satified ....thanks

    • profile image

      Geetika sharma 6 years ago

      Thanx for Difference B'caz bit of know that

    • profile image

      kiran darekar 6 years ago

      thank now i know the difference

    • profile image

      ganesh 6 years ago

      thank you !

      I was needy of this Ans.

    • noorin profile image

      noorin 6 years ago from Canada

      Thanks rancidTaste. Helpful hub, rated it up and looking forward for more of ur technical hubs. =)

    • profile image

      ashish 6 years ago

      i was looking for this such a simple difference.

    • profile image

      Rajesh GY 6 years ago

      Very nice and easily understandable

    • profile image

      myai.. 6 years ago

      thanks...now it's clear

    • profile image

      ANUJ 6 years ago

      i need that satisfied

    • profile image

      sunayana 6 years ago

      Thanks..i never knew this even after having my engg degree...very nicely explained...

    • profile image

      kiran 6 years ago

      Thanx.... i was satisfied

    • profile image

      yogesh 6 years ago

      thanx

      it's very effective

    • profile image

      Amit 6 years ago

      this was the question asked i was been asked in interview,,i was unable to answer it there.after reading this I got to know abt it.thanks for share.

    • profile image

      Mahendra 6 years ago

      thanx...

      its really useful...

    • profile image

      vengadesh  6 years ago

      now only clear about sql and mysql thanks for your guid

    • profile image

      SIVAN RAJ C 6 years ago

      SIMPLE DIFF IS

      SQL IS FRONT END

      MYSQL IS BACK END

    • profile image

      mahfy 6 years ago

      thanks for sharing this knowledge now i got to knw the difference actually this was asked in my viva after that i desperate to knw this.

    • profile image

      911 6 years ago

      Thanks for the info, its pretty clear.

    • profile image

      Liju 6 years ago

      thanks 4 ur nice ans..............

    • profile image

      rajesh chaparala 6 years ago

      pls explain some points

    • profile image

      niraj 6 years ago

      it's answer help me to complete my pratical question ....

    • profile image

      niraj 6 years ago

      it's answer help me to complete my pratical question ....

    • profile image

      kumar 6 years ago

      it is answer easy to help, and so thanks

    • profile image

      rajeshc 6 years ago

      Nice, I understood the difference:)

    • profile image

      rajeshc 6 years ago

      Hi SIVAN RAJ C

      Your answer is

      SQL IS FRONT END

      MYSQL IS BACK END

      But it's not true.

      SQL is Common Language. Its a interpreter for MYSQL. So your answer is wrong.

    • profile image

      mathi 6 years ago

      very nice ans

      rajeshc urs ans is right

    • profile image

      sunil 6 years ago

      ya thanks for the difference.

    • profile image

      NIRMAL 6 years ago

      Thanks, i think now it's clear..................

    • profile image

      Bds prakash 6 years ago

      thaks it's a clarification to me

    • profile image

      DORS 6 years ago

      VERY CLEAR...THANK YOU!!!

    • profile image

      kajoo 6 years ago

      eshta 3alek :D

    • profile image

      kajoo 6 years ago

      You're not comparing the same things.

      SQL is a language. Specifically, the "Structured Query Language".

      MySQL is one of several database systems..

    • profile image

      rakesh miyan , sandeep gusain 6 years ago

      my doubt has been clear , but tell me wiyh example

    • profile image

      sreekanth 6 years ago

      no queries all clear

      thank you

    • profile image

      deepak chaudhary 5 years ago

      pls make me understand the main difference between them

    • profile image

      Bibin tv 5 years ago

      I Got A base Of These 2.

    • profile image

      kabuubi fulgensio 5 years ago

      thanks a bunch....i understand the difference now...now that i have also read abt sqlplus where sql commands are executed against oracle db , its very clear to me

    • profile image

      pooja 5 years ago

      go 2 hell

    • profile image

      chalam 5 years ago

      Good effort, please continued....

      Thank you for your effort..

    • profile image

      Anandkumar s b 5 years ago

      i satisfied with the ans

    • profile image

      gnanasekar 5 years ago

      nice one,

      sql is a database but,

      mysql is managing all database management...

      one more doubt,wht is differance between oracle and sql..pls post as soon possible....

    • profile image

      shwetank 5 years ago

      sql is paid software -mysql is open source software

    • profile image

      chander 5 years ago

      I was more looking for the syntactical differences rather than general differences.

    • profile image

      siva 5 years ago

      I understood the difference.

    • profile image

      kapil 5 years ago

      thanks for information

    • profile image

      vinoth 5 years ago

      awesome

    • profile image

      raman raj verma 5 years ago

      thanx for the info.............

    • profile image

      Raju 5 years ago

      sql is stored the client data

      mysql is manage the every databases data

    • profile image

      gowri 5 years ago

      thank you for this answers and i need sample code or Queries show in website or this post next time

    • profile image

      Balram Malav 5 years ago

      I agree this post.

    • profile image

      vinoth 5 years ago

      thank you for the clarification need more explanation for future

    • profile image

      vinoth 5 years ago

      thanks.....

    • profile image

      varun 5 years ago

      thanks dude it's use full information

    • profile image

      Bishakha 5 years ago

      I got my answer....... and it is really useful.... Thanks....

    • profile image

      Farhia 5 years ago

      I got very usefull article that suitable in mysql and sql thank u.

    • profile image

      Gulshan kumar 5 years ago

      Thanks Rancid for the clarification & i satisfied with your answer.

    • ansonabey profile image

      ansonabey 5 years ago from Bangalore, India

      was searching for a good answer to this question.

      Valuable info !!

      Thanks for sharing

    • profile image

      tobagur 5 years ago

      No one said the correct answer

    • profile image

      Sona 5 years ago

      Thanks,information was usefull

    • profile image

      dhiyva 5 years ago

      need still clear explaination...

    • profile image

      ravneet 5 years ago

      sql and mysql both are the application software to manage the database then why we moved to the mysql?

    • profile image

      raj 5 years ago

      Ravneet sql is structured query language and mysql in a computer application which uses sql interpreter means mysql uses sql queries to manage the database

    • profile image

      Ramtin 5 years ago

      Thanks, very useful

    • profile image

      Mayur 5 years ago

      Its nice i cleared my concept.

    • profile image

      sravani 5 years ago

      understood.

      but there is a confusion still about the difference.

      the information very usefull n thank u.

    • profile image

      sangamesh patil 5 years ago

      sir i want to know what is the difference between sql and my sql syntax.

    • profile image

      arun 5 years ago

      very nice

    • profile image

      A Ghatol 5 years ago

      Thanks...

    • profile image

      manoj kumar 5 years ago

      thanx it is very nice difference between sql and my sql

    • profile image

      well wisher 4 years ago

      informative one...thanx for ur helping mentality..may god bless u...

    • profile image

      BHOOMI 4 years ago

      THANK U

    • profile image

      komal 4 years ago

      what is the difference between oracle and sql

    • profile image

      komal S. 4 years ago

      Very good explaination about mysql............

    • profile image

      Satish 4 years ago

      Nice info. As said, thumbs up to you :)

    • profile image

      vini 4 years ago

      thanxxxxxxxxxxxxxxxxxxxxxx....now i understand the diff b/w sql & mysql.

      thank u so much

    • profile image

      madhurya 4 years ago

      i am not a IT student i don't under stand what are these terms back end. if you don't mine can you explain clearly, i am new to sql

    • profile image

      sri 4 years ago

      Nice information

    • profile image

      Biswajeet 4 years ago

      Really helpfull with the simplest and effective way.

      Thanks

    • profile image

      Mays 4 years ago

      thank you :)

    • profile image

      vijay 4 years ago

      thank you. Now i knew the difference between sql & mysql

    • profile image

      bijesh 4 years ago

      Nice information

    • profile image

      sampath 4 years ago

      thanks ,but not in detailed.....

    • profile image

      gourav 4 years ago

      Thanks... Sir.. I come iut from my Enigma...

    • profile image

      dashrath mahto 4 years ago

      thanks ..........i hope it will be more detail

    • profile image

      kay 4 years ago

      than x ,they were helpful.

    • profile image

      Amme 3 years ago

      Please give more specific.

      Thanks

    • profile image

      Awais ALi Channa from Kotri Mohammad kabir. 3 years ago

      SQL is the product of Microsf and MySql is the open sourse.

    • profile image

      Syed Farhan 3 years ago

      Thanks for removing such type of minor confusion in a lucid manner.

    • profile image

      Ngaunje 3 years ago

      Thanx man it helps

    • profile image

      lokesh 3 years ago

      thank You for clear difference between both .(sql & mysql)

      it's help me very much....

    • profile image

      Mark Loui U. Waffer 3 years ago

      The explanation is very good i really like the news about MySQL has an SQL interpreter.:)

    • profile image

      amar 3 years ago

      Difference Between MySQL and Oracle

      . MySQL is an open source database system whereas Oracle is a RDBMS developed by Oracle Corporation.

      . MySQL supports more platforms as compared to Oracle database.

      . Oracle – doubles DBA productivity, eliminates data center redundancy and maximizes availability, consolidates and clusters enterprise applications onto scalable, fast and reliable private clouds, reduces the risk of change by doubling the DBS productivity

      . MySQL – high reliability, ease of use, high performance, provides wide variety of database tools, services, training and support

      . Both the databases come in different editions

      Read more: http://www.differencebetween.com/difference-betwee...

    • profile image

      husnain 3 years ago

      thanx

    • profile image

      anujkumar 3 years ago

      nice

    • profile image

      ramesh 3 years ago

      it's nice...thanku.

    • profile image

      parmeshwar 3 years ago

      Thanks. It's nice description...

    • profile image

      iq 3 years ago

      what are the applications of MYSQL ??

      it is only use in web server??

    • profile image

      praphulla 3 years ago

      thnx a lot

    • profile image

      balu 3 years ago

      thanks..

    • profile image

      nisha 2 years ago

      well it is nice ans....but i need more information

    Click to Rate This Article