Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
You may get tis value, if you are missing the value for auto_increment column. The error is as follows −mysql> insert into DemoTable1353 values('Chris', 23); ERROR 1136 (21S01): Column count doesn't match value count at row 1You need to provide the value for auto_increment or leave it to automatic generation.Let us see an example and create a table −mysql> create table DemoTable1353 -> ( -> Id int NOT NULL AUTO_INCREMENT, -> Name varchar(20), -> Age int, -> PRIMARY KEY(Id) -> ); Query OK, 0 rows affected (0.52 sec)Insert ... Read More
The :focus selector in jQuery is used to select the element which currently has focus.SyntaxThe syntax is as follows −$(":focus")ExampleLet us now see an example to implement the :focus() selector − .one { color: brown; background-color: orange; font-size: 16px; border: 2px blue solid; } $(document).ready(function(){ $("input").focus(); $(":focus").addClass("one"); }); Fill the form ID: Rank: Fav. Subjects: Maths: English OutputThis will produce the following output −
The :first-of-type selector in jQuery is used to select elements, which are the first element of their parent.SyntaxThe syntax is as follows −$(":first-of-type")ExampleLet us now see an example to implement the :first-of-type() selector − .demo { background-color: red; color: white; font-size: 16px; border: 2px blue dashed; } $(document).ready(function(){ $("p:first-of-type").addClass("demo"); }); This is the first line! This is the second line! This is the third line! One Two Three Four A B This is the last line. OutputThis will produce the following output −
The :first-child selector in jQuery is used to select all elements, which are the first child of their parent.SyntaxThe syntax is as follows −$(":first-child")ExampleLet us now see an example to implement the :first-child() selector − .demo { background-color: red; color: white; font-size: 16px; border: 2px blue dashed; } $(document).ready(function(){ $("p:first-child").addClass("demo"); }); This is the first line! This is the second line! This is the third line! One Two Three Four This is the last line. OutputThis will produce the following output −
The Type.GetFields() method in C# is used to get the fields of the current Type.SyntaxFollowing is the syntax −public System.Reflection.FieldInfo[] GetFields ();ExampleLet us now see an example to implement the Type.GetFields() method −using System; using System.Reflection; public class Demo { public static void Main(){ Type type = typeof(System.String); FieldInfo [] fields = type.GetFields(BindingFlags.Static | BindingFlags.NonPublic); Console.WriteLine ("Following are the non-public fields="); foreach (FieldInfo myField in fields){ Console.WriteLine(myField.ToString()); } } }OutputThis will produce the following output −Following are the non-public ... Read More
The Type.GetTypeHandle() method in C# is used to get the handle for the Type of a specified object.SyntaxFollowing is the syntax −public static RuntimeTypeHandle GetTypeHandle (object ob);Above, ob is the object for which to get the type handle.Exampleusing System; public class Demo { public static void Main(){ Type type1 = typeof(System.Type); RuntimeTypeHandle typeHandle = Type.GetTypeHandle(type1); Type type = Type.GetTypeFromHandle(typeHandle); Console.WriteLine("Attributes = " + type.Attributes); Console.WriteLine("Type Referenced = "+ type); } }OutputThis will produce the following output −Attributes = AutoLayout, AnsiClass, Class, Serializable, BeforeFieldInit ... Read More
The Type.GetTypeFromHandle() method in C# is used to get the type referenced by the specified type handle.SyntaxFollowing is the syntax −public static Type GetTypeFromHandle (RuntimeTypeHandle handle);Above, the handle parameter is the object that refers to the type.ExampleLet us now see an example to implement the Type.GetTypeFromHandle() method −using System; public class Demo { public static void Main(){ Type type1 = typeof(short); RuntimeTypeHandle typeHandle = Type.GetTypeHandle(type1); Type type = Type.GetTypeFromHandle(typeHandle); Console.WriteLine("Attributes = " + type.Attributes); } }OutputThis will produce the following output −Attributes = AutoLayout, AnsiClass, Class, ... Read More
The Decimal.Floor() method in C# rounds a specified Decimal number to the closest integer toward negative infinity.SyntaxFollowing is the syntax −public static decimal Floor (decimal val);Above, Val is the value to round.ExampleLet us now see an example to implement the Decimal.Floor() method −using System; public class Demo { public static void Main(){ Decimal val1 = 25.25m; Decimal val2 = 11.85m; Console.WriteLine("Decimal 1 = "+val1); Console.WriteLine("Decimal 2 = "+val2); Console.WriteLine("Floor (val1) = "+Decimal.Floor(val1)); Console.WriteLine("Floor (val2) = "+Decimal.Floor(val2)); } }OutputThis will produce ... Read More
The Decimal.Divide() method in C# is used to divide two specified Decimal values.SyntaxFollowing is the syntax −public static decimal Divide (decimal val1, decimal val2);Above, val1 is the dividend, whereas val2 is the divisor.ExampleLet us now see an example to implement the Decimal.Divide() method −using System; public class Demo { public static void Main(){ Decimal val1 = 65.15m; Decimal val2 = 5.15m; Console.WriteLine("Decimal 1 = "+val1); Console.WriteLine("Decimal 2 = "+val2); Console.WriteLine("After Division = "+(Decimal.Divide(val1, val2))); } }OutputThis will produce the following output −Decimal 1 ... Read More
The Decimal.CompareTo() method in C# is used to compare this instance to a specified object or Decimal and returns an indication of their relative values.SyntaxFollowing is the syntax −public int CompareTo (decimal value); public int CompareTo (object value);ExampleLet us now see an example to implement the Decimal.CompareTo() method −using System; public class Demo { public static void Main(){ Decimal val1 = 65.15m; Decimal val2 = 65.15m; Console.WriteLine("Decimal 1 = "+val1); Console.WriteLine("Decimal 2 = "+val2); Console.WriteLine("Comparison Value = "+(val1.CompareTo(val2))); } }OutputThis will produce the ... Read More