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

    • profile image

      nisha 

      4 years ago

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

    • profile image

      balu 

      4 years ago

      thanks..

    • profile image

      praphulla 

      5 years ago

      thnx a lot

    • profile image

      iq 

      5 years ago

      what are the applications of MYSQL ??

      it is only use in web server??

    • profile image

      parmeshwar 

      5 years ago

      Thanks. It's nice description...

    • profile image

      ramesh 

      5 years ago

      it's nice...thanku.

    • profile image

      anujkumar 

      5 years ago

      nice

    • profile image

      husnain 

      5 years ago

      thanx

    • profile image

      amar 

      5 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

      Mark Loui U. Waffer 

      5 years ago

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

    • profile image

      lokesh 

      5 years ago

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

      it's help me very much....

    • profile image

      Ngaunje 

      5 years ago

      Thanx man it helps

    • profile image

      Syed Farhan 

      5 years ago

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

    • profile image

      Awais ALi Channa from Kotri Mohammad kabir. 

      5 years ago

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

    • profile image

      Amme 

      5 years ago

      Please give more specific.

      Thanks

    • profile image

      kay 

      5 years ago

      than x ,they were helpful.

    • profile image

      dashrath mahto 

      5 years ago

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

    • profile image

      gourav 

      6 years ago

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

    • profile image

      sampath 

      6 years ago

      thanks ,but not in detailed.....

    • profile image

      bijesh 

      6 years ago

      Nice information

    • profile image

      vijay 

      6 years ago

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

    • profile image

      Mays 

      6 years ago

      thank you :)

    • profile image

      Biswajeet 

      6 years ago

      Really helpfull with the simplest and effective way.

      Thanks

    • profile image

      sri 

      6 years ago

      Nice information

    • profile image

      madhurya 

      6 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

      vini 

      6 years ago

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

      thank u so much

    • profile image

      Satish 

      6 years ago

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

    • profile image

      komal S. 

      6 years ago

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

    • profile image

      komal 

      6 years ago

      what is the difference between oracle and sql

    • profile image

      BHOOMI 

      6 years ago

      THANK U

    • profile image

      well wisher 

      6 years ago

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

    • profile image

      manoj kumar 

      6 years ago

      thanx it is very nice difference between sql and my sql

    • profile image

      A Ghatol 

      6 years ago

      Thanks...

    • profile image

      arun 

      6 years ago

      very nice

    • profile image

      sangamesh patil 

      6 years ago

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

    • profile image

      sravani 

      6 years ago

      understood.

      but there is a confusion still about the difference.

      the information very usefull n thank u.

    • profile image

      Mayur 

      6 years ago

      Its nice i cleared my concept.

    • profile image

      Ramtin 

      6 years ago

      Thanks, very useful

    • profile image

      raj 

      6 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

      ravneet 

      6 years ago

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

    • profile image

      dhiyva 

      6 years ago

      need still clear explaination...

    • profile image

      Sona 

      6 years ago

      Thanks,information was usefull

    • profile image

      tobagur 

      6 years ago

      No one said the correct answer

    • ansonabey profile image

      ansonabey 

      6 years ago from Bangalore, India

      was searching for a good answer to this question.

      Valuable info !!

      Thanks for sharing

    • profile image

      Gulshan kumar 

      6 years ago

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

    • profile image

      Farhia 

      6 years ago

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

    • profile image

      Bishakha 

      6 years ago

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

    • profile image

      varun 

      6 years ago

      thanks dude it's use full information

    • profile image

      vinoth 

      6 years ago

      thanks.....

    • profile image

      vinoth 

      6 years ago

      thank you for the clarification need more explanation for future

    • profile image

      Balram Malav 

      6 years ago

      I agree this post.

    • profile image

      gowri 

      6 years ago

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

    • profile image

      Raju 

      6 years ago

      sql is stored the client data

      mysql is manage the every databases data

    • profile image

      raman raj verma 

      6 years ago

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

    • profile image

      vinoth 

      6 years ago

      awesome

    • profile image

      kapil 

      6 years ago

      thanks for information

    • profile image

      siva 

      6 years ago

      I understood the difference.

    • profile image

      chander 

      7 years ago

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

    • profile image

      shwetank 

      7 years ago

      sql is paid software -mysql is open source software

    • profile image

      gnanasekar 

      7 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

      Anandkumar s b 

      7 years ago

      i satisfied with the ans

    • profile image

      chalam 

      7 years ago

      Good effort, please continued....

      Thank you for your effort..

    • profile image

      pooja 

      7 years ago

      go 2 hell

    • profile image

      kabuubi fulgensio 

      7 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

      Bibin tv 

      7 years ago

      I Got A base Of These 2.

    • profile image

      deepak chaudhary 

      7 years ago

      pls make me understand the main difference between them

    • profile image

      sreekanth 

      7 years ago

      no queries all clear

      thank you

    • profile image

      rakesh miyan , sandeep gusain 

      7 years ago

      my doubt has been clear , but tell me wiyh example

    • profile image

      kajoo 

      7 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

      kajoo 

      7 years ago

      eshta 3alek :D

    • profile image

      DORS 

      7 years ago

      VERY CLEAR...THANK YOU!!!

    • profile image

      Bds prakash 

      7 years ago

      thaks it's a clarification to me

    • profile image

      NIRMAL 

      7 years ago

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

    • profile image

      sunil 

      7 years ago

      ya thanks for the difference.

    • profile image

      mathi 

      7 years ago

      very nice ans

      rajeshc urs ans is right

    • profile image

      rajeshc 

      7 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

      rajeshc 

      7 years ago

      Nice, I understood the difference:)

    • profile image

      kumar 

      7 years ago

      it is answer easy to help, and so thanks

    • profile image

      niraj 

      7 years ago

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

    • profile image

      niraj 

      7 years ago

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

    • profile image

      rajesh chaparala 

      7 years ago

      pls explain some points

    • profile image

      Liju 

      7 years ago

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

    • profile image

      911 

      7 years ago

      Thanks for the info, its pretty clear.

    • profile image

      mahfy 

      7 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

      SIVAN RAJ C 

      7 years ago

      SIMPLE DIFF IS

      SQL IS FRONT END

      MYSQL IS BACK END

    • profile image

      vengadesh  

      7 years ago

      now only clear about sql and mysql thanks for your guid

    • profile image

      Mahendra 

      7 years ago

      thanx...

      its really useful...

    • profile image

      Amit 

      7 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

      yogesh 

      7 years ago

      thanx

      it's very effective

    • profile image

      kiran 

      7 years ago

      Thanx.... i was satisfied

    • profile image

      sunayana 

      8 years ago

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

    • profile image

      ANUJ 

      8 years ago

      i need that satisfied

    • profile image

      myai.. 

      8 years ago

      thanks...now it's clear

    • profile image

      Rajesh GY 

      8 years ago

      Very nice and easily understandable

    • profile image

      ashish 

      8 years ago

      i was looking for this such a simple difference.

    • noorin profile image

      noorin 

      8 years ago from Canada

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

    • profile image

      ganesh 

      8 years ago

      thank you !

      I was needy of this Ans.

    • profile image

      kiran darekar 

      8 years ago

      thank now i know the difference

    • profile image

      Geetika sharma 

      8 years ago

      Thanx for Difference B'caz bit of know that

    • profile image

      ramkishor sahu 

      8 years ago

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

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)