如何向mysql添加新行？

Question

I have a users table like this:

INSERT INTO signup (UID, email, username, fname, lname, bdate, gender)
VALUES
(1, '[e-mail]', 'johnd', 'john', 'doe', '0000-00-00', 'Male'),
(2, '[e-mail]', 'marryb', 'marry', 'brown', '0000-00-00', 'Female');

I prepared a new user list on notepad like below:

(3, '[e-mail]', 'alij', 'ali', 'johnson', '0000-00-00', 'Male'),
(4, '[e-mail]', 'janew', 'jane', 'white', '0000-00-00', 'Female');

How can I add the new users to my database using a SQL command?

Answer 1

INSERT INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (1, '[e-mail]', 'johnd', 'john', 'doe', '0000-00-00', 'Male');
INSERT INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (3, '[e-mail]', 'marryb', 'marry', 'brown', '0000-00-00', 'Female');
INSERT INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (4, '[e-mail]', 'alij', 'ali', 'johnson', '0000-00-00', 'Male');
INSERT INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (5, '[e-mail]', 'janew', 'jane', 'white', '0000-00-00', 'Female');

Or just simply INSERT ALL INTO

INSERT ALL
  INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (1, '[e-mail]', 'johnd', 'john', 'doe', '0000-00-00', 'Male')
  INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (3, '[e-mail]', 'marryb', 'marry', 'brown', '0000-00-00', 'Female')
  INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (4, '[e-mail]', 'alij', 'ali', 'johnson', '0000-00-00', 'Male')
  INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (5, '[e-mail]', 'janew', 'jane', 'white', '0000-00-00', 'Female')
SELECT * FROM dual;

I hope this helped.