December 2002
Beginner
640 pages
16h 41m
English
Before studying the ways of handling databases and tables, it's worthwhile to learn how to use the mysql client program. You will see some examples of it being used, but if you don't fully understand the SQL used in the examples, don't worry; we will go through the queries themselves later today.
mysql allows you to run SQL queries on a MySQL database. It can be invoked as an interactive monitor or console with a command-line interface, or in batch mode, allowing you to pass it an entire file of SQL.
You can use the following general formats to invoke it, in console mode:
mysql [options] [database_name]
or in batch mode:
mysql [options] [database_name] < filename
You can usually put the options and database_name ...