What data type is recommended for a Yes/No field in a MySQL table when using PHP?

When storing a Yes/No field in a MySQL table, it is recommended to use the TINYINT data type with a length of 1. This allows you to store boolean values (0 for No, 1 for Yes) efficiently in the database. In PHP, you can use boolean values true and false to represent Yes and No respectively, and convert them to 0 and 1 when inserting or updating records in the database. 

// Assuming $yesOrNo is a boolean variable representing Yes or No
$yesOrNoValue = $yesOrNo ? 1 : 0;

// Inserting or updating record in MySQL table
$query = "INSERT INTO your_table (yes_no_field) VALUES ($yesOrNoValue)";
// Execute query using MySQLi or PDO

Keywords

MySQL data type PHP boolean field

Related Questions