如何向mysql添加新行 - How to add new rows to mysql?

How to add new rows to mysql?

本文关键字：添加新行 mysql | 更新日期: 2023-09-27

我有一个这样的用户表:

INSERT INTO signup (UID, email, username, fname, lname, bdate, gender)
VALUES
(1, 'sample1@sample1.com', 'johnd', 'john', 'doe', '0000-00-00', 'Male'),
(2, 'sample1@sample2.com', 'marryb', 'marry', 'brown', '0000-00-00', 'Female');

我在记事本上准备了一个新的用户列表，如下所示:

(3"sample3@sample3.com"alij","阿里","约翰逊","0000-00-00","男"),
(4、"sample4@sample4.com"、‘janew’,‘简’,‘白’,‘0000-00-00’,‘女性’),

如何使用SQL命令向数据库添加新用户?

INSERT INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (1, 'sample1@sample1.com', 'johnd', 'john', 'doe', '0000-00-00', 'Male');
INSERT INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (3, 'sample1@sample2.com', 'marryb', 'marry', 'brown', '0000-00-00', 'Female');
INSERT INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (4, 'sample3@sample3.com', 'alij', 'ali', 'johnson', '0000-00-00', 'Male');
INSERT INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (5, 'sample4@sample4.com', 'janew', 'jane', 'white', '0000-00-00', 'Female');

或者仅仅是INSERT ALL INTO

INSERT ALL
  INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (1, 'sample1@sample1.com', 'johnd', 'john', 'doe', '0000-00-00', 'Male')
  INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (3, 'sample1@sample2.com', 'marryb', 'marry', 'brown', '0000-00-00', 'Female')
  INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (4, 'sample3@sample3.com', 'alij', 'ali', 'johnson', '0000-00-00', 'Male')
  INTO signup (UID, email, username, fname, lname, bdate, gender,) VALUES (5, 'sample4@sample4.com', 'janew', 'jane', 'white', '0000-00-00', 'Female')
SELECT * FROM dual;

希望这对你有帮助。

你已经回答了自己的问题。该SQL是一条INSERT语句，而不是表。它用于向表中插入数据。因此，如果表'signup'还不存在，则需要创建它。然后在括号中插入额外的数据集。 https://dev.mysql.com/doc/refman/5.1/en/insert.html