: CAST : Cast Functions Operators MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
Cast Functions Operators
»
CAST
»
290.1 .
SELECT CAST(1 AS UNSIGNED) - 2.0;
Hits: 1205
290.2 .
CAST() also changes the result if you use it as part of a more complex expression such as CONCAT('Date
Hits: 1100
290.3 .
CAST() is useful for sorting ENUM columns in lexical order.
Hits: 1214
290.4 .
The cast functions are useful when you want to create a column with a specific type in a CREATE ... SELECT statement
Hits: 1122
290.5 .
Convert blob column to char type
Hits: 1347
290.6 .
Converting the string 'abc' in the default character set to the corresponding string in the utf8 character set
Hits: 1107
290.7 .
CAST(expr AS type), CONVERT(expr,type), CONVERT(expr USING transcoding_name)
Hits: 1275
MySQL TUTORIALS
Cast Functions Operators
»
CAST
Introduction
CAST
BINARY
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View
SELECT CAST(1 AS UNSIGNED) - 2.0;
