Hello, On Sun, 2003-07-20 at 14:59, Stefan Hinz wrote: > Matthew, > > > Hi, I'm clear as to what is meant by "The mysql client" in the MySQL core > > certification revision check list. I understand that the mysql database > > itself is the "server". Would client then be any program that talks to the > > server? Perhaps it is referring to mysql, the command line tool?
Just a few small note to qualify Stefan's explanations: "The mysql client" as written in the list that you speak of in the Candidate Guide on http://www.mysql.com/certification/candguide/sec-core.html does indeed refer specifically to the client program "mysql" (or mysql.exe on Windows), so your interpretation of this is correct. > Client programs are indeed programs that talk with the server. The > server, however, is not "the database", but rather the program that > manages databases (allow/deny access to databases and their tables, > modify tables structures, change contained data, etc.). > > MySQL provides a number of client programs for various purposes, like > controlling the server, backing up databases, etc. One of those > programs is "mysql", which is a command line interface (CLI). > > The names of programs in a MySQL binary distribution can be somewhat > confusing: mysqld is the server, while mysql is the (main) CLI client. > > > I understand "client side programs", examples being: mysqladmin, mysqldump, > > and mysqlimport. These are known as "mysql client commands" also? > > Those are client (side) programs, not "client commands". You use those > programs to issue (client) commands that are sent to the server. Hmm - Stefan, you need to read that particular page more carefully :-) The line that is being discussed is this one, which appears as a subject under "The mysql client": * Differentiate between mysql client commands and SQL commands In this context, a "client command" is one such as "quit", "rehash", "connect" (They are listed on http://www.mysql.com/doc/en/mysql.html), which is processed directly by the "mysql" program. An "SQL command", on the other hand, is an e.g. SELECT or INSERT statement that is sent to the server for processing. Note that just because a command is a "client command", this does not necessarily infer that no client/server communication takes place. Best regards, Carsten H. Pedersen Certification Manager, MySQL AB -- Warning: Certification can seriously increase your wealth! http://www.mysql.com/certification Carsten Pedersen, Certification Manager MySQL AB, http://www.mysql.com Office: +45 56 36 16 10 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
