Home  >  Article  >  Database  >  What is the default type of bit values ​​assigned to user variables?

What is the default type of bit values ​​assigned to user variables?

王林
王林forward
2023-09-05 13:09:17880browse

What is the default type of bit values ​​assigned to user variables?

#By default, the bit values ​​assigned to user variables are binary strings. This can be illustrated by assigning bit values ​​to user variables and then retrieving them as follows -

mysql> SET @abc = 0b1000011;
Query OK, 0 rows affected (0.00 sec)

mysql> Select @abc;
+------+
| @abc |
+------+
| C    |
+------+
1 row in set (0.00 sec)

The above result set shows that the default type of bit values ​​assigned to user variables is binary string.

The above is the detailed content of What is the default type of bit values ​​assigned to user variables?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete