Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
To return TRUE or FALSE if another field contains a string, use IF(). Let us first create a tablemysql> create table DemoTable ( FirstName varchar(100), LastName varchar(100) ); Query OK, 0 rows affected (1.28 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 'Brown'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values('David', 'Miller'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('Adam', 'Smith'); Query OK, 1 row affected (0.11 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following ... Read More
Since the column wherein you want to get the value more than a particular value is VARCHAR, use the CAST() function. For example, to fetch the value more than 999 from a column with varchar values.Let us first create a table −mysql> create table DemoTable ( Value varchar(100) ); Query OK, 0 rows affected (1.02 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('900'); Query OK, 1 row affected (0.49 sec) mysql> insert into DemoTable values('1090'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('860'); Query OK, 1 row affected (0.25 ... Read More
Since we need to match strings from the same row, use LIKE operator. Let us first create a table −mysql> create table DemoTable ( FirstName varchar(100), FullName varchar(100) ); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John', 'John Smith'); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable values('David', 'John Miller'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('Bob', 'Sam Miller'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values('Chris', 'Chris Brown'); Query OK, 1 row affected ... Read More
The HTML oninvalid event attribute is triggered when an input field is invalid while submitting the form in an HTML document.SyntaxFollowing is the syntax −ExampleLet us see an example of HTML oninvalid event Attribute − body { color: #000; height: 100vh; background: linear-gradient(62deg, #FBAB7E 0%, #F7CE68 100%) no-repeat; text-align: center; padding: 20px; } textarea { border: 2px solid #fff; background: transparent; font-size: 1rem; } ::placeholder { ... Read More
The HTML oninput event attribute is triggered when the user enters input in an input/textarea HTML element in an HTML document.SyntaxFollowing is the syntax −ExampleLet us see an example of HTML on input event Attribute − body { color: #000; height: 100vh; background: linear-gradient(62deg, #FBAB7E 0%, #F7CE68 100%) no-repeat; text-align: center; padding: 20px; } textarea { border: 2px solid #fff; background: transparent; font-size: 1rem; } ::placeholder { color: #000; font-size: 1rem; } HTML oninput Event Attribute Demo function inputFn() { document.querySelector('textarea').style.background = '#ffffff36'; } OutputNow enter your message in the text area to observe how oninput event attribute works.
The HTML Screen width property returns the total width of the user’s screen.SyntaxFollowing is the syntax −screen.widthExampleLet us see an example of HTML Screen width Property − body { color: #000; height: 100vh; background-color: #FBAB7E; background-image: linear-gradient(62deg, #FBAB7E 0%, #F7CE68 100%); text-align: center; } .btn { background: #db133a; border: none; height: 2rem; border-radius: 2px; width: 40%; display: block; color: ... Read More
The build() method of the Stream.Builder class builds the stream, transitioning this builder to the built state. The syntax is as follows −Stream build()Following is an example to implement the build() method of the Stream.Builder class −Exampleimport java.util.stream.Stream; public class Demo { public static void main(String[] args) { Stream.Builder builder = Stream.builder(); builder.add("Production"); builder.add("Marketing"); builder.add("Finance"); builder.add("Sales"); builder.add("Operations"); Stream stream = builder.build(); stream.forEach(System.out::println); } }OutputProduction Marketing Finance Sales OperationsExampleLet us see another example of build() ... Read More
The Stream sorted() in Java returns a stream consisting of the elements of this stream, sorted according to natural order.Following is the syntax −Stream sorted()Here, Stream is an interface in java.util.stream and is the type parameter in stream. This method returns the new stream.Following is an example to implement the sorted() method in stream class −Exampleimport java.util.*; public class Demo { public static void main(String[] args) { List list = Arrays.asList("Jack", "Tom", "Kevin", "David", "Tim", "Nathan", "John", "Ryan", "Robbie"); System.out.println("Sorted stream... "); list.stream().sorted().forEach(System.out::println); } }OutputThe sorted stream is ... Read More
The java.lang.Math.floor() returns the largest (closest to positive infinity) double value that is less than or equal to the argument and is equal to a mathematical integer. Special cases −If the argument value is already equal to a mathematical integer, then the result is the same as the argument.If the argument is NaN or an infinity or positive zero or negative zero, then the result is the same as the argument.Let us now see an example to implement the floor() method in Java −Exampleimport java.lang.*; public class Demo { public static void main(String[] args) { // get two ... Read More
The java.lang.Math.sqrt(double a) returns the correctly rounded positive square root of a double value. Special cases −If the argument is NaN or less than zero, then the result is NaN.If the argument is positive infinity, then the result is positive infinity.If the argument is positive zero or negative zero, then the result is the same as the argument.Following is an example to implement the sqrt() method of the Math class in Java −Exampleimport java.lang.*; public class Demo { public static void main(String[] args) { // get two double numbers numbers double x = 9; ... Read More