When connecting with the user named test 1 to the database named test1, it is authenticated without a password.
When acquiring a backup, the database can be kept running.
By default, there are two template databases in the database cluster.
Up to 5 template databases can be created in the database cluster.
There is a flag to set whether the database is a template database, and you can not delete (DROP DATABASE) the database where the flag is set.
describe alter table
help alter table
When log_connections is set to on, connection attempts from the client to server are recorded in the log.
When log_statement is set to on, SQL statements are recorded to the log.
When log_line_prefix is set to on, various additional information, such as log information output time, username, and process ID are included in the log file.
© EDUCO (General Incorporated Association Educo) all rights reserved.