+ 1
Why use SQL to store data?
I want to know that why we use SQL to store Data. Is there any other language to store Data? or can we use a simple text file to store Data?
4 Answers
+ 8
SQL is not used to store data. SQL is a query language used to query and obtain data from a database.
+ 4
Well i'm gonna tell you anyway.
Database consists of different types of data stored in one or multiple tables. Each table has fields (name of the column) and records (which is a row of the table) .
When you need to find any data or store data on the database you don't have to go through all the tables or all the databases you created. You use what is known as Query language.
Query is just saying like, i need this guys information with this id in that table.
So you don't have to go through all the rows and tables of your database manually.
Query languages differ from database to database.
MySQL is one of those languages.
+ 2
you don't need to store data in a database you can just store data in a text file like a setting file or you can store your data in json/xml files
databases are not much more as a text file
+ 1
You should study what database is. You lack basic understanding of database.