Inserting Data
Now, we need to add some values to our tables so that we have data to work with in the project later.
A PDF file containing data for these tables can be downloaded at https://www.learncodingfast.com/sql. The tables can also be found in Appendix B for easy reference.
members
For the members table, we have the following set of data:
Try inserting these data yourself. For instance, for the first row, the code would be
INSERT INTO members (id, password, email, member_since, payment_due) VALUES
('afeil', 'feil1988<3', 'Abdul.Feil@hotmail.com', '2017-04-15 12:10:13', 0);
Although member_since and payment_due both have default values, we’ll overwrite them here so that we have some variety in our data to play with later. In addition, note that we enclosed the member_since value in quotation marks. In general, we need to do that for TIMESTAMP, DATETIME...