Once you know the basics of administering your MySQL server, you can begin the important part: using MySQL to store your data. For this you will use SQL (Structured Query Language). SQL is a special language that allows programmers to issue instructions or 'queries' to databases. This article will show you how to issue basic queries to create, modify, or retrieve information in MySQL databases using the command-line MySQL client.
Note: This article assumes that you have followed the instructions for setting up MySQL on the UW servers.
You can issue SQL queries to your database using the command-line MySQL client, which you used during the installation of MySQL when you set user/host grant permissions in the "mysql" database. To invoke the client again, follow these instructions:
- cd into your mysql directory by typing the following command:
- Start the MySQL client and log in as user root by typing the following command:
./bin/mysql -u root -p
- Invoke the MySQL client as described previously in this document.
- Type the following commands:
mysql> CREATE DATABASE foo;
Query OK, 1 row affected (0.00 sec)
Note: Replace foo with the name of your desired database.
Tip: Names of databases, tables, and fields in MySQL are case sensitive. They can include the underscore character, but not spaces or hyphens.
Verify that the database has been created by typing the following command:
mysql> SHOW DATABASES;
This article covers only the most basic of SQL commands. MySQL's Tutorial Introduction provides a good starting point for using the command-line MySQL client. The following specific links may be of most use for getting started:
- Entering Queries
- Creating and Using a Database
- Getting Information about Databases and Tables
- Examples of Common Queries
Tip: The command-line MySQL client is just one of many tools that can be used to manipulate MySQL databases. Visit the following links to learn more about the alternatives: