Tutorials - MySQL - Queries - Insert

Now that we have made our table, we can begin adding data to it, because there is no use having a database table without any data inside it. Luckily, the INSERT query in MySQL is much simpler than the query to create tables:

INSERT INTO `customers`(`taxid`, `name`, `address`) VALUES (`123456`, `Steve Smith`, `123 Fake Street`)

This query should be fairly self explainitory - you start with "INSERT INTO" and then specify the table name (`customers`) and then the column names in brackets (`taxid`, `name`, `address`), then specify "VALUES" and the values you want to insert into those columns (in the same order) within brackets. Please not that ` is not a normal apostrophe, and can be found in the top left or bottom left of most keyboards.

Page Responses

Currently there have been no responses to this page...

Post Response

If you have anything to contribute to this tutorial, found a bug, or know a better way of achieving the same goal, please leave your response below.