Hello.
Oops, yes, perhaps I was thinking about some[body] else while answering %-) Sure, the last USEd database is the default one and that's a simplier way to understand the concept of a default database. Thank you. And it's friday! :-) [EMAIL PROTECTED] wrote: > > 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]
