The Man
Reputation: 435
Difference between BOOL and BOOLEAN types in MySQL?
What is the difference between BOOL and BOOLEAN data types in MySQL?
Can BIT or TINYINT represent Booleans?
Upvotes: 2
Views: 1026
Answers (1)
juergen d
Reputation: 204756
BOOL and BOOLEAN are both synonyms of TINYINT(1). So there is no difference.
Upvotes: 5
Related Questions
- How can I prevent SQL injection in PHP?
- What is the difference between utf8mb4 and utf8 charsets in MySQL?
- MySQL: @variable vs. variable. What's the difference?
- What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?
- What's the difference between utf8_general_ci and utf8_unicode_ci?
- mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc... expects parameter 1 to be resource
- Duplicating a MySQL table, indices, and data
- Which MySQL data type to use for storing boolean values
- TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
- MySql: Tinyint (2) vs tinyint(1) - what is the difference?