布尔在mysql中另存为tinyint(1) [英] Boolean save as tinyint(1) in mysql

问题描述

我用一些布尔字段制作了表格.

I made table with some Boolean fields.

CREATE TABLE PM_ADMIN_LIST(
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(250) NOT NULL,
password VARCHAR(250) NOT NULL,
mail VARCHAR(250) NOT NULL,
added_time INT,
super_admin VARCHAR(250) NOT NULL,
last_time INT,
last_ip VARCHAR(250),
see_user_per BOOLEAN DEFAULT FALSE,
change_user_per BOOLEAN DEFAULT FALSE,
see_people_per BOOLEAN DEFAULT FALSE,
change_people_per BOOLEAN DEFAULT FALSE,
add_people_per BOOLEAN DEFAULT FALSE,
remove_people_per BOOLEAN DEFAULT FALSE,
see_album_per BOOLEAN DEFAULT FALSE,
add_album_per BOOLEAN DEFAULT FALSE,
change_album_per BOOLEAN DEFAULT FALSE,
remove_album_per BOOLEAN DEFAULT FALSE,
see_music_per BOOLEAN DEFAULT FALSE,
add_music_per BOOLEAN DEFAULT FALSE,
change_music_per BOOLEAN DEFAULT FALSE,
remove_music_per BOOLEAN DEFAULT FALSE,
admin_per BOOLEAN DEFAULT FALSE,
yahoo_per BOOLEAN DEFAULT FALSE,
status_per BOOLEAN DEFAULT FALSE,
pm_per BOOLEAN DEFAULT FALSE,
ip_blocking_per BOOLEAN DEFAULT FALSE
);

但是当我在phpmyadmin中检查它时，BOOLEAN字段是tinyint(1)，默认情况下它们是0.我可以将1设置为TRUE.但是，当我在PHP代码中使用===时，无法将它们转换. (我应该在if，for，while中使用==，我认为它会在我的系统中造成一些错误.)

But when I check it in phpmyadmin, BOOLEAN fields are tinyint(1) and they are 0 by default. I can make 1 to be TRUE. But when I use === in my PHP code, they can't be converted. (I should use == in if, for, while and I think it can make some bug in my system.)

那么，我该如何解决呢?我应该如何从MySQL默认获取BOOLEAN?

So, how should I solve it? How should I get it BOOLEAN by default from mysql?

推荐答案

从数据库中获取数据时，通常只得到PHP中的字符串.这些类型仅在数据库端使用.

You usually don't get anything but strings in PHP when fetching data from the database. The types are solely used on the database side.

该字段为TINYINT，因为MySQL根本不包含BOOLEAN字段.

The field is a TINYINT because MySQL doesn't contain a BOOLEAN field at all.

这篇关于布尔在mysql中另存为tinyint(1)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！