"MySQL is a free, efficient, widely used database system that implements SQL. It is available for all popular computing platforms." For example, windows, Linux, etc.
You first have to have a database created for you on hercules:
.....Wait 15 minutes before trying to access your database
Note: must log in hercules, if not change to hercules with following command
For more on MySQL, go to dev.mysql.com.
"SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter." -- from WWW.SQLCOURSES.COM
SQL can be divided into two parts: The Data Manipulation Language (DML) and the Data Definition Language (DDL). DML commands in SQL can be used for querying and updating data. DDL commands create or delete a table in database.
|SELECT - extracts data from a database||CREATE DATABASE - creates a new database|
|UPDATE - updates data in a database||ALTER DATABASE - modifies a database|
|DELETE - deletes data from a database||CREATE TABLE - creates a new table|
|INSERT INTO - inserts new data into a database||ALTER TABLE - modifies a table|
|DROP TABLE - deletes a table|
|CREATE INDEX - creates an index (search key)|
|DROP INDEX - deletes an index|
CREATE TABLE Person ( FirstName varchar(15), LastName varchar(15), ID int );
INSERT INTO Person (FirstName, LastName, ID) VALUES ('Peter', 'Griffin', '568975871');
The following is by no means complete. It is meant to get you started with SQL queries.