ÇóÌõSQLÓï¾ä

±íÈçÏ£º

ID Name Cid Quantity
B1 M R1 1
B1 M R3 0.2
B1 M R5 0.8
R1 M2 R4 1
R1 M2 R9 0.2
R1 M2 R12 1

ÒªÒÔÏÂÃæ½á¹û
ID Name Cid Quantity
B1 M R3 0.2
B1 M R5 0.8
B1 M R4 1
B1 M R9 0.2
B1 M R12 1
ÇóSQLÓï¾ä
 

---

SQL code:


select 'b1','M',cid,quantity
from tb

---

ÒýÓÃ

±íÈçÏ£º

ID Name Cid Quantity
B1 M R1 1
B1 M R3 0.2
B1 M R5 0.8
R1 M2 R4 1
R1 M2 R9 0.2
R1 M2 R12 1

ÒªÒÔÏÂÃæ½á¹û
ID Name Cid Quantity
B1 M R3 0.2
B1 M R5 0.8
B1 M R4 1
B1 M R9 0.2
B1 M R12 1
¡­¡­

ʲô¹æÔò

---

ID Name Cid Quantity
B1 M R1 1
B1 M R3 0.2
B1 M R5 0.8
R1 M2 R4 1
R1 M2 R9 0.2
R1 M2 R12 1
.
.
.

 ÒªÒÔÏÂÃæ½á¹û
ID Name Cid Quantity
B1 M R3 0.2
B1 M R5 0.8
B1 M R4 1
B1 M R9 0.2
B1 M R12 1
.
.
.
ÇóSQLÓï¾ä

---

¿´²»¶®

---

ÎÊÄãʲô¹Øϵ°¡

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighte