UPDATE statement moves each bit to the left one position: : Bit « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. Bit

UPDATE statement moves each bit to the left one position:

     
mysql>
mysql> CREATE TABLE Attributes
    -> (
    ->     UserID SMALLINT NOT NULL PRIMARY KEY,
    ->     Settings TINYINT UNSIGNED NOT NULL
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO Attributes VALUES
    -> (101, 58),
    -> (102, 73),
    -> (103, 45);
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql>
mysql> select * from Attributes;
+--------+----------+
| UserID | Settings |
+--------+----------+
|    101 |       58 |
|    102 |       73 |
|    103 |       45 |
+--------+----------+
3 rows in set (0.00 sec)

mysql>
mysql> UPDATE Attributes
    -> SET Settings=Settings << 1;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql>
mysql>
mysql> select * from Attributes;
+--------+----------+
| UserID | Settings |
+--------+----------+
|    101 |      116 |
|    102 |      146 |
|    103 |       90 |
+--------+----------+
3 rows in set (0.00 sec)

mysql>
mysql> drop table Attributes;
Query OK, 0 rows affected (0.00 sec)

mysql>








Related examples in the same category

1.left shift operator
2.The >> is the right shift operator
3.Bitwise operators
4.Bit Operators
5.Bit operation
6.Bit or
7.Left shift
8.Left shift 3
9.The result of a bitwise AND between 7 and 9 is 1
10.Shifting beyond 64 bits, or with a negative number, just returns 0.
11.Move the binary value 11 three bits to the left.
12.Apply several binary operators to the columns of the MATCHES table.