MySQL Database learning



Home / Database Structure / Data Types / What is BIT Data Type in MySQL?
Share this job:


What is BIT Data Type in MySQL?


In MySQL 5 Certification Study Guide, the BIT data type is described as below:

The BIT data type represents bit-field values. BIT column specifications take a width indicating the number of bits per value, from 1 to 64 bits. The following columns store 4 and 20 bits per value, respectively:
bit_col1 BIT(4)
bit_col2 BIT(20)
For a BIT(n) column, the range of values is 0 to 2 n 1, and the storage requirement is approximately INT((n+7)/8) bytes per value.
BIT columns can be assigned values using numeric expressions. To write literal bit values in binary format, the literal-value notation b'val' can be used, where val indicates a value consisting of the binary digits 0 and 1. For example, b'1111' equals 15 and b'1000000' equals 64.



Data Types related other questions

What is BIT Data Type in MySQL?

In MySQL 5 Certification Study Guide, the BIT data type is described as below:The BIT data type represents bit-field values. BIT column specifications take a width indicating the number of bits per value ...

What are numeric data types in MySQL?

In MySQL 5 Certification Study Guide, Numeric data types are described as below: For storing numeric data, MySQL provides integer data types, floating-point types that ...

What is MySQL default character set?

MySQL\'s default Character Set is latin1 that is also known as ISO-8859-1. The latin1 Character Set uses one byte per character.  To get the current database character set, you may run the following query i ...

What are integer data types in MySQL?

In MySQL 5 Certification Study Guide, integer data types are described as below:For storing numeric data, MySQL provides integer data types. ...

What are float data types in MySQL?

In MySQL 5 Certification Study Guide, Numeric data types are described as below:The floating-point data types include FLOAT and   DOUBLE. Each of these types may be used to ...

What is fixed point and decimal data type in MySQL?

In MySQL 5 Certification Study Guide, Numeric data types are described as below:The fixed-point data type is DECIMAL. It is used to  represent exact-value numbers that have an integer part, a fra ...

What is difference between binary and non-binary string data types?

Some text from \"MySQL 5 Certification Study Guide\" about binary and non-binary string data types is as below: Three data types store non-binary strings: CHAR, VARCHAR, and ...

What are ENUM and SET Data Types in MySQL?

In MySQL 5 Certification Study Guide, the ENUM and SET Data Types are well described as below: The ENUM and SET string data types are used when the values to be stor ...

What is difference between CHAR AND VARCHAR data types?

The CHAR and VARCHAR data types store non-binary strings (that is, strings of characters that have a character set and collation). These types differ in terms of their maximum allowable length and in how tr ...

What are string data types in MySQL 5?

The string data types include binary and non-binary string data.The CHAR, VARCHAR, and TEXT data types store non-binary strings (that is, strings of characters that have a character set and collation). ...

How to reformat date values in MySQL?

You can reformat date values into other display formats using the MySQL DATE_FORMAT() function.  Take Example:SELECT DATE_FORMAT(\'1997-10-04 22:23:00\', \'%W %M %Y\'); -> \'Saturday Octo ...

How to reformat Time values in MySQL?

You can reformat time values into other display formats using the TIME_FORMAT() function in MySQL. Take examples:TIME_FORMAT(time_expression, format_string)SELECT TIME_FORMAT( CURRENT_TIME, \'%f\' ...

What are Temporal Data Types in MySQL?

MySQL provides data types for storing different kinds of temporal information. The following table summarizes the storage requirements and ranges for the date and time data types.  In the following descr ...

What are DATE, TIME, DATETIME and YEAR Data Types in MySQL?

The DATE data type represents date values in \'YYYY-MM-DD\' format. The supported range of DATE values is \'1000-01-01\' to \'9999-12-31\'. You might be able to ...

What is TIMESTAMP Data Type in MySQL?

In MySQL 5 Certification Study Guide, the TIMESTAMP data type is described in detailed. Some useful text is as below:The TIMESTAMP type, like DATETIME, stores date-and-time values, but has a different range a ...