MySQL向表中插入数据

语法：

INSERT INTO table_name ( field1, field2,...fieldN )                       VALUES                       ( value1, value2,...valueN );

例子：

mysql> insert into user(name)    -> value    -> ("user1");Query OK, 1 row affected (0.00 sec)

mysql> select * from user;+----+-------+| id | name  |+----+-------+|  1 | user1 ||  2 | user2 ||  3 | user3 ||  4 | user4 ||  5 | user5 |+----+-------+5 rows in set (0.00 sec)