How to Insert data in MySQL

1 Answer(s)
-- Assuming the users table has only three columns: first_name, last_name, and email, and in that order
INSERT INTO users VALUES ('John', 'Doe', 'john@doe.com');


INSERT INTO users (first_name, last_name, email, birth_date, city, state)
VALUES ('John', 'Doe', 'john@doe.com','2000-01-01','Los Angeles','CA');

Inserting Multiple Rows

You can insert multiple rows in one INSERT statement by having multiple sets of values enclosed in parentheses:

INSERT INTO users (first_name, last_name)
VALUES
  ('John','Lennon'),
  ('Paul','McCartney'),
  ('George','Harrison'),
  ('Ringo','Starr');
Answered on September 1, 2021.

If inserting a row would violate a unique constraint, there are different ways to handle it, depending on your requirements.

Using INSERT IGNORE will quietly discard the row to be inserted:

INSERT IGNORE INTO products (product_id, product_name, stocks)
VALUES (1, 'VPN Product 1', 50);
on September 1, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.