MySQL Insert into

MySQL INSERT INTO statement is used to insert records in an existing table.

Syntax:

INSERT INTO table_name ([column_name],[...column_name],...)
VALUES( [column_value],[..column_value]);

Parameter :
table_name            Name of the table
column_name        Name of the column
column_value        Values are ready to be inserted for a column

Reff. :  Insert into statement in mysql.

MySQL Timestamp

MySQL converts timestamp values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. This function returns the date and time value against a date expression.

Visit for Reff. : mysql timestamp

CONCAT MYSQL

The MySQL concat function is used to concatenate two or more strings. This is a string function. It is very much useful to manipulate with strings.

Reff. : See also

MySql curdate

In MySQL the CURDATE() is used to return the current date in 'YYYY-MM-DD' format or 'YYYYMMDD' format depending on whether numeric or string is used in the function. CURRENT_DATE and CURRENT_DATE() are the synonym of CURDATE().
Note: The outputs depending upon the current date.

 

Syntax

CURDATE ()

 

Example

SELECT CURDATE();

 

Output

See also

Mysql curdate function

MySQL date

MySQL DATE() takes the date part out from a datetime expression.

This is an important function of date and time function in Mysql.

Syntax

DATE(expr);

Where expr is a datetime.

 

Example

SELECT DATE('2008-05-17 11:31:31') as required_date;

 

Explanation

The statement describe above will filter the date portion from the mentioned datetime 2008-05-17 11:31:31.

 

Output

Current Mission of NASA - Advanced Composition Explorer (ACE) Mission Overview

Mission Summary

The Advanced Composition Explorer (ACE) is an Explorer mission that was managed by the Office of Space Science Mission and Payload Development Division of the National Aeronautics and Space Administration (NASA). More on the ACE personnel, including scientific Co-Investigators can be found here.
ACE launched on a McDonnell-Douglas Delta II 7920 launch vehicle on August 25, 1997 from the Kennedy Space Center in Florida  .......

Science Goals

The prime objective of ACE is to measure and compare the composition of several samples of matter, including the solar corona, the solar wind, and other interplanetary particle populations, the local interstellar medium (ISM), and galactic matter. While there has been great progress addressing these objectives, the changing conditions over the solar cycle present new opportunities. ...

MySQL substring

MySQL SUBSTRING() returns a specified number of characters from a particular position of a given string.

Syntax

SUBSTRING(str, pos, len)

 

Example

SELECT SUBSTRING('w3resource',4,3);

Explanation

The above MySQL statement returns 3 numbers of characters from the 4th position of the string ‘w3resource’.

Output