SQl create table and insert value

We learn how to create a table and insert values, update values in this chapter. However, it requires manually insert each value into the table. If we have over thousand rows, and more than 20 columns, which means that we have to manually insert values one by one? it does not sound smart. Any way to import dataset ( could be CSV, or excel ) into the database so we can use SQL to work on the data?

Screen Link: https://app.dataquest.io/m/192/table-relations-and-normalization/8/challenge-adding-sales-tax-capabilities

I hope this article may help you. :smile:

Thank you for sharing it! super helpful!

1 Like