What is MySQL?

1
Content of Presentation
MySQL

• What is MySQL?
• History
• Facts
• SQL Databases
• Alternatives
• Benefits
• Drawbacks
• Setting Up Database Driven Websites
• How It Works
• PHP and MySQL
• Specific SQL Tools
• A Database Driven SBU Course Guidance Website
  EXAMPLE OF PROJECT
• Flowchart
• Useful Sites

2
What is MySQL?
MySQL

• MSQL / MySQL DatabasesThe world's most widely
  used open source database application. MySQL is a
  relational database management system. World
  Class SQL Server
• PHPA server-side, cross-platform, HTML embedded
  scripting language.
• Why MySQL and not another database system that
  supports
• SQL?
• MySQL is
• Available at little cost .. or Free
• Well-supported and
• Fast

3
History
MySQL

• In 1996 T.c.X. DataKonsultAB , a consulting firm
  in Sweden developed MySQL.
• Created Alternative database from the general
  idea of mSQL.

4
Facts
MySQL

• MySQL is the largest growing relational database
  out on the market.
• MySQL mainly runs on UNIX-based environments
• MySQL acts as a DBMS
• MySQL is one of the most used open source
  databases in the world.
• Can use Enhanced MySQL
• Capacity to handle 50,000,000 records.
• Very fast command execution, perhaps the fastest
  to be found on the market.
• Easy and efficient user privilege system.

5
MySQL
SQL Databases
6
MySQL
Alternatives
Server Side Administration Java MySQL
PHP Perl PostgreSQL Python Roxen
Wireless XML Zope
Client Side DHTML Flash Graphics
JavaScript Style Sheets WML
7
MySQL and PostGreSQL Compared
MySQL

• MySQL Ease of use / long-term stability
• PostGre - Funtionality
• Postgres has an arcane limit of 8k of data per
  row
• Postgres - its "serial" data type (the equivalent
  of MySQL's auto_increment) creates a "sequence"
  which does not get dropped when its parent table
  is dropped.
• MySQL is "smart" enough to increment its
  auto_increment value when you import data
• MySQL has no built in method for doing db size
  limits

8
Benefits (1)
MySQL

• Able to handle large databases that can be
  accessed over the Web.
• Flexible and secure password system to protect
  your data - powerful security system
• Fast, reliable, easy to use, and affordable!
• Relational database management system
• Stability
• On-line help facility - (type help or -?,)
• MySQL meets the ANSI SQL92 regulations

9
Benefits (2)
MySQL

• MySQL allows users to connect to a specific
  database on the server and issue requests.
• Concurrent access
• This system can run on virtually on any platform
  UNIX and Windows
• MySQL also comes with a source code
• MySQL is used at the enterprise level because of
  its security.

10
Drawbacks
MySQL

• The hard part about this is there is not a lot of
  documentation available
• MySQL has no built in method for doing db size
  limits
• MySQL requires that you either
• code the data integrity into your product or
• you right some scripts to go through the logs
  and check that integrity was maintained

11
Setting Up Database Driven Websites
MySQL

• Setup the MySQL database server
• Setup the Apache web server
• Setup the PHP 3.0 Hypertext Preprocessor for
  server-side-scripting
• Create a simple web enabled database

12
How It Works MySQL is based on a client/server
model
MySQL
BLACK BOX
CLIENT PROGRAM
13
PHP and MySQL
MySQL

• the best tools available for the rapid
  development of database driven web applications,
• "Open Source" and available at no cost,
• happen to be particularly easy to learn and use,
  and yet are quite robust and scalable,
• are excellent choices for anyone seeking a
  powerful, affordable, easy and efficient web
  development environment.

14
Specific SQL Tools
MySQL

• DBTools Manager
• DBUI
• exportSQL
• ForwardSQL
• Intelligent Converters Software
• KMySQLAdmin
• Mac SQL
• MyAccess
• MySQL Data Manager
• MySQL WebClient
• MySQL Admin

15
A Database Driven SBU Course Guidance Website
MySQL

• Help potential students choose their ideal
  course,
• Provide an on-line interactive service,
• Shorten the decision-making process,
• Save valuable time,
• Provide vast amounts of course information and
  guidance,
• Send out and view on-line prospectuses

16
Database Driven COURSE GUIDANCE Website for SBU
MySQL
Original Database Implemented in Access SRS
Student Record System
Converted on UNIX Platform/Server
Implemented by South Bank University
Updated version of database Converted to MySQL
Data Manipulation and extraction Of Course
details

• Choice of 3 tools
• CGI script,
• Perl,
• PHP

Using PHP
Using HTML. JavaScript and PHP
Design of Front End
17
Useful Sites
MySQL

• http//www.mysql.com/
• THE OFFICIAL MYSQL WEBSITE
• http//www.mysql.com/documentation/
• CODING/HELP DOCUMENTATION
• http//www.mysql.com/information/presentations/pre
  sentation-ede2000-20001010/
• SYNTAX EXPLAINED
• http//hotwired.lycos.com/webmonkey/programming/ph
  p/tutorials/tutorial4.html
• PHP AND MYSQL TUTORIAL
• http//www.devshed.com/Server_Side/MySQL
• THE DEVELOPER SHED (MYSQL INFO.)
• http//www.faqts.com/knowledge_base/index.phtml/fi
  d/94
• MYSQL QUERIES AND COMMON PROBLEMS