Âòîðíèê, 04 Àâãóñòà 2015 ã. 10:51
+ â öèòàòíèê
Ïðèâåòñòâóþ ÂÑÅÕ!
ïîäñêàæèòå êàê ïðàâèëüíî ïåðåíåñòè äàííûå èç ïîëåé
Òèï ýëåìåíòà óïðàâëåíèÿ :
"Ïîëå ñî ñïèñêîì"Òèï èñòî÷íèêà ñòðîê:
"Òàáëèöà èëè çàïðîñ"Ðàçðåøèòü íåñêîëüêî çíà÷åíèé:
"Äà"Ïî çàäà÷å åñòü íåñêîëüêî òàáëèö ñâÿçàííûõ äàííûì îáðàçîì,
ÿ äîáàâëÿþ ê òàáëèöàì ñëóæåáíîå ïîëå(int), çàïîëíÿþ åãî.
è õîòåë áû â ìåñòî "a;b;c" ïîëó÷èòü "1;2;3"
table t0
id(int),zzz(memo),my_key(int)
1,"a",2
2,"",1
3,"a;b;c",3
zzz(Èñòî÷íèê ñòðîê)
èñõîäíûé çàïðîñ) SELECT t1.text FROM t1 ORDER BY text;
íîâûé çàïðîñ) SELECT t1.my_key FROM t1 ORDER BY text;
table t1
id(int),text(memo),my_key(int)
11,"a",1
12,"b",2
44,"c",3
ñîòâåòñòâåííî õîòåëîñü ïîëó÷èòü
table t0
id(int),zzz(memo),my_key(int)
1,"1",2
2,"",1
3,"1;2;3",3
Çàðàíåå ñïàñèáî!
http://www.sql.ru/forum/1169110/perenos-dannyh
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-