Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
For this, you can use date_add(). Let us first create a table −mysql> create table DemoTable1930 ( DueTime datetime ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1930 values('2017-10-21'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1930 values('2019-12-14'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1930 values('2018-11-26'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1930 values('2014-06-16'); Query OK, 1 row affected (0.00 sec)Display all records from the table using select statement −mysql> select * from DemoTable1930;This will ... Read More
The IntlChar::isprint() function checks whether the given input character is a printable character or not.SyntaxIntlChar::isprint( val )Parametersval − An integer values or character encoded as a UTF-8 string. Required!ReturnThe IntlChar::isprint() function returns TRUE if the val is a printable characterExampleThe following is an example −OutputThe following is the output −bool(true) bool(true) bool(false)ExampleLet us see another example −OutputThe following is the output −NULL bool(true) NULL
To reset primary key, at first use TRUNCATE table, then use ALTER TABLE. Let us first create a table −mysql> create table DemoTable1929 ( UserId int NOT NULL AUTO_INCREMENT, PRIMARY KEY(UserId) ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1929 values(); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1929 values(); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1929 values(); Query OK, 1 row affected (0.00 sec)Display all records from the table using select statement −mysql> select * from DemoTable1929;This ... Read More
The IntlChar::isalnum() function is used to check the given input is an alphanumeric character or not. The alphanumeric character is a digit or letter.Syntaxbool IntlChar::isalnum(val)Parametersval − An integer values or character encoded as a UTF-8 string.ReturnThe IntlChar::isalnum()function returns TRUE if the val is alphanumeric.ExampleThe following is an example −OutputThe following is the output −NULL NULL NULL bool(true)ExampleLet us see another example −OutputThe following is the output −bool(false) bool(true)
With jQuery, you can easily find siblings of an element using the following methods: next(), nextAll(), prev(), prevAll(), siblings(), etc. Let us see some of them traverse siblings−next() methodThe next() method is used to return the next sibling element of the selected element. Let us see an example−Example Live Demo div { width:600px; } .demo * { display: block; border: 2px solid orange; color: blue; padding: 10px; margin: 10px; } $(document).ready(function(){ $("h3").next().css({"color": "gray", "border": "3px dashed blue"}); }); parent sibling ... Read More
To insert in a table in stored procedure, the syntax is as follows −create procedure yourProcedureName(OptionalParameter) begin insert into yourTableName() values(yourValue1, yourValue2, ...N); endTo understand the above syntax, let us first create a table −mysql> create table DemoTable1928 ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(20), Age int ); Query OK, 0 rows affected (0.00 sec)Here is the query to create a stored procedure −mysql> delimiter // mysql> create procedure insert_demo(IN Name varchar(40), IN Age int) begin insert into DemoTable1928(Name, Age) values(Name, Age); end // Query OK, ... Read More
The coalesce() can be used to print first NOT NULL column value. Let us first create a table −mysql> create table DemoTable1927 ( StudentName varchar(20), StudentSubject varchar(20) ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1927 values('Chris', 'MySQL'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1927 values('David', NULL); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1927 values(NULL, 'MongoDB'); Query OK, 1 row affected (0.00 sec)Display all records from the table using select statement −mysql> select * from DemoTable1927;This will ... Read More
To traverse and find descendants of an element, jQuery has the following methods: children() and find().children() methodThe childreb() method in jQuery is used to return the direct children of the selected element (only a single level of direct children). Let us see an example−Example Live Demo div { width:600px; } .demo * { display: block; border: 2px solid orange; color: blue; padding: 10px; margin: 10px; } $(document).ready(function(){ $("div").children().css({"color": "gray", "border": "3px dashed blue"}); }); great-great-grandparent great-grandparent grandparent parent span ... Read More
For this, you can use ORDER BY CASE statement. Let us create a table −mysql> create table DemoTable1926 ( Position varchar(20), Number int ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1926 values('Highest', 50); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1926 values('Highest', 30); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1926 values('Lowest', 100); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1926 values('Lowest', 120); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1926 values('Lowest', ... Read More
Create a function to check whether a string begins with the specified string or not. The function should return TRUE on success or FALSE on failure.The following is the syntax −begnWith(str, begnStr)Consider the following parameters in it to check −str − The string to be testedbegnStr − The text to be searched in the beginning of the specified string.ExampleThe following is an example − Live Demo