Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Let us create a table −mysql> create table DemoTable1950 ( Amount float ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1950 values(45.60); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1950 values(101.78); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1950 values(75.90); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1950 values(89.45); Query OK, 1 row affected (0.00 sec)Display all records from the table using select statement −mysql> select * from DemoTable1950;This will produce the following output −+--------+ | Amount ... Read More
To set NOT NULL attribute to an existing column, use ALTER TABLE command. Let us first create a table −mysql> create table DemoTable1949 ( UserId int, UserName varchar(20) ); Query OK, 0 rows affected (0.00 sec)Here is the query to set NOT NULL attribute to an existing column −mysql> alter table DemoTable1949 modify UserName varchar(20) not null; Query OK, 0 rows affected (0.00 sec) Records: 0 Duplicates: 0 Warnings: 0Let us check the description of table −mysql> desc DemoTable1949;This will produce the following output −+----------+-------------+------+-----+---------+-------+ | Field | Type | Null | ... Read More
The slideUp() method in jQuery is used to slide up the selected element i.e. to hide them.SyntaxThe syntax is as follows −$(selector).slideUp(speed, easing, callback)Above, the parameter speed is the speed of the slide effect. Here, easing is the speed of the element in different points of the animation, whereas callback is a function to be executed after slideUp() completes.ExampleLet us now see an example to implement the jQuery slideUp() method − Live Demo $(document).ready(function(){ $(".button1").click(function(){ $("p").slideUp(); }); $(".button2").click(function(){ $("p").slideDown(); ... Read More
To sort only numbers from alphanumeric string, use ORDER BY RIGHT(). Let us first create a table −mysql> create table DemoTable1948 ( StudentCode varchar(20) ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1948 values('121John_567'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1948 values('Adam_101'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1948 values('Bob_563'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1948 values('Sam_346'); Query OK, 1 row affected (0.00 sec)Display all records from the table using select statement −mysql> ... Read More
The parent > child selector in jQuery is used to select all elements that are a direct child of the specified element.SyntaxThe syntax is as follows −("parent > child")ExampleLet us now see an example to implement the jQuery parent > child selector − Live Demo $(document).ready(function(){ $("div > span").css("color", "red"); }); div { border:1px solid black; padding:10px; } Demo Heading This is demo text. span outside p element This is demo text. This is demo text. This is demo text. span inside p element. This is demo text. OutputThis will produce the following output −
Let us first create a table −mysql> create table DemoTable1947 ( Id int, Name varchar(20) ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1947 values(101, 'Chris'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1947 values(102, 'David'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1947 values(103, 'Mike'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1947 values(104, 'Bob'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1947 values(105, 'Sam'); Query OK, 1 row affected (0.00 sec)Display ... Read More
The IntlChar getFC_NFKC_Closure() function is used to get the FC_NFKC_Closure property for the value val.SyntaxIntlChar::getFC_NFKC_Closure(val)Parametersval − An integer or character encoded as a UTF-8 string.ReturnThe IntlChar getFC_NFKC_Closure()function returns the FC_NFKC_Closure property string for the entered value val.ExampleThe following is an example −OutputThe following is the output −NULL string(0) "" NULL NULL
The IntlChar getBidiPairedBracket() function is used to get the paired bracket character for the value val.SyntaxIntlChar::getBidiPairedBracket (val)Parametersval − An integer or character encoded as a UTF-8 string.ReturnThe IntlChar getBidiPairedBracket()function returns the mapped paired bracket.ExampleThe following is an example −OutputThe following is the output −int(15) string(1) ")" NULL string(1) "J"
The siblings() method in jQuery is used to return all sibling elements of the selected element.SyntaxThe syntax is as follows −$(selector).siblings(filter)Above, the filter specifies a selector expression to narrow down the search for sibling elements.Let us now see an example to implement the jQuery siblings() method −Example Live Demo div { width:600px; } .demo * { display: block; background-color; border: 2px solid yellow; color: blue; padding: 10px; margin: 10px; } $(document).ready(function(){ $("li.test").siblings().css({"background-color": "orange", "color": "white", "border": "3px dashed blue"}); }); Demo ... Read More
The IntlChar getBlockCode() function is used to get the Unicode allocation block containing the value val.SyntaxIntlChar::getBlockCode (val)Parametersval − An integer or character encoded as a UTF-8 string.ReturnThe IntlChar getBlockCode()function returns the block value for val. The following is the listing −IntlChar::BLOCK_CODE_BASIC_LATINIntlChar::BLOCK_CODE_GREEKIntlChar::BLOCK_CODE_MISCELLANEOUS_SYMBOLSExampleThe following is an example −OutputThe following is the output −bool(true) bool(false) bool(false)