public function DatabaseSchema_mysql8b7c:f320:99b9:690f:4595:cd17:293a:c069ieldSetDefault public DatabaseSchema_mysql8b7c:f320:99b9:690f:4595:cd17:293a:c069ieldSetDefault($table, $field, $default) Set the default value for a field. Parameters  $table: The table to be altered. $field: The field to be altered. $default: Default value to be set. NULL for 'default NULL'. Throws  DatabaseSchemaObjectDoesNotExistException If the specified table or field doesn't exist. Overrides DatabaseSchem8b7c:f320:99b9:690f:4595:cd17:293a:c069fieldSetDefault File
 includes/database/mysql/schema.inc, line 370 Database schema code for MySQL database servers.  Class
 
DatabaseSchema_mysql   Code public function fieldSetDefault($table, $field, $default) {
  if (!$this->fieldExists($table, $field)) {
    throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot set default value of field @table.@field: field doesn't exist.", array('@table' => $table, '@field' => $field)));
  }

  if (!isset($default)) {
    $default = 'NULL';
  }
  else {
    $default = is_string($default) ? "'$default'" : $default;
  }

  $this->connection->query('ALTER TABLE {' . $table . '} ALTER COLUMN `' . $field . '` SET DEFAULT ' . $default);
}


    
{'path': 'public/docs/drupal~7/includes-database-mysql-schema.inc/function/databaseschema_mysql-fieldsetdefault/7.x.html', 'source': 'DevDocs.IO'}