mysql - DB load CSV into multiple tables -

-

UPDATE : डेटा के प्रारूप को स्पष्ट करने के लिए एक उदाहरण जोड़ा गया।

इस तरह से स्वरूपित प्रत्येक पंक्ति के साथ सीएसवी को ध्यान में रखते हुए: 

  tbl1.col1, tbl1.col2, tbl1.col3, tbl1.col4, tbl1.col5, [tbl2.col1: tbl2.col2] +

जहां [tbl2.col1: tbl2.col2] + का मतलब है कि इनमें से कोई भी जोड़ दोहराया जा सकता है

ex: 

  tbl1.col1, tbl1.col2, tbl1.col3, tbl1.col4, tbl1.col5, tbl2.col1: tbl2.col2, tbl2.col1: tbl2.col2, tbl2.col1: tbl2.col2, tbl2.col1 : Tbl2.col2, tbl2.col1: tbl2.col2, tbl2.col1: tbl2.col2, tbl2.col1: tbl2.col2, tbl2.col1: tbl2.col2

तालिकाएँ प्रत्येक पंक्ति से एक कुंजी के रूप में उपयोग करने के लिए संबंधित है जो कि ऊपर उल्लिखित किसी भी कॉलम के अतिरिक्त बनाया जाना है।

  1. mysql लोड डेटा इन्फाइल का उपयोग करने का कोई तरीका है डेटा को दो अलग-अलग तालिकाओं में लोड करने के लिए?
  2. यदि नहीं, तो यूनिक्स कमांड लाइन उपकरण इस के लिए सबसे उपयुक्त क्यों होंगे?

नहीं, सीधे नहीं। लोड डेटा केवल एक तालिका या विभाजन तालिका में सम्मिलित कर सकता है।

आप क्या कर सकते हैं डेटा को एक स्टेजिंग तालिका में लोड करें, फिर डालें में व्यक्तिगत कॉलम का चयन करें 2 अंतिम टेबल आपको substring_index की आवश्यकता हो सकती है, अगर आप tbl2 के मानों के लिए अलग-अलग सीमांकक का उपयोग कर रहे हैं लाइन नंबर स्टेजिंग तालिका में एक ऑटो वृद्धिशील कॉलम द्वारा नियंत्रित किया जाता है (सबसे आसान तरीका है ऑटो स्तम्भ को अंतिम रूप से स्टेजिंग तालिका की परिभाषा में करना है)।

प्रारूप बिल्कुल स्पष्ट नहीं है, और सबसे अच्छा किया जाता है W / perl / php / python, लेकिन अगर आप वास्तव में शेल टूल्स का उपयोग करना चाहते हैं: 

  cut -d, -f 1-5 फ़ाइल | Awk -F, '{print nr "," $ 0}' & gt; टेबल 1 कट-डी, -f 6- फाइल | Sed 's, \:, \, g' | \ Awk -F, '{i = 1; जबकि (i & lt; = nf) {प्रिंट एनआर "," $ (i) "," $ (i + 1); I + = 2;}} '& gt; तालिका 2

यह इन सामग्रियों के साथ तालिका 1 और तालिका 2 फाइल बनाता है: 

  1, tbl1.col1, tbl1.col2, tbl1.col3, tbl1.col4 , Tbl1.col5 2, tbl1.col1, tbl1.col2, tbl1.col3, tbl1.col4, tbl1.col5 3, tbl1.col1, tbl1.col2, tbl1.col3, tbl1.col4, tbl1.col5

और

<पूर्व> 1, tbl2.col1, tbl2.col2 1, tbl2.col1, tbl2.col2 2, tbl2.col1, tbl2.col2 2, tbl2.col1 , Tbl2.col2 3, tbl2.col1, tbl2.col2 3, tbl2.col1, tbl2.col2

Comments

Post a Comment

Popular posts from this blog

asp.net - Change the driver in the connection string to a data source in VB.Net -

-
I have a code that has a driver in a connection string. as a slow string = "driver = {SQL Server}; server = xxx \ SQLEXPRESS; database = dbRegister; reliable connection = yes" I need to change it: data source = 1.2.3.4; User ID = xx; Password = xxxxx; Initial list = xxxxx; Connect timeout = 30 " When I change text, it returns this error: [microsoft] [ ODBC] Driver Manager] The name of the data source was not found and no default driver specified How do I declare a data source? myServerAddress; Initial Catalog = myDataBase; User id = myUsername; Password = myPassword; Use the server name \ example to connect to the specific SQL Server instance as the data source. Are you using SQL Server 2005 Express? Server name syntax does not remember Servername \ SQLEXPRESS Visit P>
Read more

Getting started consuming web services in a Ruby on Rails 3 application -

-
Then I'm starting to learn the rail. Now that the train has left 3, then I have to stay in the tracks to learn 3 Ways to Talk One of the things I want to learn how to do the web service with the rest of the third party / the use of work / method of creating a "mashup" application. I have done minimal work in this way with PHP and pre-built libraries. Can someone lead me to some resources, best practices, or do I have a quick 101 text type of API to start working with them? Should I use gems? Update: I'm trying to use the Google Books API (non-standardized) specifically. Since there is no client library for this API, I am thinking that other Ruby / Rail developers are working with APIs that do not come with Ruby Library. This is the reason why I am looking for a more general solution to work with the "fill the fill" API. Update: After some research, I'm going to the Net :: HTTP Library. All the tutorials that talked about it were quite old. ...
Read more

objective c - iPhone and it's wireless area -

-
Is this a way to find other iPhones in the category of wireless areas? So I give an example. I'm staying at the airport somewhere I have an iPhone too. I and the other iPhone owners are playing the same game. Is there any way to warn me and the other player that we are close to each other? Does this work even if we are not on the same wireless network, or there is no wireless? And if there is any way to do this, can you give me some starting point? Like a link where I can learn something like this or maybe this is probably the name of this process, because I do not know how to search about this topic in Google. Thanks in advance! Can be completed with peer-to-peer discovery and connectivity you are describing Game Kit Framework Originally I thought it works only through Bluetooth, but after watching it immediately, it seems that WiFi is also supported. Hope it helps!
Read more