mysql 简单的增删改查语句

mysql> insert into test values(‘sunshine_habit‘,‘hello_world_lyq@163.com‘ 2 -> ,1558888888,null);
输出： 3 Query OK, 1 row affected (0.10 sec)

查询记录：

1 mysql> select * from test where name=‘sunshine_habit‘;
2 输出：
3 +----------------+-------------------------+--------------+----+
4 | name           | email                   | phone_number | id |
5 +----------------+-------------------------+--------------+----+
6 | sunshine_habit | hello_world_lyq@163.com |   1558888888 |  1 |
7 +----------------+-------------------------+--------------+----+
8 1 row in set (0.00 sec)

 

mysql 简单的增删改查语句

标签：