°ïæд¸ösql ¼±

id  tel  tel1 
1    a
2    a
3    a
4    a
5    a
6


½«id ÊÇ 3-5 µÄ tel ÖеÄÄÚÈÝ ¼ôÇÐÏÂÀ´ ²åÈëµ½ tel1×Ö¶ÎÖеÄsqlÓï¾äÈçºÎд

---

SQL code:
INSERT TB (TE1)SELECT TEL from TB WHERE ID BETWEEN 3 AND 5

---

Ôõô¶ÔÓ¦£¿

---

SQL code:
UPATE TB SET TE1=TEL from TB WHERE ID BETWEEN 3 AND 5

---

SQL code:
update ±í set tel1=tel where id id between 3 and 5


??

---

update tel1 = tel ,tel=''  from  table  where id >2  and id <6

---

update tb1
set tel1=tel
where id in(3,4,5)

---

update set tel1=tel,tel='' where id>=3 and id <=5

---

SQL code:
update TB SET TE1=TEL from TB WHERE ID BETWEEN 3 AND 5

---

ÒýÓÃ

SQL codeUPATE  TBSET TE1=TELfrom TBWHERE IDBETWEEN3AND5

ÐèÒª¼ôÏÂÀ´Å¶£¬ºÇºÇ

---

SQL code

---