MySQL CONVERT() function

Posted Thu, 06/25/2009 - 16:14 by kailoon

MySQL CONVERT() function used to convert value of one type to another type.

The Syntax:
CONVERT(expr,type)

Explain: expr is the expression that passed in, which will be converted, and type is simply one of the types listed below:
-BINARY
-CHAR
-DATE
-DATETIME
-DECIMAL
-SIGNED
-TIME
-UNSIGNED

Example:
CONVERT('1000',DECIMAL)
Explain: Above will convert '1000' (Let's say 1000 is a string) to decimal type

Ref: MySQL CONVERT() function

‹ MySQL IF() statement Showing 5 records and next 5 records ›

Queries

by bracken - 11/16/2009 - 17:41

The most common operation in SQL is wedding invitations the query, which is performed with the declarative SELECT statement. SELECT retrieves data from one or more tables, or expressions. Standard SELECT statements have no wedding dresses persistent effects on the database. Some non-standard implementations of SELECT can have persistent effects, such as the SELECT INTO syntax that exists in some databases.

Queries allow the user to wedding rings describe desired data, leaving the database management system (DBMS) responsible for planning, optimizing, and performing the physical operations necessary to produce that result as it chooses.