Monday, 20 February 2012

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