????? ??
????? ??? ??? ?? ?????. ??? ??, ?? ?? ?? ??, ?? ?? ??? ??? ?? ???? ? ?? ?? ???? ???.
??(??????? ?) ?? ?? ??? ??? ????.
category | ??? ?? |
---|
?? ?? | update ??? ?? ?? ?? 1=? 1, ?? 2 =? 2. ?? n=? n where ?? |
Example | update Money set Balance=balance-500 where userid = 15; |
?? ?? | ?? ???? ???? ?? ??? 500?? ????. . ?? ??? ID? 15 |
?? ???? ??? ???? ??? ??? ??? ????.強(qiáng)
50000.00 ??? 1234131.0 0 | | mysql> deptno=15; +------+----------+---------+ | ??? ID |??? ??| | +------+---------+--------+ | ? ? 15000.00 | +------+ - ----+-------------+ ?? ? 1?(0.00?) ???? ?? ???? ??? ????mysql> - ??? ID = 15? ?? 500;
?? OK, 1? ?? ??? ??(0.35?)
???? ?: 1 ???: 1 ??: 0 mysql> select * from emp where deptno=15;
+------+----------+----------+
| ??? ID | ??? ??|
+------+----------+----------+
15 | ? ? 14500.00 |
+------+-------+-------------+
1? ??(0.00?)
?? ?? ??mysql> ? ?? ???? ??=balance-500,username='文凱' ??? ??? ID = 15;
?? OK, 1? ?? ??? ??(0.00?)
???? ?: 1 ???: 1 ??: 0
mysql> select * from emp where deptno=15;
+------+----------+----------+
| ??? ID | ??? ??|
+------+----------+----------+
15 | ???? |
+------+-------+-------------+
1? ??(0.00?)
? ???? ??? ???? Category??? ?? | | ?? ??update Table 1, Table 2 set field 1=value 1 , ?? 2 = ? 2, ?? n = ? n ?? | | ?? ? ???? m,user u m.balance=m.balance*u.age ??? m.userid=u.id; | | ?? ? money? ????, ??? ???? ??? u? ?????. m ???? ??? ??? ???? m ???*age? ???? ?????. ?? ??? ??? ????: m.userid = u.id | | mysql> update Money m,user u m.balance=m.balance*u.age ??? m.userid=u.id;
<?php
echo "Hello Mysql";
?>
?? ????? ????? ? ????. ?? ???? ???? ????. ???? ? ??? ?? ?? ??????~
? ??? ??? ???? ???? ????.
|
---|