Two functions can be used for this purpose and in both the functions we need to provide column name as an argument along with INTERVAL keyword. The functions are as follows −DATE_ADD() functionThe syntax of this function is DATE_ADD(date, INTERVAL expression unit). It can be demonstrated by following the example which uses the data from table ‘collegedetail’ −mysql> Select estb, DATE_ADD(estb, INTERVAL 10 DAY) from collegedetail; +------------+---------------------------------+ | estb | DATE_ADD(estb, INTERVAL 10 DAY) | +------------+---------------------------------+ | 2010-05-01 | 2010-05-11 | | 1995-10-25 | 1995-11-04 ... Read More
We can check the status of tables in a database with the help of show table status statement. For example, in the database named tutorial, by executing this statement we can get the status of tables as follows −mysql> show table status \G*************************** 1. row *************************** Name: student Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 7340032 Auto_increment: NULL Create_time: 2017-10-24 09:34:29 ... Read More
On clicking the tag,the content is dispaying inside the textarea.Example Live Demo $(document).ready(function () { $("a").click(function () { $("#txt1").val("I AM DISPLAYING IN THE TEXTAREA"); }); }); Quires TEXTAREA ::
Here I am using one textarea and one button.The first textarea is used for user input then click the button and display the value in the alert box.Example Live Demo $(document).ready(function () { $("button").click(function () { var dim = $("#txt").val(); alert(dim); }); }); Click Here
Example Live Demo table table,th,td { border:2px solid black; margin-left:400px; } h2 { margin-left:400px; } button { margin-left:400px; } $(document).ready(function () { $("button").click(function () { var rowcount = $('table tr').length; alert("No. Of Rows ::" +rowcount); }); }); HTML TABLE NAME AGE DD 35 SB 35 AD 5 AA 5 Click Here
Cache is a type of memory that is used to increase the speed of data access. Normally, the data required for any process resides in the main memory. However, it is transferred to the cache memory temporarily if it is used frequently enough.A diagram to better understand the data transfer in cache management is as follows −Cache PerformanceThe cache performance can be explained using the following steps −If a process needs some data, it first searches in the cache memory. If the data is available in the cache, this is termed as a cache hit and the data is accessed ... Read More
String stands for System.String whereas string is an alias in C# for System.String −For examplestring str = "Welcome!";It’s not essential, but generally String is used when you work with classes.string str = String.Format("Welcome! {0}!", user);Since the string is an alias for System. String. The alias for other datatypes are −Exampleobject: System.Object string: System.String bool: System.Boolean float: System.Single double: System.Double decimal: System.Decimal byte: System.Byte sbyte: System.SByte short: System.Int16 ushort: System.UInt16 int: System.Int32 uint: System.UInt32 long: System.Int64 ulong: System.UInt64 char: System.Char
The constants refer to fixed values that the program may not alter during its execution. These fixed values are also called literals. Constants can be of any of the basic data types like an integer constant, a floating constant, a character constant, or a string literal. There are also enumeration constants as well.An integer literal can be a decimal, or hexadecimal constant. A prefix specifies the base or radix: 0x or 0X for hexadecimal, and there is no prefix id for decimal.150 300uA floating-point literal has an integer part, a decimal point, a fractional part, and an exponent part.3.14159 235468E-7FString ... Read More
The String.Copy() method creates a new instance of String. This is same as the specified String.The following is an example of Copy() method −Example Live Demousing System; class Demo { static void Main(String[] args) { string str1 = "mark"; string str2 = "marcus"; Console.WriteLine("str1 = '{0}'", str1); Console.WriteLine("str2 = '{0}'", str2); Console.WriteLine("After using String.Copy..."); str2 = String.Copy(str1); Console.WriteLine("str1 = '{0}'", str1); Console.WriteLine("str2 = '{0}'", str2); } }Outputstr1 = 'mark' str2 = ... Read More
An interface is a class without fields or method implementation. It cannot implement the methods it defines.A class generally implements the methods defined in an interface.InterfaceInterfaces define properties, methods, and events, which are the members of the interface. Interfaces contain only the declaration of the members. It is the responsibility of the deriving class to define the members.public interface interface_name { // interface_members }ClassClass is a blueprint for a data type. This does not actually define any data, but it does define what the class name means. That is, what an object of the class consists of and what ... Read More
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP