Code-Samples/php/Php-default.php Using DEFAULT statement in MySQL Table connect_error) { die("Connection not established: " . $connection->connect_error); } $query = "Use Hospital"; $connection->query($query); // Using Default Statement in MySQL $query = "CREATE TABLE Department ( dep_id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, dep_name VARCHAR(50) NOT NULL, dep_capacity INT(10) DEFAULT 100 );"; if ($connection->query($query) === TRUE) { echo "Successful table creation"; } else { echo "Unable to create table" . $connection->error; } $connection->close(); ?>