Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
jQuery.empty()The empty() method removes all child nodes from the set of matched elements.ExampleYou can try to run the following code to learn how to work with jQuery empty() method:Live Demo jQuery empty() method $(document).ready(function() { $("div").click(function () { $(this).empty(); }); }); ... Read More
For this, you can use GROUP BY HAVING clause. Let us first create a table −mysql> create table DemoTable1467 -> ( -> Id int, -> Name varchar(20) -> ); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1467 values(100, 'Chris'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable1467 values(110, 'David'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable1467 values(120, 'Mike'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1467 values(100, 'Chris'); Query OK, 1 row affected (0.12 sec) ... Read More
To get or set the value at the specified key in StringDictionary, the code is as follows −Example Live Demousing System; using System.Collections.Specialized; public class Demo { public static void Main() { StringDictionary myDict = new StringDictionary(); myDict.Add("1", "Tablet"); myDict.Add("2", "Desktop"); myDict.Add("3", "Speakers"); myDict.Add("4", "Laptop"); myDict.Add("5", "Notebook"); myDict.Add("6", "Ultrabook"); myDict.Add("7", "HDD"); myDict.Add("8", "SDD"); myDict.Add("9", "Headphone"); myDict.Add("10", "Earphone"); Console.WriteLine("Value for key 5 = "+myDict["5"]); ... Read More
Do not use the below query for this −insert into yourTableName values(yourValue1, yourValue2, ...N); insert into yourTableName values(yourValue1, yourValue2, ...N); insert into yourTableName values(yourValue1, yourValue2, ...N); . . . NYou can use below query as the fastest way to insert with multiple values in a single query −insert into yourTableName values(yourValue1, yourValue2, ...N), (yourValue1, yourValue2, ...N), (yourValue1, yourValue2, ...N), ...................N;Let us first create a table −mysql> create table DemoTable1466 -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> Name varchar(20), -> Age int -> ); Query OK, 0 rows affected (0.98 sec)Insert some records ... Read More
To insert element as a first child using jQuery, use the prepend() method. The prepend( content ) method prepends content to the inside of every matched element.ExampleYou can try to run the following code to learn how to insert element as a first child using jQuery:Live Demo jQuery Example var x = 0; $(document).ready(function() { $('.add').on('click', function (event) { var html = "demo text " + x++ + ""; $("#parent-div").prepend(html); }); }); .div { margin:10px; padding:12px; border:2px solid #F38B00; width:60px; } Hello World
To remove all the strings from the StringCollection, the code is as follows −Example Live Demousing System; using System.Collections.Specialized; public class Demo { public static void Main() { StringCollection stringCol = new StringCollection(); String[] arr = new String[] { "100", "200", "300", "400", "500" }; Console.WriteLine("Array elements..."); foreach (string res in arr) { Console.WriteLine(res); } stringCol.AddRange(arr); Console.WriteLine("Does the specified string is in the StringCollection? = "+stringCol.Contains("800")); Console.WriteLine("Total number of elements = "+stringCol.Count); ... Read More
You are making a small mistake over here. Method addContent is a method available for UI5 controls not over normal DOM elements.If you want to gain a reference to the button then you can try with the below snippet:this.getView().byId("").addContent(new sap.m.Button({ : }));
Let us first create a table −mysql> create table DemoTable1465 -> ( -> Name varchar(40) -> ); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1465 values('Chris Brown'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable1465 values('David Miller'); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable1465 values('John Doe'); Query OK, 1 row affected (0.14 sec)Display all records from the table using select statement −mysql> select * from DemoTable1465;This will produce the following output −+--------------+ | Name | ... Read More
To insert element as a last child using jQuery, use the append() method. The append( content ) method appends content to the inside of every matched element.ExampleYou can try to run the following code to learn how to insert element as a last child using jQuery:Live Demo jQuery Example var x = 0; $(document).ready(function() { $('.add').on('click', function (event) { var html = "demo text " + x++ + ""; $("#parent-div").append(html); }); }); .div{ margin:10px; padding:12px; border:2px solid #F38B00; width:60px; } Hello World
You can use stored procedure and can pass the value via parameter. Let us first create a table −mysql> create table DemoTable1464 -> ( -> Id int, -> FirstName varchar(20) -> ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1464 values(101, 'Chris Brown'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable1464 values(102, 'John Doe'); Query OK, 1 row affected (0.09 sec)Display all records from the table using select statement −mysql> select * from DemoTable1464;This will produce the following output −+------+-------------+ | Id ... Read More