产品文档

分布式数据库 TiDB

数据操作

插入数据


INSERT INTO person VALUES("1","tom","20170912");

查询数据


SELECT * FROM person;
+--------+------+------------+
| number | name | birthday   |
+--------+------+------------+
|  1 | tom  | 2017-09-12 |
+--------+------+------------+

修改数据


UPDATE person SET birthday='20171010' WHERE name='tom';
SELECT * FROM person;
+--------+------+------------+
| number | name | birthday   |
+--------+------+------------+
|  1 | tom  | 2017-10-10 |
+--------+------+------------+

删除数据


DELETE FROM person WHERE number=1;
SELECT * FROM person;
Empty set (0.00 sec)
更新时间:2019-06-27 14:18:34