BOOLEAN: Getting Column Type
/** * Returns the SQL keyword for BOOLEAN data types in CREATE TABLE * statements * * @return string the query fragment your DBMS needs */ function getBooleanType() { return $this->BooleanType; }
require 'connect.inc';
$query = 'CREATE TABLE xyz (b ' . $p->getBooleanType() . ')';
echo $query;
$db->query($query);
$db->query('DROP TABLE xyz ' . $p->getDropRestrict());
CREATE TABLE xyz (b TINYINT ) |
CREATE TABLE xyz (b BOOLEAN ) |