Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The IntlChar tolower() function converts the character into Unicode character lowercase.SyntaxIntlChar::tolower (val)Parametersval − An integer or character encoded as a UTF-8 string.ReturnThe IntlChar tolower() function returns the converted lowercas character. If the character is already in lowercase, the same character is returned.ExampleThe following is an example −OutputThe following is the output −string(1) "J" NULL string(1) "J" NULL
The IntlChar toupper()function converts the character into Unicode character uppercase.SyntaxIntlChar::toupper (val)Parametersval − An integer or character encoded as a UTF-8 string.ReturnThe IntlChar toupper()function returns the converted uppercase character. If the character is already in uppercase, the same character is returned.ExampleThe following is an example −OutputThe following is the output −string(1) "J" NULL string(1) "J" NULL
To insert records from multiple tables, use INSERT INTO SELECT statement. Here, we will insert records from 2 tables.Let us first create a table −mysql> create table DemoTable1943 ( Name varchar(20) ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1943 values('Chris'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1943 values('Robert'); Query OK, 1 row affected (0.00 sec)Display all records from the table using select statement −mysql> select * from DemoTable1943;This will produce the following output −+--------+ | Name | +--------+ | Chris ... Read More
The detach() method in jQuery is used to remove selected elements.SyntaxThe syntax is as follows −$(selector).detach()ExampleLet us now see an example to implement the jQuery detach() method − Live Demo $(document).ready(function(){ $("button").click(function(){ $("span").detach(); }); }); span { background-color: red; color: white; } Demo Heading This is a demo text. Remove element OutputThis will produce the following output −Click “Remove element” −
For this, use regular expression. The syntax is as follows −select * from information_schema.schemata WHERE SCHEMA_NAME REGEXP '^yourValue_+[A-Z]';Let us create some databases −mysql> create database bank_APP1; Query OK, 1 row affected (0.00 sec) mysql> create database bank_APP2; Query OK, 1 row affected (0.00 sec) mysql> create database bank_APP3; Query OK, 1 row affected (0.00 sec)Here is the query to get all databases having upper case character after some word −mysql> select * from information_schema.schemata WHERE SCHEMA_NAME REGEXP '^bank_+[A-Z]';This will produce the following output −+--------------+-------------+----------------------------+------------------------+----------+ | CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH | +--------------+-------------+----------------------------+------------------------+----------+ | def ... Read More
The dequeue() method in jQuery is used to remove the next function from the queue and then execute the function.SyntaxThe syntax is as follows −$(selector).dequeue(queue)Above, the queue is the name of the queue.ExampleLet us now see an example to implement the jQuery dequeue() method − Live Demo $(document).ready(function(){ $("button").click(function(){ var div = $("div"); div.animate({height: 250}, "slow"); div.animate({left: "+=200", top: "+=100" }, "slow"); div.queue(function(){ div.dequeue(); }); ... Read More
For this, use COUNT(*) along with GROUP BY clause. Let us first create a table −mysql> create table DemoTable1942 ( Value int ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1942 values(1); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1942 values(2); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1942 values(3); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1942 values(2); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1942 values(3); Query OK, 1 row affected (0.00 ... Read More
The remove() method in jQuery is used to remove the selected elements.SyntaxThe syntax is as follows −$(selector).remove(selector)Above, the parameter selector is used to specify one or more elements to be removed.ExampleLet us now see an example to implement the jQuery remove() method − Live Demo $(document).ready(function(){ $("button").click(function(){ $("span").remove(); }); }); span { background-color: red; color: white; } Demo Heading This is a demo text. Remove element OutputThis will produce the following output −Now, click the “Remove element” to remove the span element in red. After clicking the “Remove element” button −
The imagecreate() function is used to create a new image. It is preferred to use imagecreatetruecolor() to create an image instead of imagecreate(). This is because the image processing occurs on the highest quality image possible which can be created using imagecreatetruecolor().Syntaximagecreate( $width, $height )Parameterswidth: The width of imageheight: The height of imageReturnThe imagecreate() function returns an image resource identifier on success or FALSE on errors.ExampleThe following is an example:OutputThe following is the output:
The imagesx() function gets the width of image. It returns the width of the image or FALSE on errors.Syntaximagesx(img)Parametersimg: Image resource created with imagecreatetruecolor()ReturnThe imagesx() function returns the width of the image or FALSE on errors.ExampleThe following is an example: Live DemoOutputThe following is the output:450