SQL vs MySQL | 3 Key Differences

Sdílet
Vložit
  • čas přidán 8. 09. 2024
  • SQL and MySQL are popular languages that are used in most large companies like Netflix and Google. Here are a few differences and how you can leverage them
    SQL is a query language used to access data from any database. MySQL is a relational DBMS used to manage databases.
    To use SQL, one needs to learn the basics first (grammar, syntax etc just like any other language). MySQL needs no such thing.
    SQL is the language used by many database management systems such as MySQL, PostgreSQL, Oracle etc. MySQL is itself a DBMS based on the SQL language.
    Interested in learning more about SQL? Head over to Scaler CZcams for a free session.
    #sqlvsmysql #sql #mysql

Komentáře • 198

  • @Prathamesh1712
    @Prathamesh1712 Před 2 lety +620

    Why u making it complicated to this folks.. In simple SQL is query Language and MySQL is software like SQL Server, Oracle, Netizza, Teradata,Postgre, Datastage etc. & All this Software uses SQL.

  • @predator315
    @predator315 Před 3 měsíci +95

    Other differences :
    1. SQL has 3 letters whereas MySQL has 5 letters.
    2. SQL is independent & MySQL is mine.
    3. SQL has all upper case letters & MySQL has one lower case letter.

  • @adityakamal
    @adityakamal Před 2 lety +219

    When you're from CBSE board and didn't evolve.

  • @larslover6559
    @larslover6559 Před 11 měsíci +59

    3 key difference between an orange tree and an orange:

  • @sameermd5779
    @sameermd5779 Před 2 lety +433

    There is Dolphin 🐬 in mysql and sql had no dolphin

  • @hassan.razzaq
    @hassan.razzaq Před rokem +59

    SQL has all uppercase letters S Q L, while MySQL contains one lower case letter "y" which makes it very unique.

  • @avinashvoleti5522
    @avinashvoleti5522 Před rokem +21

    MYSQL is service provider
    SQL is query language
    Real time example network:4g which is SQL
    Providers Airtel, BSNL , jio

  • @jefffloyd7608
    @jefffloyd7608 Před 2 lety +186

    This comparison is ridiculous it's like comparing French to France

  • @aspectoflife
    @aspectoflife Před měsícem +2

    compact, comprehensive and confident presenter...well done

  • @freudsilver3097
    @freudsilver3097 Před 8 měsíci +9

    It is like saying, here are 3 differences between Python and Visual studio code

  • @ayushsinghrathore360
    @ayushsinghrathore360 Před 2 lety +85

    You are a person who can differentiate between human and it's body 👅😂🔥 (MySQL is subset of SQL) No bakwaas 😂

    • @harshavardhanj2970
      @harshavardhanj2970 Před 2 lety +2

      Bro i thought both SQL and MySQL are same
      But suddenly some saying Both aRe different

    • @blablablabla29
      @blablablabla29 Před rokem +5

      ​@@harshavardhanj2970 MySQL is a software in that SQL language is used...ye scalar walo ko kuch pata nahi shayad..😂😂

    • @harshavardhanj2970
      @harshavardhanj2970 Před rokem +1

      @@blablablabla29 naan kuda adhaan nenachen

    • @blablablabla29
      @blablablabla29 Před rokem +1

      @@harshavardhanj2970 ??

  • @svmgupta528
    @svmgupta528 Před 2 lety +11

    Wow... what a good speaker you are..!!

  • @sudharshan_reddy_kakarla
    @sudharshan_reddy_kakarla Před 2 lety +44

    First of all they are not comparable. Because SQL is a Language to mange the data in the Data base
    Where as My SQL is Data Base (Relational DB) which is used to store data
    First tell that ✅

  • @chetuck821
    @chetuck821 Před 11 měsíci +1

    Sql is a structure query language.we used to manage the data in the database and you can do this thing in sql like you can creat table , update ,inserted these things happening in sql
    And its programming languages to communicate with the database that enough to understand anyone what is the sql.
    Mysql is the relation database management system you can store the information into RDBMS.
    May be help us to easier to find any information any another employees

  • @user-ok2cz3kt2j
    @user-ok2cz3kt2j Před 10 měsíci +1

    SQL is developed by IBM and MySQL is developed by MySQL AB and now owned by oracle.

  • @cosmicresonance7960
    @cosmicresonance7960 Před 9 dny

    Thanks.... It can be confusing for beginners,

  • @beingnatural7425
    @beingnatural7425 Před 11 měsíci +18

    It amazes me how crazy people are about western accents!

    • @aniketdev1157
      @aniketdev1157 Před 9 měsíci +1

      I think it's because wealthiest people are from western side and we think their culture are richer hence attracts us more otherwise i don't think there is any logical reason behind that! But deep down we know nothing is greater than the Indian culture

    • @beingnatural7425
      @beingnatural7425 Před 9 měsíci

      @@aniketdev1157 Yes probably..

    • @blaisemomin1106
      @blaisemomin1106 Před 8 měsíci

      She's got an Indian accent

    • @RoarMaddy
      @RoarMaddy Před 7 měsíci

      It is necessary to work with foreign entities.

    • @beingnatural7425
      @beingnatural7425 Před 7 měsíci

      @@RoarMaddy So does English change after a specific pronunciation?? What do they need, a communication medium or a specific accent??

  •  Před 3 měsíci +1

    It is like saying, here are 3 differences between compiler and python

  • @Aliana9603
    @Aliana9603 Před 26 dny

    Thanks, that helped

  • @Yagnik_Sojitra
    @Yagnik_Sojitra Před 3 měsíci +1

    SQL is Structured Query Language MYSQL is MY Structured Query Language .

  • @arulkavi4931
    @arulkavi4931 Před 3 měsíci

    RDBMS itself has its own built-in Sql commands and are different in different softwares

  • @mohamedhadhoud6701
    @mohamedhadhoud6701 Před 8 měsíci

    SQL id the language used by MySQL and DBMS and SQL server to communicate eith those databases

  • @nandana2353
    @nandana2353 Před 2 měsíci

    Oke, if anyone feeling useless in ur life, about me am watching this vedio the day before my exam to know these 2 r diffrnt, were i already setup whole mysql ✨

  • @bhawnakaur1937
    @bhawnakaur1937 Před 2 lety +7

    I want to learn SQL. Can I go with MySQL? Will that help me to learn SQL

    • @bulaloitech
      @bulaloitech Před rokem +1

      Learn MySQL first. MySQL is the one that lets you store data and make database server while SQL is the one that manipulate that database server. So you cant use SQL if you dont have db server

  • @bestamazondeals2614
    @bestamazondeals2614 Před 3 měsíci +1

    Very Helpful video for bingers'

  • @poojamore9999
    @poojamore9999 Před 2 lety +8

    Mam can u tell me pilzz ...am I right or wrong ...SQL is language which is used in various Database management software

    • @hey-simba
      @hey-simba Před 2 lety +1

      Yes bro, but note that SQL is used only in RDBMS.

    • @REVIEWSGALATTA
      @REVIEWSGALATTA Před rokem

      ​@@hey-simba why?

    • @hey-simba
      @hey-simba Před rokem

      @@REVIEWSGALATTA It is what it is. SQL was developed for RDBMS(SQLite, mysql) and NOSQL was developed for Non-RDBMS(mongodb)

  • @r-tn5zr
    @r-tn5zr Před 2 měsíci

    The difference is SQL is the language (the standard) and MySQL the implementation.

  • @thrillhouse4784
    @thrillhouse4784 Před 7 měsíci +4

    So my sql is mine and sql is used in my sql, so if keep using my sql then eventually ill learn sql but its better to learn slq as a language, and then use my sql to use my sql for databases using sql commands?

  • @nareshkumarsanda9247
    @nareshkumarsanda9247 Před rokem

    Boolean SQL=true;
    Boolean MySQL=false;
    If (MySQL){
    If(SQL){
    Sysout ("grammar for querying data");
    }
    Sysout ("software")
    }

  • @Clash-mr3jb
    @Clash-mr3jb Před rokem +1

    Mam plz make a video on Javascript vs React

    • @SCALER
      @SCALER  Před rokem +1

      Hi, we have duly made a note of your suggestion and it will be passed on to our relevant teams. Thank you! 😊

  • @LewisMoten
    @LewisMoten Před 2 měsíci

    SQL written for MySQL isn’t necessarily compatible with PostgreSQL, Oracle, or Microsoft. They all have their different variants of SQL. Microsoft calls theirs T-SQL.

  • @fatimajunejo
    @fatimajunejo Před 7 měsíci +1

    Thanks ❤

  • @user-qg2ov1jc6w
    @user-qg2ov1jc6w Před 3 měsíci +1

    Stuture query language

  • @CommonStudentActivity
    @CommonStudentActivity Před 7 měsíci +3

    Data type difference.
    My sql used int & oracl used number data types...
    May be this type of difference have been seen.

  • @r-tn5zr
    @r-tn5zr Před 2 měsíci

    On the next episode. What is the difference between apples and apple pie.

  • @boogieman8827
    @boogieman8827 Před 3 měsíci

    Can you release a microsoft SQL complete course for all data jobs

  • @udhaybhaskarbellamkonda1678
    @udhaybhaskarbellamkonda1678 Před 9 měsíci +1

    Normalisation possible in SQL Whereas it is not possible in Mysql

  • @payelkumbhakar6337
    @payelkumbhakar6337 Před 10 měsíci

    To know about rdbms what should I learn? And also for performance tuning. Please reply.

  • @bestchoice7431
    @bestchoice7431 Před měsícem

    mysql is a RDBMS and used to manage different databases. Ha ha. Please tell us the name of the databases.

  • @prasadkirapatla3539
    @prasadkirapatla3539 Před 2 lety +7

    Can we get a job only on sql

  • @SanjeevKumar-vv5lu
    @SanjeevKumar-vv5lu Před 2 lety +4

    It is hard to learn if the learner is from non technical background ??

    • @SCALER
      @SCALER  Před 2 lety +7

      Hey Sanjeev, we do not believe so, you need to only have a curious mind, and the correct guidance. :)

    • @ankitpatel5872
      @ankitpatel5872 Před 2 lety

      rebuild your belief system with a healthy mindset it's nothing like that you are just having nonsense excuses

  • @vijaysankar2354
    @vijaysankar2354 Před 4 měsíci +1

    very intelligent gril, finally she did it 🤣

  • @bharathkumarm3382
    @bharathkumarm3382 Před 2 lety +4

    Are Oracle and MySQL same??

    • @SCALER
      @SCALER  Před 2 lety +7

      Hey Bharath, no, these are different Relational Database Management Systems. :)

    • @bharathkumarm3382
      @bharathkumarm3382 Před 2 lety +2

      @@SCALER ok then MySQL is owned by Oracle??
      Because official site of MySQL is under Oracle name

  • @christineeee96
    @christineeee96 Před rokem

    sql- language
    mysql- software mgt syst

  • @ccccc450
    @ccccc450 Před rokem

    Thanku mam

  • @abhaysagar9865
    @abhaysagar9865 Před 2 lety +4

    What is mongo database and using
    similar to Mysql data base..

  • @saipradeep01
    @saipradeep01 Před 10 dny

    Sql is a language and mysql speaks that language

  • @RakeshSingh-dy9gd
    @RakeshSingh-dy9gd Před 2 lety +1

    I am from Arts background. I want to learn SQL. Which programming language is required to SQL. Should I learn the C language before SQL

    • @sam-001
      @sam-001 Před rokem +1

      Sql language hi hai

    • @_sanjay_3419
      @_sanjay_3419 Před rokem

      No need to learn any other language because SQL is itself a language.
      You can use MySql software, cause it's quite easy as far as I have learnt !

  • @dezaku6612
    @dezaku6612 Před 2 lety +2

    Easier: SQL is the language used to communicate with a database (MySQL, PostgreSQL, etc.)

  • @eswaryadav5099
    @eswaryadav5099 Před 2 lety +2

    Mam I have completed my bcom in the year of 2012 can I learn SQL and SQL use full for me r not

    • @tusharsinha9125
      @tusharsinha9125 Před 2 lety

      Yes u can learn easily, just following CZcams tutorials/playlists on Sql,MySql

  • @Pankaj-Verma-
    @Pankaj-Verma- Před 7 měsíci

    Thanks.

  • @rashmisinha1893
    @rashmisinha1893 Před rokem +2

    Are MySQL and MySQL server same?

  • @hemantpanchal8087
    @hemantpanchal8087 Před 8 měsíci

    Can someone pls guide me, which database is preferable for core banking domain between mssql and postgresql?
    apart from Oracle.

  • @dlizard04
    @dlizard04 Před rokem +2

    Thank you for that information.

  • @nishchaysharma5904
    @nishchaysharma5904 Před rokem +1

    SQL and MySQL are just like Phone and iPhone

  • @arsheensayyed141b6
    @arsheensayyed141b6 Před rokem +1

    Can we understand MySQL if we don't know abt SQL?

  • @astitvasachan2958
    @astitvasachan2958 Před rokem

    Can we extract live data (from some webite) in sql and extract data from it????

  • @latestbeeremovalchanel
    @latestbeeremovalchanel Před 6 měsíci

    DCL,and TCL commands difference

  • @Cosmologist722
    @Cosmologist722 Před rokem +1

    Can MYSQL manage large databases ?

  • @sairsapatawithme
    @sairsapatawithme Před 11 měsíci

    I need this answer very badly .i done my bca in 2015 nd now i m pursuing my mca from ignou.i want to know that can i become a data analyst.may i get a job after learning...😢😢😢

    • @SCALER
      @SCALER  Před 11 měsíci

      Hi Deeksha, we're super excited to see your interest in learning at Scaler! 😄 Please head over to the following link to sign-up for our program and to know more about them: bit.ly/JoinScaler

  • @chichagg
    @chichagg Před 6 měsíci

    u saved my day😂

  • @Rawat-nn2yq
    @Rawat-nn2yq Před 9 měsíci +2

    Difference between water and H2O

  • @abishekkumar1530
    @abishekkumar1530 Před 2 lety

    As i am beginner students what i should be learn first

    • @SCALER
      @SCALER  Před 2 lety

      Hi Abhishek, we're super excited to see your interest in learning at Scaler! Please head over to the following link to register for a call back and our team will reach out to you soon: bit.ly/3R0CWzm

  • @user-wi1ft3yc3s
    @user-wi1ft3yc3s Před 5 měsíci

    Nice

  • @Rajveer__singhhhh
    @Rajveer__singhhhh Před rokem

    Nice❤

  • @user-rg1xd6je6b
    @user-rg1xd6je6b Před 8 měsíci

    Difference between Apple & iphone

  • @shaikhumair4586
    @shaikhumair4586 Před rokem +3

    Why you are confusing us

  • @codeon-rb7ho
    @codeon-rb7ho Před 9 měsíci +1

    SQL isn't mine.

  • @r-tn5zr
    @r-tn5zr Před 2 měsíci

    how can you use MySQL without knowin SQL?

  • @iamabhishek615
    @iamabhishek615 Před 9 měsíci

    SQL has 3 words where as MySQL has 5 words in it

  • @sureshsuresh-xk5bi
    @sureshsuresh-xk5bi Před 8 měsíci

    hi
    i'm relaving in 2020 can i get a job on mysql as a fresher

  • @taimoorahmadkhan881
    @taimoorahmadkhan881 Před měsícem

    MySQL is not installed

  • @comedyshorts8958
    @comedyshorts8958 Před 2 lety +6

    MySql is selfish ! Whereas SQL isn't!

  • @vivekkumarverma6739
    @vivekkumarverma6739 Před 2 lety +3

    Mam how I learn SQL database in Hindi

    • @SCALER
      @SCALER  Před 2 lety +1

      Hey Vivek, we are soon coming up with a video on SQL in Hindi. Do stay subscribed to our channel for notifications.

  • @Anjing-Koththadimai
    @Anjing-Koththadimai Před rokem

    What is the difference

  • @NiceThought143
    @NiceThought143 Před rokem +1

    you taking online classes

  • @thessianheart9816
    @thessianheart9816 Před 4 měsíci

    SQL is a burger. MySQL is McDonald's.

  • @UltimateEscape438
    @UltimateEscape438 Před 8 měsíci

    Hi ma'am, can you assist me creating offline server and data base for me to practice query. please please,

  • @WristGameShardee
    @WristGameShardee Před 5 měsíci

    I thought she meant MSSQL 😕

  • @SunilRajKumarM
    @SunilRajKumarM Před 2 lety +1

    Mysql has prefix in it whereas SQL has no my in it

  • @gourigouri6948
    @gourigouri6948 Před 2 lety

    Sql and postgresql are same??

    • @SCALER
      @SCALER  Před 2 lety

      Nope. SQL is the language used to query data from a database from PostgreSQL.

    • @gkrviews4019
      @gkrviews4019 Před 2 lety +1

      @@SCALER that means MySQL and postgreSQL are similar.

  • @CrystalReneeMusic
    @CrystalReneeMusic Před 8 měsíci

    Wait, what? 🤔🤨

  • @timianalytics7150
    @timianalytics7150 Před rokem

    More like "2 key differences"

  • @EasterTamil
    @EasterTamil Před rokem +1

    React vs angular 🙄

  • @yashsaini6113
    @yashsaini6113 Před 2 lety +1

    Mam,you are looking so pretty

    • @sajjadalam985
      @sajjadalam985 Před rokem +2

      Is that a Joke 😂😂😂🤣😅😅🤣😅

  • @Cat_king007
    @Cat_king007 Před 2 lety

    Are u given teaching class.... ????

  • @soumadip_skyy_banerjee
    @soumadip_skyy_banerjee Před 2 lety +1

    Lol

  • @ranitreasa127
    @ranitreasa127 Před 2 měsíci

    LOL

  • @sanjanaghosh051
    @sanjanaghosh051 Před rokem

    👽

  • @aakashPotter
    @aakashPotter Před 2 lety

    What a useless question! Its like comparing apples and oranges

  • @servtheking5245
    @servtheking5245 Před rokem

    😂😂

  • @shaikhumair4586
    @shaikhumair4586 Před rokem

    Plz don't make this kind of videos

  • @Thakurgmbd
    @Thakurgmbd Před 2 lety

    hllo