What are the differences and usage scenarios between mysql bit and tinyint?

tinyint

that has been used before for fields that represent data types or states

has not paid attention to the bit type. After consulting the data, we know that bit is stored in binary format: bounded 0" or bounded 1"
its storage unit is directly bit , while the smallest unit of tinyint is 1 byte.
however, some people say that bit does not support indexing. Source: [MySQL] stories triggered by bit types

personally, I think: because php is weakly typed, bit type query is not as convenient as tinyint ,

is said to be more suitable for java . If you have any trouble, explain why? And their differences and usage scenarios?

Mysql mysql-optimizes mysql-index

Jun.03,2021

tinyint is a numeric type that stores decimals and generally corresponds to a small dictionary or enumeration type in the editing language. While saving space, avoid saving out-of-range values.
bit is similar to storing state. For example, bit (1) directly corresponds to the Boolean types true and false. of Java language. When using for state saving, a field can save up to 64 states.
if a system I developed needs to save the state of sending text messages to users, there are more than 10 different types of text messages, each of which should be marked whether they have been sent or not. It is very convenient to use the bit type at this time. Of course, it can also be achieved with int, but using bit is more semantic. You can do it bitwise when querying or updating a status.

Previous: Websocket is under https, is it necessary to use wss protocol to connect?

Next: Solutions to the problems in the implementation of distributed scrapy-redis

After the MySQL ORDER BY primary key id plus LIMIT limit reaches a certain threshold, why not expect the index and go to the primary key index?
background and phenomena the amount of data in the report_product_sales_ data table is 28 million; it has been tested that when the, order by primary key id,limit reaches 49 under the current data volume, the PRIMARY primary key index can be used w...

Mysql mysql-optimizes mysql-index

Mar.16,2021
Mysql single table query is slow? y
< H1 > as shown in the title: < H1 > EXPLAIN execution Plan: the following is my table structure. It takes 7 seconds to query more than 10, 000 pieces of data. CREATE TABLE order_copy ( id bigint (20) NOT NULL AUTO_INCREMENT, seq_id bigint...

Mysql mysql-optimizes mysql-index

Dec.20,2021
If the number of rows in a column in the mysql data area is the same as the nodes in the index area, is it as efficient to scan the data area as the index area?
b-tree structure if the name field is an index, then if there are seven pieces of data in the table, all nodes in the b-tree also have seven pieces of data, so isn t scanning the entire data area as efficient as scanning the entire index area? ...

Mysql mysql-optimizes mysql-index

Jun.28,2022