Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Do not use backticks, you can use single quotes in CONCAT(). Following is the syntax −select concat(yourColumnName1, ' ', yourColumnName2) from yourTableName;Let us first create a table −mysql> create table DemoTable1359 -> ( -> Id int, -> Name varchar(20) -> ); Query OK, 0 rows affected (0.58 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1359 values(101, 'Chris'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable1359 values(102, 'Adam'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable1359 values(103, 'Mike'); Query OK, 1 row ... Read More
The DateTime.GetDateTimeFormats() method in C# is used to convert the value of this instance to all the string representations supported by the standard date and time format specifiers.SyntaxFollowing is the syntax −public string[] GetDateTimeFormats () public string[] GetDateTimeFormats (char ch);Above, ch is a standard date and time format string.ExampleLet us now see an example to implement the DateTime.GetDateTimeFormats() method −using System; public class Demo { public static void Main() { DateTime d = new DateTime(2019, 11, 10, 7, 20, 45); string[] res = d.GetDateTimeFormats(); foreach(string s in res) ... Read More
The DateTime.FromOADate() method in C# is used to return a DateTime equivalent to the specified OLE Automation Date.SyntaxFollowing is the syntax −public static DateTime FromOADate (double val);Above, Val is the OLE Automation Date value.ExampleLet us now see an example to implement the DateTime.FromOADate() method −using System; public class Demo { public static void Main() { DateTime d1 = DateTime.FromOADate(1.0); Console.WriteLine("DateTime = {0:dd} {0:y}, {0:hh}:{0:mm}:{0:ss} ", d1); } }OutputThis will produce the following output −DateTime = 31 December 1899, 12:00:00ExampleLet us now see another example to implement the DateTime.FromOADate() method −using System; public ... Read More
The UInt32 struct represents a 32-bit unsigned integer. The UInt32 value type represents unsigned integers with values ranging from 0 to 4, 294, 967, 295.Let us now see some examples of UInt32 Struct methods −UInt32.CompareTo()The UInt32.CompareTo() method in C# is used to compare the current instance to a specified object or UInt32 and returns an indication of their relative values.SyntaxFollowing is the syntax −public int CompareTo (object val); public int CompareTo (uint val;Above, the value for the 1st syntax is an object to compare. The value for 2nd syntax is an unsigned integer to compare.The return value is 0 if ... Read More
The UInt16 struct represents a 16-bit unsigned integer. The UInt16 value type represents unsigned integers with values ranging from 0 to 65535.Let us now see some examples of UInt16 Struct methods −UInt16.CompareTo()The UInt16.CompareTo() method in C# is used to compare the current instance to a specified object or UInt16 and returns an indication of their relative values.SyntaxFollowing is the syntax −public int CompareTo (object val); public int CompareTo (ushort val;Above, the value for the 1st syntax is an object to compare. The value for 2nd syntax is an unsigned integer to compare.The return value is 0 if the current instance ... Read More
The Match class has static methods and constants for trigonometric, logarithmic and other mathematical functions.The Math class in C# has Math.E and Math.PI fields. Let us see an example of both the fields −Math.EIt is the natural logarithmic base specified by the constant e.SyntaxThe syntax is as follows −public const double E = 2.71828182845905;ExampleLet us now see an example −using System; public class Demo{ public static void Main(){ double d = Math.E; Console.WriteLine("Math.E = " + d); } }OutputThis will produce the following output −Math.E = 2.71828182845905Math.PIThe Math.PI field represents the ratio ... Read More
The Uri.GetHashCode() method in C# gets the hash code for the URI.SyntaxFollowing is the syntax −public override int GetHashCode ();ExampleLet us now see an example to implement the Uri.GetHashCode() method −using System; public class Demo { public static void Main(){ string URI1 = "https://www.tutorialspoint.com/index.htm"; Console.WriteLine("URI = "+URI1); string URI2 = "https://www.tutorialspoint.com/"; Console.WriteLine("URI = "+URI2); Console.WriteLine("Escaped string (URI1) = "+Uri.EscapeDataString(URI1)); Console.WriteLine("Escaped string (URI2) = "+Uri.EscapeDataString(URI2)); Console.WriteLine("GetHashCode() for URI1 = "+URI1.GetHashCode()); Console.WriteLine("GetHashCode() for URI2 = "+URI2.GetHashCode()); ... Read More
The Uri.FromHex() method in C# is used to get the decimal value of a hexadecimal digit.SyntaxFollowing is the syntax −public static int FromHex (char digit);Above, the parameter digit is the hexadecimal digit (0-9, a-f, A-F) to convert.ExampleLet us now see an example to implement the Uri.FromHex() method −using System; public class Demo { public static void Main(){ char ch = 'D'; Console.WriteLine("Character value = "+ch); int res = Uri.FromHex(ch); Console.WriteLine("Converted int value = "+res); } }OutputThis will produce the following output −Character value = D Result ... Read More
The Uri.EscapeDataString() method in C# converts a string to its escaped representation.SyntaxFollowing is the syntax −public static string EscapeDataString (string str);Above, the string str is the string to escape.ExampleLet us now see an example to implement the Uri.EscapeDataString() method −using System; public class Demo { public static void Main(){ string URI1 = "https://www.tutorialspoint.com/index.htm"; Console.WriteLine("URI = "+URI1); string URI2 = "https://www.tutorialspoint.com/"; Console.WriteLine("URI = "+URI2); Console.WriteLine("Escaped string (URI1) = "+Uri.EscapeDataString(URI1)); Console.WriteLine("Escaped string (URI2) = "+Uri.EscapeDataString(URI2)); } }OutputThis will produce the following output ... Read More
The UInt32.ToString() method in C# is used to convert the numeric value of the current UInt32 instance to its equivalent string representation.SyntaxFollowing is the syntax −public override string ToString();ExampleLet us now see an example to implement the UInt32.ToString() method −using System; public class Demo { public static void Main(){ uint val1 = 100; uint val2 = 80; Console.WriteLine("Value1 (String representation) = "+val1.ToString()); Console.WriteLine("Value2 (String representation) = "+val2.ToString()); bool res = val1.Equals(val2); Console.WriteLine("Return value (comparison) = "+res); if (res) ... Read More