Differences between SQL and MySQL
By rancidTaste
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
Recent Pages of itis123
- How to install Twitter widget into your blog?
Twitter, is becoming very popular day-by-day and a free social messaging utility for staying connected in real-time with your friends.
- How to add "Top of the page" icon to your blog?
"Top of the page" icon link is an important thing if your blog post is long.
- How to find out and change the size of your blog's header image?
Blogger header image gives the uniqueness of your blog among the millions of blogs.
- Troubleshooting
If you are a compute user, then you may face several types of problems at different times.
- ESET NOD32
Virus, Malware, Trojan, Worm, Spyware, Adware, Botnet etc.
- NOD32 keys
ESET NOD32 is one of the best effective and most proactive antivirus software and malware protection.
- How to Get Free ESET NOD32 Antivirus Key And Password
Different antivirus software are used to protect our PC form virus.
- Changing Your Blog's Header Image
You can easily add your favorite image or photo as a blog's header image.
rancidTaste's Recent Pages
- Drawing a line: How to draw a line using HTML 5?
HTML5 canvas API provides basics tools and great supports to draw and style different types of sub paths including lines, arcs, Quadratic curves, and Bezier curves, as well as a means for creating paths by connecting sub paths. - 5 days ago
- SEO Pages
SEO, Search Engine Optimization and Keywords - these common three terms are the brainstorming terms for any content publisher, seo company, seo service provider, seo researcher, seo firm, seo consultant, seo professional or other seo lover. - 3 months ago
- WordPress.org vs. WordPress.com: An explained comparison between WordPress.org an WordPress.com
WordPress is a common name but do you know that there are two things: WordPress. - 3 months ago
- Creating database from cpanel: How to create a database from cpanel hosting?
A step by step full tutorial to create a database from cpanel hosting account for any dynamic website. - 3 months ago
- Natural Join in Database: Retrieving records from more than one table with Natural Joins
Natural Join is one of the sql joining. - 3 months ago
- Explanation of SQL Join: Obtaining data from multiple tables using Join
Explanation of SQL Join: Obtaining data from multiple tables using Join. - 3 months ago
- How to solve "CreateFile error 32 when trying set file time" Error During Oracle Installation
Solution of the Oracle installation problem on Windows 7 / Windows XP during Oracle installation start-up. - 3 months ago
- A Brief Explanation of SQL Statements and Classification
Any type of database is based on several statements. - 3 months ago
Comments
my understanding on the above description: as you install My SQL, "SQL" interpreter will come along with the product.
nice
i am reading and learning the sql and mysql server
thank you for posting!
iam reading sql and mysql
Give the exact diference ok!
ya its useful:)
but pls give the main difference...
Nice tutorial, now I know the the exact difference.
Thanks,
Hey, I have one question. If MySQL is interprets SQL, then can we create table is MySQL?
Not clear about difference.
superb man great love it
well nice ... sql is language and mysql is a system ... ( Got the difference ........ the above ones )
excellent. simple language. to the point
thank you... it helped.
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...
Kidillam...
thanks a lot...understood the difference...
MORE EXPLANATION IS REQUIRED
yes....this is the main difference i satified ....thanks
Thanx for Difference B'caz bit of know that
thank now i know the difference
thank you !
I was needy of this Ans.
Thanks rancidTaste. Helpful hub, rated it up and looking forward for more of ur technical hubs. =)
i was looking for this such a simple difference.
Very nice and easily understandable
thanks...now it's clear
i need that satisfied
Thanks..i never knew this even after having my engg degree...very nicely explained...
Thanx.... i was satisfied
thanx
it's very effective
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.
thanx...
its really useful...
now only clear about sql and mysql thanks for your guid
SIMPLE DIFF IS
SQL IS FRONT END
MYSQL IS BACK END
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.
Thanks for the info, its pretty clear.
thanks 4 ur nice ans..............
pls explain some points
it's answer help me to complete my pratical question ....
it's answer help me to complete my pratical question ....
it is answer easy to help, and so thanks
Nice, I understood the difference:)
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.
very nice ans
rajeshc urs ans is right
ya thanks for the difference.
Thanks, i think now it's clear..................
thaks it's a clarification to me
VERY CLEAR...THANK YOU!!!
eshta 3alek :D
You're not comparing the same things.
SQL is a language. Specifically, the "Structured Query Language".
MySQL is one of several database systems..
my doubt has been clear , but tell me wiyh example
no queries all clear
thank you
pls make me understand the main difference between them
I Got A base Of These 2.
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
go 2 hell
Good effort, please continued....
Thank you for your effort..
i satisfied with the ans
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....
sql is paid software -mysql is open source software
I was more looking for the syntactical differences rather than general differences.
I understood the difference.
thanks for information
awesome
thanx for the info.............
sql is stored the client data
mysql is manage the every databases data
thank you for this answers and i need sample code or Queries show in website or this post next time
I agree this post.
thank you for the clarification need more explanation for future
thanks.....
thanks dude it's use full information
I got my answer....... and it is really useful.... Thanks....
I got very usefull article that suitable in mysql and sql thank u.
Thanks Rancid for the clarification & i satisfied with your answer.
was searching for a good answer to this question.
Valuable info !!
Thanks for sharing
No one said the correct answer
Thanks,information was usefull
need still clear explaination...
sql and mysql both are the application software to manage the database then why we moved to the mysql?
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
Thanks, very useful
Its nice i cleared my concept.
understood.
but there is a confusion still about the difference.
the information very usefull n thank u.
sir i want to know what is the difference between sql and my sql syntax.
very nice
Thanks...
thanx it is very nice difference between sql and my sql
informative one...thanx for ur helping mentality..may god bless u...
THANK U
what is the difference between oracle and sql
Very good explaination about mysql............
Nice info. As said, thumbs up to you :)
thanxxxxxxxxxxxxxxxxxxxxxx....now i understand the diff b/w sql & mysql.
thank u so much
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
Nice information
agvulpes 3 years ago
Thanks rancidTaste that cleared up my query.