当前位置:Gxlcms > 数据库问题 > mysql 简单的增删改查语句

mysql 简单的增删改查语句

时间:2021-07-01 10:21:17 帮助过:8人阅读

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 简单的增删改查语句

标签:

人气教程排行