Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The Dictionary.Item[] property in C# is used to get or set the value associated with the specified key in the Dictionary.SyntaxFollowing is the syntax −public TValue this[TKey key] { get; set; }ExampleLet us now see an example to implement the Dictionary.Item[] property −using System; using System.Collections.Generic; public class Demo { public static void Main(){ Dictionary dict = new Dictionary(); dict.Add("One", "Chris"); dict.Add("Two", "Steve"); dict.Add("Three", "Messi"); dict.Add("Four", "Ryan"); dict.Add("Five", "Nathan"); Console.WriteLine("Count of elements = "+dict.Count); ... Read More
The Dictionary.Add() method in C# is used to add a specified key and value to the dictionary.SyntaxFollowing is the syntax −public void Add (TKey key, TValue val);Above, the key parameter is the key, whereas Val is the value of the element.ExampleLet us now see an example to implement the Dictionary.Add() method −using System; using System.Collections.Generic; public class Demo { public static void Main(){ Dictionary dict = new Dictionary(); dict.Add("One", "John"); dict.Add("Two", "Tom"); dict.Add("Three", "Jacob"); dict.Add("Four", "Kevin"); dict.Add("Five", "Nathan"); ... Read More
The DateTimeOffset.AddSeconds() method in C# is used to return a new DateTimeOffset object that adds a specified number of whole and fractional seconds to the value of this instance.SyntaxFollowing is the syntax −public DateTimeOffset AddSeconds (double val);Above, Val is the number of seconds to be added. To subtract seconds, set a negative value.ExampleLet us now see an example to implement the DateTimeOffset.AddSeconds() method −using System; public class Demo { public static void Main() { DateTimeOffset dateTimeOffset = new DateTimeOffset(2019, 10, 11, 7, 10, 20, new TimeSpan(-5, 0, 0)); Console.WriteLine("DateTimeOffset (before adding seconds) = ... Read More
For this, use BETWEEN keyword. Let us first create a −mysql> create table DemoTable1444 -> ( -> Value int, -> PurchaseDate datetime -> ); Query OK, 0 rows affected (0.45 sec)Insert some records in the table using insert −mysql> insert into DemoTable1444 values(40, '2019-01-10'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable1444 values(100, '2019-10-03'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1444 values(170, '2019-11-21'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable1444 values(70, '2018-12-05'); Query OK, 1 row affected (0.11 sec)Display all records from the table using ... Read More
You need to use GROUP BY clause. Let us first create a −mysql> create table DemoTable1443 -> ( -> StudentId int, -> StudentScore int -> ); Query OK, 0 rows affected (0.42 sec)Insert some records in the table using insert −mysql> insert into DemoTable1443 values(100, 78); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable1443 values(101, 89); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1443 values(100, 88); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable1443 values(101, 97); Query OK, 1 row affected (0.12 sec)Display all records from the ... Read More
Let us first create a −mysql> create table DemoTable1442 -> ( -> DueTime time -> ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert −mysql> insert into DemoTable1442 values('00:08:00'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1442 values('00:04:00'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable1442 values('12:55:00'); Query OK, 1 row affected (0.15 sec)Display all records from the table using select −mysql> select * from DemoTable1442;This will produce the following output −+----------+ | DueTime | +----------+ | 00:08:00 | | 00:04:00 | | 12:55:00 | ... Read More
MySQL will implicitly convert the column into a number. Following is the syntax −select * from yourTableName order by yourColumnName*1;Let us first create a −mysql> create table DemoTable1441 -> ( -> Id varchar(30) -> ); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert −mysql> insert into DemoTable1441 values('301'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable1441 values('23'); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable1441 values('345'); Query OK, 1 row affected (0.42 sec) mysql> insert into DemoTable1441 values('10'); Query OK, 1 row affected (0.23 sec) ... Read More
Use DEFAULT keyword in MySQL to set default value to NULL. Let us first create a −mysql> create table DemoTable1440 -> ( -> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> StudentName varchar(20) DEFAULT NULL, -> StudentAge int DEFAULT NULL -> ); Query OK, 0 rows affected (0.55 sec)Insert some records in the table using insert command. For values left blank, the default gets inserted −mysql> insert into DemoTable1440(StudentName, StudentAge) values('Chris', 21); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable1440 values(); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable1440(StudentName) ... Read More
For specific value, use FIND_IN_SET(). Let us first create a −mysql> create table DemoTable1439 -> ( -> CountryId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> CountryCode varchar(20) -> ); Query OK, 0 rows affected (0.49 sec)Insert some records in the table using insert −mysql> insert into DemoTable1439(CountryCode) values('1022_US, 7894_UK'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable1439(CountryCode) values('6567_AUS, 7894_UK'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1439(CountryCode) values('6567_AUS'); Query OK, 1 row affected (0.09 sec)Display all records from the table using select −mysql> select * from DemoTable1439;This will produce the ... Read More
For this, you can use JSON data type from MySQL. Let us first create a −mysql> create table DemoTable1438 -> ( -> EmployeeDetails json -> ); Query OK, 0 rows affected (5.97 sec)Insert some records in the table using insert −mysql> insert into DemoTable1438 values('[{"EmployeeId":"EMP-101","EmployeeName":"Chris"},{"EmployeeId":"EMP-102","EmployeeName":"David"},{"EmployeeId":"EMP-103","EmployeeName":"Sam"}]'); Query OK, 1 row affected (0.22 sec)Display all records from the table using select −mysql> select * from DemoTable1438;This will produce the following output −+------------------------------------------------------------------------------------------------------------------------------------------------------------+ | EmployeeDetails | +------------------------------------------------------------------------------------------------------------------------------------------------------------+ | [{"EmployeeId": "EMP-101", "EmployeeName": "Chris"}, {"EmployeeId": "EMP-102", "EmployeeName": "David"}, {"EmployeeId": "EMP-103", "EmployeeName": "Sam"}] | +------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)