Home > Database > Mysql Tutorial > How Can I Convert an Integer to a Bit Data Type in MySQL 5.1?

How Can I Convert an Integer to a Bit Data Type in MySQL 5.1?

Linda Hamilton
Release: 2024-11-01 07:53:30
Original
902 people have browsed it

How Can I Convert an Integer to a Bit Data Type in MySQL 5.1?

MySQL: Casting Integer to Bit in 5.1

Converting an integer to a bit data type can be challenging in MySQL 5.1. While the CAST or CONVERT functions are commonly used for type conversions, they do not support casting integers to bits.

Method:

Since native casting is not possible, a custom function can be created to perform this conversion.

<code class="sql">DELIMITER $$

CREATE FUNCTION cast_to_bit (N INT) RETURNS bit(1)
BEGIN
    RETURN N;
END
$$</code>
Copy after login

This function returns the integer value as a bit(1) type.

Usage:

To use the function, create a view with various conversions:

<code class="sql">CREATE VIEW view_bit AS
    SELECT
        cast_to_bit(0),
        cast_to_bit(1),
        cast_to_bit(FALSE),
        cast_to_bit(TRUE),
        cast_to_bit(b'0'),
        cast_to_bit(b'1'),
        cast_to_bit(2=3),
        cast_to_bit(2=2)</code>
Copy after login

Now, all columns in the view will be of type bit(1).

The above is the detailed content of How Can I Convert an Integer to a Bit Data Type in MySQL 5.1?. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template