mariadb root@localhost:dyw> select * from tbl; +----+---------+--------+-----------------+ | id | title | author | submission_date | +----+---------+--------+-----------------+ | 1 | PHP | david | 2020-01-28 | | 2 | MariaDB | dywang | 2020-01-01 | | 3 | Linux | linux | 2020-01-11 | +----+---------+--------+-----------------+ 3 rows in set Time: 0.031s
mariadb root@localhost:dyw> update tbl set title='python' where id=1; Query OK, 1 row affected Time: 0.006s
mariadb root@localhost:dyw> select * from tbl; +----+---------+--------+-----------------+ | id | title | author | submission_date | +----+---------+--------+-----------------+ | 1 | python | david | 2020-01-28 | | 2 | MariaDB | dywang | 2020-01-01 | | 3 | Linux | linux | 2020-01-11 | +----+---------+--------+-----------------+ 3 rows in set Time: 0.029s
mariadb root@localhost:dyw> update tbl set title='c++',author='peter' where id=1 ; Query OK, 1 row affected Time: 0.008s
mariadb root@localhost:dyw> select * from tbl; +----+---------+--------+-----------------+ | id | title | author | submission_date | +----+---------+--------+-----------------+ | 1 | c++ | peter | 2020-01-28 | | 2 | MariaDB | dywang | 2020-01-01 | | 3 | Linux | linux | 2020-01-11 | +----+---------+--------+-----------------+ 3 rows in set Time: 0.030s