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的全部替换为replaceselect replace('www.163.com','w','Ww')--->WwWwWw.163.com例：把表table中的name字段中的aa替换为bbupdate table set name=replace(name,'aa','bb')先备份一下该