Add Days to Date in MySQL Table

Alankritha Ammu
Updated on 22-Jun-2020 04:57:37

216 Views

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

Check Table Status of Tables in MySQL Database

varma
Updated on 22-Jun-2020 04:56:12

444 Views

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

Set Textarea Content Using jQuery

Arnab Chakraborty
Updated on 21-Jun-2020 17:10:30

3K+ Views

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 ::

Get Textarea Content Using jQuery

Arnab Chakraborty
Updated on 21-Jun-2020 17:08:12

697 Views

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

Count Number of Rows in a Table with jQuery

Arnab Chakraborty
Updated on 21-Jun-2020 17:04:04

1K+ Views

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 Management

Alex Onsman
Updated on 21-Jun-2020 16:59:02

4K+ Views

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

Difference Between String and string in C#

Samual Sam
Updated on 21-Jun-2020 16:56:33

575 Views

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

Difference Between Literal and Constant in C#

Chandu yadav
Updated on 21-Jun-2020 16:55:46

603 Views

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

Difference Between String Copy and String Clone Methods in C#

George John
Updated on 21-Jun-2020 16:55:18

548 Views

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

Difference Between an Interface and a Class in C#

karthikeya Boyini
Updated on 21-Jun-2020 16:54:30

1K+ Views

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

Advertisements