MySQL: add a new record

We can add a new record with a statement like this one:

INSERT INTO reagents (name, supplier, amount) VALUES ('Trizma Base', 12, 100);

Note that we list the fields we want to populate and then the values in the same order. See more examples.

Tagged , ,

Leave a Reply

Your email address will not be published. Required fields are marked *