sql数据库表添加数据
Once you have a table, you can insert data into it.
一旦有了表,就可以向其中插入数据。
Take this table:
取这张表:
CREATE TABLE people (
age INT,
name CHAR(20)
);
You can now start adding data into it with the INSERT INTO
command:
现在,您可以使用INSERT INTO
命令开始向其中添加数据:
INSERT INTO people VALUES (37, 'Flavio');
You can insert multiple items separating each one with a comma:
您可以插入多个项目,每个项目之间用逗号隔开:
INSERT INTO people VALUES (37, 'Flavio'), (8, 'Roger');
sql数据库表添加数据