Well, you have installed MySQL 8.0 and connected to it. Now it is time to store some data in it, that's what the database is meant for, after all. In any relational database management system (RDBMS), data is stored in rows, which is the basic building block of the database. Rows contain columns in which we can store several set of values.
For example, if you want to store information about your customers in a database.
Here is the dataset:
customer id=1, first_name=Mike, last_name=Christensen country=USAcustomer id=2, first_name=Andy, last_name=Hollands, country=Australiacustomer id=3, first_name=Ravi, last_name=Vedantam, country=Indiacustomer id=4, first_name= Rajiv, last_name=Perera, country=Sri Lanka
You should save ...
