按字段编号拆分表数据。 [英] Split a table data accourding to field number.
问题描述
尊敬的先生,
我在sql server数据库中有一个表数据,如下所示,其中字段如teacher和class1,class2,.......
老师cls1 cls2 cls3 cls4 cls5 cls6 cls7 cls8 cls9 cls10
Ram r1 r2 r3 r4 r5 r6 r7 r8 r9 r10
Sam s1 s2 s3 s4 s5 s6 s7 s8 s9 s10
Hari h1 h2 h3 h4 h5 h6 h7 h8 h9 h10
Gagan g1 g2 g3 g4 g5 g6 g7 g8 g9 g10
Prakas p1 p2 p3 p4 p5 p6 p7 p8 p9 p10
我想像老师那样把桌子分成下面的五个类似c#
老师cls1 cls2 cls3 cls4 cls5
Ram r1 r2 r3 r4 r5
Sam s1 s2 s3 s4 s5
Hari h1 h2 h3 h4 h5
Gagan g1 g2 g3 g4 g5
Prakas p1 p2 p3 p4 p5
老师cls6 cls7 cls8 cls9 cls10
Ram r6 r7 r8 r9 r10
Sam s6 s7 s8 s9 s10
Hari h6 h7 h8 h9 h10
Gagan g6 g7 g8 g9 g10
Prakas p6 p7 p8 p9 p10
请帮助我。
感谢adv。
respected sir,
i have a table data in sql server database like below where fields like teacher and class1,class2,.......
Teacher cls1 cls2 cls3 cls4 cls5 cls6 cls7 cls8 cls9 cls10
Ram r1 r2 r3 r4 r5 r6 r7 r8 r9 r10
Sam s1 s2 s3 s4 s5 s6 s7 s8 s9 s10
Hari h1 h2 h3 h4 h5 h6 h7 h8 h9 h10
Gagan g1 g2 g3 g4 g5 g6 g7 g8 g9 g10
Prakas p1 p2 p3 p4 p5 p6 p7 p8 p9 p10
I want to split the table like teacher with five classeslike below in c#
Teacher cls1 cls2 cls3 cls4 cls5
Ram r1 r2 r3 r4 r5
Sam s1 s2 s3 s4 s5
Hari h1 h2 h3 h4 h5
Gagan g1 g2 g3 g4 g5
Prakas p1 p2 p3 p4 p5
Teacher cls6 cls7 cls8 cls9 cls10
Ram r6 r7 r8 r9 r10
Sam s6 s7 s8 s9 s10
Hari h6 h7 h8 h9 h10
Gagan g6 g7 g8 g9 g10
Prakas p6 p7 p8 p9 p10
kindly help me.
thanks in adv.
推荐答案
这两种方法都是胡说八道 - 对任何事情都没有好处。
这是典型的1:N(一对多)情况:
Both approaches are nonsense - neither is good for anything.
This is a typical 1:N (one to many) situation:
Teacher(id, name)<br />
Class(id, teacher_id, name)
不过,让我们假设你坚持这种可怕的方法。设 T
为原始表格, T1
, T2
两个结果。
简单地发出这些:
Still, let's suppose you stick to this horrible approach. Let T
be the original table and T1
, T2
the two resultant ones.
Simply issue these:
INSERT INTO T1(teacher, cls1, cls2, cls3, cls4, cls5) SELECT teacher, cls1, cls2, cls3, cls4, cls5 FROM T;
INSERT INTO T2(teacher, cls6, cls7, cls8, cls9, cls10) SELECT teacher, cls6, cls7, cls8, cls9, cls10 FROM T;
当然,您需要创建 T1
和 T2
表。
这篇关于按字段编号拆分表数据。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!