I guess that translates (for those users not using the C API) to mean whatever database was last "USE"ed ? So if I say "USE Mydatabase", is "Mydatabase" now the default database or does the concept of default database only apply to those users using the C API?
Shawn Green Database Administrator Unimin Corporation - Spruce Pine Gleb Paharenko <[EMAIL PROTECTED]> wrote on 12/17/2004 07:59:30 AM: > Hello. > > > > > I searched a while but could not find an explanation. > > > So the question remains: > > > what is the "default database"? > > See: > > http://dev.mysql.com/doc/mysql/en/mysql_select_db.html > > > > > > > > "Dr. Frank Ullrich" <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > > > I came across this term several times while reading about character set > > > and collation handling, e.g. in the last paragraph of the online manual > > > section 10.3.2 (http://dev.mysql.com/doc/mysql/en/Charset-database.html): > > > " > > > The character set and collation for the default database are available > > > as the values of the character_set_database and collation_database > > > system variables. The server sets these variables whenever the default > > > database changes. If there is no default database, the variables have > > > the same value as the corresponding server-level variables, > > > character_set_server and collation_server. > > > " > > > > > > Also in the changes of version 4.1.8 in the "Functionality added or > > > changed:" section the first entry reads: > > > " > > > * For ALTER DATABASE, the database name now can be omitted to apply > > > the change to the default database. > > > " > > > > > > I searched a while but could not find an explanation. > > > > > > So the question remains: > > > what is the "default database"? > > > > > > Regards, > > > Frank. > > > > > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >