How a dataset is filled in SQL?
I was wondering how a dataset is filled beforehand manipulating it with SQL. Although SQL has commands to create a database, I believe the optimal way to fill in that database is not manually through coding in SQL, right?
so, which is the common way in which a database is filled with records? and who is in charge of it?
In order to get a clear idea, SQL is meant to organize and retrieve data from a full dataset loaded beforehand?
Thank you
1 answers ( 0 marked as helpful)
Hi Marta!
Thanks for reaching out.
In order to get a clear idea, SQL is meant to organize and retrieve data from a full dataset loaded beforehand?
Yes, as well as set up a database/dataset to work with.
which is the common way in which a database is filled with records?
There are various ways to import data into MySQL. One can import a dump file, or a *.dat file, or import code containing the relevant queries that will fill the database with relevant data.
and who is in charge of it?
Normally the database administrators, but also other operators such as database the creators.
Hope this helps.
Best,
Martin
Best,
Martin
Submit an answer
