• Rubanski@lemm.ee
    link
    fedilink
    arrow-up
    0
    ·
    2 months ago

    Ok genuine question, what is the difference between a SQL database and a simple Excel spreadsheet?

    • lefixxx@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      The excel file contains the data. It’s equivalent to the database.

      The excel program is how you interact with the data. SQL is how you interact with databases.

      Doesn’t matter how the data is structured inside the database. You can ask in the SQL language and you will receive an SQL answer.

      • Whirlybird@aussie.zone
        link
        fedilink
        arrow-up
        0
        arrow-down
        2
        ·
        2 months ago

        SQL is how you interact with databases.

        How you interact with some or even most databases, but not all.