mysql 数据的增删改

1.更新数据update

update 表名 set

字段1 = 值

字段2 = 值2

where condition

示例:

update mysql.user set password=password("123)where user="root‘‘ and host ="localhost";

2.删除数据

delete from 表名 

where conition

示例;

delete from mysql.user where password=" ‘‘

mysql 数据的增删改

标签：示例   password   mys   delete   date   sql   nbsp   oca   mysql