what is mysql?
DESCRIPTION
What is MySQL?. MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language). First released in January, 1998. Many Internet startups became interested in the original open source version of MySQL. What is MySQL? Continue. - PowerPoint PPT PresentationTRANSCRIPT
What is MySQL?MySQL is a relational database
management system (RDBMS) based on SQL (Structured Query Language). First released in January, 1998. Many Internet startups became interested in the original open source version of MySQL.
What is MySQL? Continue
MySQL is a database system used on the web. Basically, a MySQL database allows you to create a relational database structure on a web-server somewhere in order to store data or automate procedures.
Installing MySQL on Windows These instructions are for version 5.1
(mysql-5.1.51-win32) 1. Download the current version of
MySQL from http://www.mysql.com. 2. Double-click setup.exe to launch the
installer.
3 .At the Welcome screen of the Setup Wizard click Next.
4 .Choose the Typical option as the setup type and click Next .
5 .Click Install.
6.a. Click Next.
6.b. Click Next.
7 .The MySQL Server Database Engine is now installed. At this point the server must be configured, choose the Configure the MySQL Server now option and click Finish.
8 .At the Welcome screen of the MySQL Server Instance Configuration Wizard, click Next.
9 .Choose the Detailed Configuration option and click Next.
10 .Choose the Developer Machine option and click Next.
11 .Choose the database usage type that best describes your installation. If you are unsure, choose the Multifunctional Database option and click Next.
12 .Choose a location that will house the database tablespace and click Next. If the current machine will be used to store the Portfolio catalog, the default location will work fine.
13 .This step of the Wizard allows you to help optimize the database for the number of concurrent connections that you expect to have to a Portfolio catalog .
If you are not sure how many concurrent users you will have, choose the Online Transaction Processing (OLTP) option
But we will choose the Decision Support (DSS)/OLAP option and click Next.
14 .Choose the Enable TCP/IP Networking option , Enable Strict Mode and click Next.
15 .Choose the Best Support for Multilingualism option and click Next.
16 .To run MySQL server as a service, check the Install as a Windows Service option and choose a Service Name. It is also recommended to launch the MySQL Service automatically, check the Include Bin Directory in Windows PATH and click Next.
17 .In this step you choose enable the root user and choose a password. Check the Modify Security Settings option, then enter and confirm the new root user password. When finished, click Next.
18 .Click Execute to configure the MySQL instance.
19 .Click Finish to close the Wizard.
Launching MySQL
There are to ways to launch this program :1. Start --> Run --> cmd
2. Start --> All Program --> MySQL --> MySQL Server 5.0 --> MySQL Command Line Client
Table
“A table is the primary unit of physical storage for data in a database.”1
Usually a database contains more than one table.
Table
Field (Column)
a field
Customers
Record (Row)
a record
Customers
Primary Key
primary key field
Customers
Primary key is a unique identifier of records in a table.
Primary key values may be generated manually or automatically.
Primary Key
primary key fields
Roles (Performances)
A primary key can consist of more than one field.
Foreign Key
foreign key field
primary key fieldparent table
Directors
Movieschild tablerelationship
Conceptual Data Models
Use concepts such as entities, attributes, and relationships
An entity represents a real world object or concept.
An attribute represents some property of an entity.
A relationship among two or more entities represents an interaction among the entities.
Relationship Types
One-to-one
One-to-many
Many-to-many
One-to-Many A film is directed by at most one director A director can direct any number of films
Directorid
name
Directed Film title
Director Directed Film
Many-to-Many A film is directed by any number of directors A director can direct any number of films
Directorid
name
Directed Film title
Director Directed Film
One-to-One A film is directed by at most one director A director can direct at most one film
Directorid
name
Directed Film title
Director Directed Film
Download mysql-workbench from http://www.mysql.com.
(mysql-workbench-gpl-5.2.28-win32_5)
Select (open connection to start querying)
Press OK, then enter your password
show databases;
create database New_database;
show databases;
use new_database;
How to create tables
Use create
create table <table_name> (column_name data_type [not null] … , column_name data_type [not null], primary key (column_name));
To show the structure of the table
describe <table_name>;
Example
Insert RecordINSERT INTO table_name SET
col_name1=value1, col_name2=value2, col_name3=value3, …;
Example
SELECT
mysql> SELECT col_name1 FROM table_name;
mysql> SELECT * FROM table_name;