AmitDiwan has Published 2129 Answers

AmitDiwan has Published 2129 Answers

MySQL number-string formatting to pad zeros on the left of a string with numbers after a slash

MySQL MySQLi Database

Published on 08-Nov-2019 11:20:41

Let us first create a table −mysql> create table DemoTable1369 -> ( -> BatchId varchar(20) -> ); Query OK, 0 rows affected (0.46 sec)Insert some records in the table using insert command. We have inserted numbers here separated by a slash −mysql> insert into ... Read More

Math.Sin() Method in C#

Csharp Server Side Programming Programming

Published on 08-Nov-2019 11:20:31

The Math.Sin() method in C# is used to return the sine of a specified angle.SyntaxFollowing is the syntax −public static double Sin (double val);Above, the argument value is an angle.ExampleLet us now see an example to implement Math.Sin() method −using System; public class Demo { public static void Main(){ ... Read More

Implement numbering in MySQL GROUP_CONCAT

MySQL MySQLi Database

Published on 08-Nov-2019 11:19:16

Let us first create a table −mysql> create table DemoTable1627 -> ( -> FirstName varchar(20), -> LastName varchar(20) -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command.mysql> insert into DemoTable1627 values('John', 'Smith'); Query OK, ... Read More

Math.Sign() Method in C#

Csharp Server Side Programming Programming

Published on 08-Nov-2019 11:18:18

The Math.Sign() method in C# is used to return an integer that indicates the sign of a number.MethodsThe Math.Sign() overloads the following methods −Math.Sign(Int16) Math.Sign(Int32) Math.Sign(Int64) Math.Sign(SByte) Math.Sign(Single) Math.Sign(Decimal) Math.Sign(Double)ExampleLet us now see an example to implement Math.Sign() method −using System; public class Demo { public static void Main(){ ... Read More

MySQL query to append a number of stars based on string length?

MySQL MySQLi Database

Published on 08-Nov-2019 11:17:51

For this, you can use RPAD(). Let us first create a table −mysql> create table DemoTable1626 -> ( -> Name varchar(20) -> ); Query OK, 0 rows affected (0.37 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1626 values('Chris'); Query ... Read More

Adding dash between spaces in field name in MySQL?

MySQL MySQLi Database

Published on 08-Nov-2019 11:16:51

You can use REPLACE() for this. Let us first create a table −mysql> create table DemoTable1625 -> ( -> FullName varchar(20) -> ); Query OK, 0 rows affected (0.68 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1625 values('John Doe'); ... Read More

Math.Round() Method in C#

Csharp Server Side Programming Programming

Published on 08-Nov-2019 11:15:54

The Math.Round() method in C# rounds a value to the nearest integer or to the specified number of fractional digits.MethodsThe following are the methods overloaded by Math.Round() −Math.Round(Double) Math.Round(Double, Int32) Math.Round(Double, Int32, MidpointRounding) Math.Round(Double, MidpointRounding) Math.Round(Decimal) Math.Round(Decimal, Int32) Math.Round(Decimal, Int32, MidpointRounding) Math.Round(Decimal, MidpointRounding)ExampleLet us now see an example to implement ... Read More

SELECT * WHERE var == [one of many alternatives] in MySQL?

MySQL MySQLi Database

Published on 08-Nov-2019 11:15:50

Use IN() for select * where var== [one of many alternatives]. Let us first create a table −mysql> create table DemoTable1624 -> ( -> ClientId int, -> ClientName varchar(20) -> ); Query OK, 0 rows affected (0.39 sec)Insert some records in the ... Read More

How to sort an alphanumeric column with different lengths in MySQL?

MySQL MySQLi Database

Published on 08-Nov-2019 11:14:54

Let us first create a table −mysql> create table DemoTable1623 -> ( -> StudentCode varchar(20) -> ); Query OK, 0 rows affected (0.47 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1623 values('STU-MIT-143'); Query OK, 1 row affected (0.19 sec) ... Read More

How to correctly use WITH ROLLUP in MySQL?

MySQL MySQLi Database

Published on 08-Nov-2019 11:13:57

The syntax is as follows to use WITH ROLLUP −select yourColumnName1, sum(yourColumnName2) from yourTableName group by yourColumnName1 with rollup;Let us first create a table −mysql> create table DemoTable1622 -> ( -> EmployeeCountryName varchar(20), -> EmployeeSalary int -> ); Query OK, 0 rows ... Read More

1 2 3 4 5 6 7 ... 213 Next

Advertisements