1.添加数据到表中

INSERT INTO 语句用于向表格中插入新的行数据。 sql语句不区分大小写的语法格式：

INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....)

#插入一条数据到表中mysql> insert into person values (1, '苏桐', 0, 99, "可爱得很", 8.99);Query OK, 1 row affected (0.01 sec)#发现在用这种方式插入数据的时候 数据一定和表的字段进行匹配！！！

# select * from person;#select 查询#* 所有字段# from 从哪查#person 从这个表中查所有的数据​

#通过指定的列 插入指定的数据mysql> insert into person(id, name) values(2, "还在睡觉");Query OK, 1 row affected (0.01 sec)

mysql> select * from person;+------+--------------+--------+------+--------------+--------+| id | name | gender | age | info | salary |+------+--------------+--------+------+--------------+--------+| 1 | 苏桐 | 0 | 99 | 可爱得很 | 8.99 || 2 | 还在睡觉 | NULL | NULL | NULL | NULL |+------+--------------+--------+------+--------------+--------+2 rows in set (0.00 sec)

#一次性插入多条数据mysql> insert into person(id, name, age, gender , info, salary)-> values(3, "狗蛋", 12, 1, "是真的狗", 98.98),(4, "二贝", 78, 0,"神经吧", 23.4);Query OK, 2 rows affected (0.00 sec)Records: 2 Duplicates: 0 Warnings: 0

mysql> update person set name = "heidan" where name = "狗蛋";Query OK, 1 row affected (0.01 sec)Rows matched: 1 Changed: 1 Warnings: 0​mysql> update person set name="小苏苏", age=29, gender=1 where id = 1;Query OK, 1 row affected (0.01 sec)Rows matched: 1 Changed: 1 Warnings: 0