How do you insert data in MySQL?

5 months ago

1 minute

To insert data into MySQL, you can use the INSERT INTO statement. Here is a simple example:

Suppose there is a table called “users” with columns id, name, and email, you can use the following command to insert a row of data:

INSERT INTO users (name, email) VALUES ('John Doe', 'john.doe@example.com');

This will insert a new row in a table called “users” with the name ‘John Doe’ and email ‘john.doe@example.com’. Other fields in the table can be included in the INSERT INTO statement as needed.