mysql - SQL Query - Compare all rows from temp table -


मेरे पास एक टेबल है कमरे और एक अस्थायी तालिका Room_Nums

कमरे तालिका के लिए कॉलम: 

  कमरे (ID, room_name, max_Adults, max_Children); - कमरा मूल्यों में INSERT (1, "कक्ष ए", 2,1), (2, "कक्ष बी", 2,5), (3, "कक्ष सी", 3,1);   
 अस्थायी सारणी:  <पूर्व>  अस्थायी तालिका यदि मौजूदा कक्ष_नों; अस्थायी टेबल रूम_न्यूम्स बनाएं (आईडी इंट (1), वयस्क इंट (2), बच्चे इंट (2)); - Room_Nums VALUES (INR1,20), (2,2,5) में INSERT भरें;   
 
 मैं  केवल  को  कमरे  का चयन करना चाहता हूं जिसमें  max_adults  +  max_children  Room_Nums   से आईडी के साथ  Room_Nums  में सभी पंक्तियों से  छोटा या बराबर ( & lt; = ) P>  संपादित करें  
 यह MySQL है।  
 यदि  Room_Nums  में 2 पंक्तियाँ हैं तो इसका मतलब है कि मैं 2 कमरों से पूछता हूं जो मैच  वयस्क  +  बच्चा  ex।  
  का चयन करें r.room_name, rn.Adults, rn.children, rn.ID से कमरे में आर शामिल करें Room_Nums rn ON ( Rn.Adults & lt; = r.max_Adults और rn.children & lt; = r.max_Children)   
  2 संपादित करें  
 इसके लिए पूछना:  
     
  •  1 कमरा: 2 वयस्क और amp; 0 बच्चे  
  •  1 कमरा: 2 वयस्क और amp; 5 बच्चे   
     परिणाम होना चाहिए:  
      ---------------------- ------------------------- | कमरा नाम | वयस्क | बच्चे | Room_Nums.ID | | ----------------------------------------------- | कक्ष ए | 2 | 0 | 1 | ----------------------------------------------- | कक्ष बी | 2 | 5 | 1 | ----------------------------------------------- | कक्ष बी | 2 | 5 | 2 | -----------------------------------------------   
     खाली परिणाम दिखाएं यदि उसे  Room_Nums  से कोई पंक्ति नहीं मिलती।   
     
     
     यद्यपि, यह बिल्कुल स्पष्ट नहीं है, "सभी पंक्तियों" का क्या मतलब है, हो सकता है यह काम करेगा  
      रूम_नाम चुनें, max_adults + max_children, Room_nums.ID कमरे से रूम_एनम से कमरे में शामिल हो जाएं। कमरे = आईडी__ कक्ष_आइटम। जहां max_adults + max_children & lt; = (Room_nums से न्यूनतम (वयस्क + बच्चों का चयन करें);

Comments

Post a Comment

Popular posts from this blog

python - how we can use ajax() in views.py in django? -

I have a little code here. Could you please tell me what this code really does? please. Here in the AJAX call: $ .ajax ({url: "{% url} upload_document '%}", type: "POST", data : {Csrfmiddletoken: document.getElementsByName ('csrfmiddletoken') [0] Price, Title: document.getElementById ('title'). Value, // document: document: document.getElementById ('document'),}, datatype: "Jason", success: function (feedback) {if (feedback == "true") {// success} other {// attachment errors}}}); How AJAX works in the Django and how we can see the AJAX request. Here is the idea of ​​my thoughts def upload_document (requested): Print request. POTT print request FILES if request.is_ajax (): If request.method == 'POST': form = UploadForm (request.POST, request.FILES, user = request.user) if form.is_valid (): Form.save () return HTTPPCS (SimpleJason Dumps ('True'), Mime Type = 'App / Jason') Other:...
Read more

matlab - Using loops to get multiple values into a cell -

I have 31 topics (S1, S2, S3, S4, etc.) 3 images in each topic, opposite 1 IMG, Contrast 2 IMG and Contrast 3 Are IMG I p In a NX1 cell named P, I would like to use a loop to get all the paths of contrasts from all the subjects: data / S1 / contrast1.img / S1 / contrast2.img data / S1 / contrast3.img data / s2 / contrast1.img data / S2 / contrast2.img Data / S2 / contrast3.img ... Data / S31 / contast3.img This is what I've tried: A = {'S1', 'S2', 'S3', ..., 'S31'}; % All topics C = {'contrast1.img', 'contrast2.img', 'contrast3.img'}; For each = P = cell (31 * 3,1) for each topic, the required contrast images: Length = A for Jammu = 1: Length (C) P {j} = spm_select ('FPList', Fullfile (data_path, q {i}) sprint ('% s', cell2mat (c))); % Of each topic is to select three contrast images, it works in my script, it is probably not 100% correct, because I had to simplify this example. End of ...
Read more

python - Sequence Pattern recognition with Pybrain -

Image
I am constantly trying to use recurrent neural networks to classify a series of data. To be more specific, I have a sequence of sensor reading (which is continuous over time), I have to learn an algorithm which can detect the state related to this pattern, given the readings change. Example: Time step_1: 1.4 Time step_2: 1 Time step_3: 0.8 State = New Sequence: Time Phase 1: 0.4 Time Phase 2: 0.3 Time Phase 3: 0.1 State = Sitting I actually have 12 censors, I'm just showing a sequence of numbers for convenience. (Numbers are not real, I'm just trying to fulfill this idea)! I am trying to make my network with PyBrain RNN, however, I can not get a Data Set Container that can detect it, like information I tried to use sequential data But after some testing I came to know that this number is the next element in the sequence of numbers. Here's how I prepare my dataset: self.alldata = SequentialDataSet (ds.num_features, 1) # Now add samples to the dat...
Read more