Scribd
Upload
100 views12 pages

MySQL Overview and Operations Guide

MySQL is an open-source database management system that can handle large databases very quickly. It was created by David Axmark, Allan Larsson, and Michael "Monty" Widenius. MySQL interacts with many operating systems and has both free and commercial licensing options. It provides tools for creating tables, inserting data, retrieving records, and performing other basic operations.

Uploaded by

Vinay Kanasu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
100 views12 pages

MySQL Overview and Operations Guide

MySQL is an open-source database management system that can handle large databases very quickly. It was created by David Axmark, Allan Larsson, and Michael "Monty" Widenius. MySQL interacts with many operating systems and has both free and commercial licensing options. It provides tools for creating tables, inserting data, retrieving records, and performing other basic operations.

Uploaded by

Vinay Kanasu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd

SRIDEVI E

III BCA
History MySQL

• Founded and developed by David Axmark,


Allan Larsson and Micheal ‘Monty’ Widenius.
• MySQL named after Monty`s daughter, My.
• MySQL Dolphin logo is “Sakila”, the name of
a town in Arusha, Tanzania.
• Officially pronounced “my Ess Que Ell”
(not my sequel).
• Sun microsystems acquired MySQL AB in
Jan 2008 for $1 billion dollars.
Introduction

• MySQL is a very popular, open source


database.
• MySQL is a database management system.
• Handles very large databases; very fast
performance.
• SQL stands for the Structured Query
Language.
Introduction

• MySQL server can interact with many


databases
• Can run under many operating systems
FreeBSD, Linux, OS/2 Warp, UNIX, Windows
2000/XP
• MySQL has both a duel licensing GPL and
Commercial
 GPL (GNU Public License) free to use if following GPL.
 Commercial license costs money.
Connecting to MySQL

• MySQL provides an interactive shell for


creating tables, inserting data, etc.
• On Windows, just go to c:\mysql\bin, and
type:
– mysql
• Or, click on the Windows icon
Client-Server Interaction
MySQL RDB Structures
Basic MySQL Operations

• Create table
• Insert records
• Load data
• Retrieve records
• Update records
• Delete records
• Modify table
• Join table etc
Create Table Command
Insert Command
Executing the Script

Within MySQL use a command such as

Source c:/…………../marks.sql

This adds the marks table to test database.


View Created Table

You might also like