Inserting Data Into Tables – MySQL Series Part 4
Once we are done with creating the table we can start inserting some data into it.
Follow the complete MySQL Series here.
Let’s say we wanted to insert a record without entering the city name. We could use the following command for that purpose.
It should give you the following output when querying the table. Lastly, if you wish to remove all records from the table just run the truncate employee command. This will delete all records from your employee table.