sql - db2 set incrementing values using insert statement -

-

मेरे पास दो टेबल हैं: 

  MYTABLE1 ID | Col1 | col2 | --------------------- .... 64 | 50 | 7000 | MYTABLE2 MY_ID | ------- 64 | 87 |

और मुझे MYTABLE1 को 10,000 पंक्तियों की तरह डालने की आवश्यकता है, जहां आईडी = MY_ID कॉल 1 = 50 चींटी 2 बकाया है जब प्रत्येक पंक्ति पंक्ति डाली जाती है, तो MYTABLE1 ऐसा दिखेगा: 

  आईडी | कॉल 1 | कॉल 2 | --------------------- .... 64 | 50 | 7000 | 87 | 50 | 7001 |

मुझे यहां समान समाधान मिल गया है:

लेकिन मैं अब भी यह नहीं समझ सकता कि MYTABLE2 से सभी आईडी कैसे लोड करें

कृपया मदद करें, धन्यवाद आपके उत्तर के लिए। 

  MYTABLE1 में डालें (id, col1, col2) my_id का चयन करें, 50 col1, col2 + row_number () my_id से (my_id द्वारा क्रम) से (MY_ID, m.col2 का चयन करें MYTABLE2 टी 2 से, (मैटैबल 1 से कोले 2 के रूप में अधिकतम (col2) चुनें) m) टी 2 - यदि आप सम्मिलित नहीं करना चाहते हैं आईडी जो पहले से ही MYTABLE1 में मौजूद हैं, जहां मौजूद नहीं है (मैथैबल 1 टी 1 से 1 का चयन करें, जहां टी 1.आईडी = टी 2। एमआई_आईडी);

Comments

Post a Comment

Popular posts from this blog

java - Can't add JTree to JPanel of a JInternalFrame -

-
Image
There are two panels in my JInternalframe. I want to add TopPanel to Jtree to nominate another. But I can not add Jaitari to the top of the panel. Please help me in this piece of code: DefaultMutableTreeNode root = new DefaultMutableTreeNode ("deck"); DefaultMutableTreeNode Item Clubs = New DefaultMutableTreeNode ("Club"); AddAllCard (itemClubs); Root.add (itemClubs); DefaultMutableTreeNode item = New DefaultMutableTreeNode ("Diamonds"); AddAllCard (itemDiamonds); Root.add (itemDiamonds); DefaultMutableTreeNode Itemspads = New DefaultMutableTreeNode ("Spades"); AddAllCard (itemSpades); Root.add (itemSpades); DefaultMutableTreeNode item increases = new DefaultMutableTreeNode ("heart"); AddAllCard (itemHearts); Root.add (itemHearts); Default Trimodel Tree Model = New DefaultTreeModel (Route); Tree = new jetty (tree modal); ScrollPane = new JScrollPane (tree); // scrollPane.setViewportView (tree); . ScrollPane.getViewport () add (tr...
Read more

c++ - Qt-how to convert a QByteArray to struct -

-
I need to convert a QByteArray into a structure. I have such a structure: struct mavlink_attitude_t {/// & lt; Summary & gt; Timestamp (millisecond from system boot) & lt; / Summary & gt; Quint 32 Time_boot_ms; /// & lt; Summary & gt; Roll angle (rad, -pi .. + pi) & lt; / Summary & gt; Float roll; /// & lt; Summary & gt; Pitch angle (red, -p + + pi) & lt; / Summary & gt; Boat pitch; /// & lt; Summary & gt; Angle of O (Red, -P. + Pi) & lt; / Summary & gt; Float yao; /// & lt; Summary & gt; Angular Speed ​​Roll (Rod / S) & lt; / Summary & gt; Float rollspeed; /// & lt; Summary & gt; Pitch angular momentum (rad / s) & lt; / Summary & gt; Float pitchspid; /// & lt; Summary & gt; Yoga's angular momentum (RD / S) & lt; / Summary & gt; Float Yspeed; }; And I come from a Quetbeat Serial Port. I was already using the union but I think it can not be used for QByteArray, i...
Read more

c++ - What exceptions does boost mapped_file_source throw? -

-
Boost map_file_source, for example, throws an exception file not found. Is the exception square really throwing it? It does not seem to say in the documentation, unless I miss something. Edit: Test case: #include & lt; Boost / iostreams / device / mapped_file.hpp & gt; Int main (int argc, char ** argv) {boost :: iostreams :: mapped_file_source file; File.open (argv [1]); Return 0; If mapping fails, code mapped_handle_ = :: CreateFileMappingA (handle_, NULL, defense, 0, 0, zero); If (mapped_handle_ == NULL) cleanup_and_throw ("failed to create mapping"); Eventually will boost: iostreams :: detail :: throw_system_failure (msg); i.e. Sub-class of std :: exception In this case, it is std :: ios :: failure : BOOST_IOSTREAMS_FAILURE should be std :: ios_base :: Failure to expand, and otherwise the std :: exception for the appropriate derived class. Reference:
Read more