java - MySQL: How to Update values into multiple rows and use where clause as well? -

-

मैं अद्यतन एक int मान ( प्राथमिक कुंजी < / Code>, देश नामित अन्य तालिका से city_id स्तंभ में पुनर्प्राप्त (जो कि विदेशी कुंजी है व्यक्ति तालिका <कोड> देश से तालिका), सभी पंक्तियों में जहां नाम विशेषता / कॉलम का मान जॉन, एमी, एडम, अब्राहम, बॉब, डेविड, रॉबर्ट, जॉर्ज, एलिजाबेथ, माइक और बारबरा है।

मैंने इस प्रश्न का उपयोग करने की कोशिश की लेकिन मुझे एक अपवाद मिलता है कि मेरी MySQL वाक्यविन्यास में कोई त्रुटि है 

  स्ट्रिंग क्वेरी 1 = "अद्यतन व्यक्तियों को सेट करें city_id =" + rid + "जहां" + "(नाम = 'जॉन' और '+' नाम = 'एमी' और '+' नाम = 'एडम 'और' + 'नाम =' इब्राहीम 'और' + 'नाम =' बॉब 'और' + 'नाम =' डेविड 'और "+" नाम =' रॉबर्ट 'और "+" नाम =' जॉर्ज 'और' + " नाम = 'एलिजाबेथ' और '+' नाम = 'माइक' और '+' नाम = 'बारबरा') ";

मैंने कोष्ठक को भी हटाकर यह कोशिश की।

तो क्या कोई यह बता सकता है कि इसके साथ क्या गलत है, या कोई अन्य क्वेरी जो मेरे उद्देश्य की सेवा कर सकती है?

आप उपयोग कर सकते हैं 

  स्ट्रिंग query1 = " अद्यतन व्यक्तियों को सिटी_id = "+ rid +" कहां नाम = 'जॉन' या नाम = 'एमी' या नाम = 'एडम' या नाम = 'इब्राहीम' या नाम = 'बॉब' या नाम = 'डेविड' या नाम = 'रॉबर्ट 'या नाम =' जॉर्ज 'या नाम =' एलिजाबेथ 'या नाम =' माइक 'या नाम =' बारबरा '";

या आप उपयोग कर सकते हैं 

  स्ट्रिंग क्वेरी 1 = "अद्यतन व्यक्तियों को सेट करें city_id =" + rid + "जहां नाम ('जॉन', 'एमी' 'एडम', 'अब्राहम', 'बॉब', 'डेविड', 'रॉबर्ट', 'जॉर्ज', 'एलिजाबेथ', 'माइक', 'बारबरा') ";

Comments

Post a Comment

Popular posts from this blog

c# - Highlight all words containing a letter in a richtextbox -

-
How do I highlight all the words in a letter in a rich text box? If I want to expose the words that contain the letters "a", such as a hat or candle word, both words are highlighted, I am using C # on Winform. Private Zero Button 208_Click (Object Sender, EventArgs E) {HighlightFrage (Rich Textbox 1, "A", Color. Yellow); } It exposes all the words with a word "a", but I'm not sure how to highlight the length of the spaces. Thank you. You can use the method to find incidents of sub-location. Then, use the property to change the colors back to Highlight colors for each event. int len ​​= richTextBox.TextLength; Int index = 0; String textconfind = "A"; // This will highlight the text you are viewing (index & lt; len) {richTextBox.Find (textToFind, index, len, RichTextBoxFinds.None); RichTextBox.SelectionBackColor = Color.Yellow; Index = rich textbox. Lesson Index (texttofind, index) + textaophind Langeline; } If you want...
Read more

Admob interstitials not clickable on Nexus 5 (Android 4.4.2) -

-
Image
Do you know about a problem due to Admob not being able to click on interstitial ads and therefore on Nexus 5 devices Have not brought any revenue? Fact: It does not have intermediate ads - some clickable, but mostly no . It comes with the old standalone Google Admob SDK and with the new Google Play Services SDK. It is on Nexus 5 with Android 4.4.2 , but it is possible that other devices are also affected. This happens in many programs in the Google Play Store - I'm not only with my application. For example, you can not Galaxy Nexus (Nexus 3), Galaxy S, on the HTC One. Below is a screenshot that opens the small info button in the clickable below the ad and OK, the Close X button also looks working properly , Though clicking on the ad does not happen - like it does not exist or something on it. Do you know of any solutions or possible solutions to the problem? Thanks! --- Update - - This activity declaration is: & amp; Activity Activity:...
Read more

java - MigLayout - selective component fill -

-
Image
I am trying to add a JTabbedPane to a panel, as well as for control I am using Migrates with the following buttons. However, I can not even get the JTabbedPane to fill without the buttons when they are not needed. The following SSCCE: public static zero main (string [] args) {jpn panel = new zpinal (new megallout (new lc.) Filling ())) ; Panel.add (new pocket ("+"); Panel.add (new pocket ("-"), "wrap"); Panel.ed (new zetaabbedpan (), "duration, increase"); Jeffre Frame = New Gefram (); Frame.add (panel); Frame.setSize (new dimension (300, 500)); Frame.setLocationRelativeTo (zero); Frame.setVisible (true); Frame.setDefaultCloseOperation (JFrame.EXIT_ON_CLOSE); } This creates a panel that looks like this: However, if I lack layout ( JPanel panel = new JPanel (new MigLayout)); ), looks like: If you do not want to apply a barrier to all the cells, do not say the layout ;-), instead, use the column and row barr...
Read more