AmitDiwan has Published 11365 Articles

Select different fields in MySQL even if a field is set to null?

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:01:32

120 Views

For this, you can use COALESCE(). Let us first create a table −mysql> create table DemoTable1336    -> (    -> FirstName varchar(20)    -> ,    -> SecondName varchar(20)    -> ); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command −mysql> insert ... Read More

Math.Tanh() Method in C#

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:01:26

52 Views

The Math.Tanh() method in C# is used to return the hyperbolic tangent of the specified angle.Syntaxpublic static double Tanh (double val);Above, Val is the angle.ExampleLet us now see an example to implement Math.Tanh() method −using System; public class Demo {    public static void Main(){       double val1 ... Read More

jQuery :checked Selector

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:00:05

233 Views

The :checked selector in jQuery is used to look for all the checked radio button or checkboxes and selects them.SyntaxThe syntax is as follows −$(":checked")ExampleLet us now implement the :checked selector in jQuery − Favourite Subject Maths: English ... Read More

Select entries with timestamp after X time in MySQL

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 06:59:01

337 Views

Let us first create a table −mysql> create table DemoTable1335    -> (    -> ArrivalTime datetime    -> ); Query OK, 0 rows affected (0.49 sec)Insert some records in the table using insert command. We have inserted date time records here −mysql> insert into DemoTable1335 values('2019-09-19 22:54:00'); Query OK, ... Read More

CharEnumerator.Reset() Method in C#

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 06:58:50

69 Views

The CharEnumerator.Reset() method in C# initializes the index to a position logically before the first character of the enumerated string.Syntaxpublic void Reset ();ExampleLet us now see an example to implement the CharEnumerator.Reset() method −using System; public class Demo {    public static void Main(){       string strNum = ... Read More

Insert values in two tables with a single stored procedure call in MySQL

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 06:56:13

1K+ Views

Following is the syntax to insert values in two tables with a stored procedure −DELIMITER // CREATE PROCEDURE yourProcedureName(anyVariableName int)    BEGIN    insert into yourTableName1(yourColumnName1) values(yourVariableName);    insert into yourTableName2(yourColumnName2) values(yourVariableName);    END //Let us first create a table −mysql> create table DemoTable1    -> (    -> StudentScore ... Read More

jQuery :checkbox Selector

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 06:56:05

327 Views

The jQuery :checkbox selector is used to select input elements with type checkbox.SyntaxThe syntax is as follows −$(":checkbox")ExampleLet us see an example to implement the :checkbox selector in jQuery −    $(document).ready(function(){       $(":checkbox").wrap("");    }); Fill the form ID: ... Read More

jQuery :button Selector

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 06:54:51

401 Views

The jQuery :button selector is used to select button and input elements with type button.ExampleLet us now see an example to implement the :button selector −    $(document).ready(function(){       $(":button").css("border-width", "5px");    }); Username: Password: Demo Button ... Read More

MySQL row declarations for ZF?

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 06:53:33

152 Views

The ZF stands for ZEROFILL i.e. row declarations for zero fill Let us first create a table. Here, we have set the int field size to be 10 −mysql> create table DemoTable1332    -> (    -> Number int(10) ZEROFILL NOT NULL DEFAULT 0    -> ); Query OK, 0 ... Read More

CharEnumerator.MoveNext() Method in C#

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 06:52:44

306 Views

The CharEnumerator.MoveNext() method in C# is used to increments the internal index of the current CharEnumerator object to the next character of the enumerated string.Syntaxpublic bool MoveNext ();Let us now see an example to implement the CharEnumerator.MoveNext() method −Exampleusing System; public class Demo {    public static void Main(){   ... Read More

Advertisements