amnotsuperior的专栏

mysql> show databases; mysql> create database mysqldata; mysql> use mysqldata; mysql>show tables; 4: 创建数据库 bin>mysql -uroot -p; mysql> create database mysqldata; mysql> show databases; mysql>use

replace(object,search,replace) 把object中出现search的全部替换为replace select replace('www.163.com','w','Ww')--->WwWwWw.163.com 例：把表table中的name字段中的aa替换为bb update table set name=replace(name,'aa','bb') 先备份一下该