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', '[e-mail]', '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...