mysql操作 mysql多表操作

mysql操作

update sdb_mall_goods set basicprice = basicprice * 0.1, price = price * 0.1, where catid =1359

mysql多表操作

我来修改下吧：

update order, team set order.product = team.product where order.team_id = team.id

数据库、表、用户的操作

CREATE DATABASE DBNAME ...
CREATE TABLE TABLENAME...
EXEC sp_addlogin USERNAME,pwd,DBNAME
GRANT SELECT ON TABLENAME TO USERNAME
...