MySql-----DML语句添加数据

DML语句添加数据：

/*
  给表中的指定列添加一行/一条数据:
    INSERT INTO 表名(列名1,列名2...) VALUES(值1,值2...);
 */
INSERT INTO person(id, name, idcard,height)values (1,'张六','110110199901111222','1.85');
INSERT INTO person(id, name, idcard,birthday,height)values (2,'赵七','110110199601111222','1996-01-11','1.53');

 /*
  给表中的全部列添加一行/一条数据:
  INSERT INTO 表名 VALUES(值1,值2...);

 */
 INSERT INTO person values (3,'王五','110222199702021111','1997-02-02','1.99',NULL);


 /*
  批量添加数据:
  INSERT INTO 表名 VALUES(值1,值2...),(值1,值2...),(值1,值2...);
 */
 INSERT INTO person VALUES (4,'李四','110222199502191111','1995-02-19','1.80',NULL),(5,'张三','110222199705021111','1997-05-02','1.85',NULL);