Note14-mySQL - MYSQL MySQLisnamedaftercofounderMonty...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
1   MYSQL MySQL is named after co-founder Monty  Widenius's daughter, My.  developed, distributed, and supported by  MySQL AB company First version 3.11.0. was launched in 1996   The MySQL Web site ( http://www.mysql.com/ ) provides the latest information about MySQL  software and MySQL AB. 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 MySQL Features Open source software (Source code can be modified) Supports SQL database language A comprehensive database language: data definition,  query, update. Both DDL and DML Define views Specify security and authorization Specify integrity constraints PHP host language can be used with MYSQL to access  the database
Background image of page 2
3 Create Database Create a database with the name  Company Mysql> Create database Company Change database Mysql> use Company  
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 CREATE TABLE Specifies a new base relation by giving it a  name, and specifying each of its attributes  and their data types  A constraint NOT NULL may be specified on  an attribute Storage Engine might be specified. CREATE TABLE   DEPARTMENT ( DNAME VARCHAR(10) NOT NULL, DNUMBER INTEGER NOT NULL, MGRSSN CHAR(9), MGRSTARTDATE CHAR(9)   ...) engine=InnoDB ;
Background image of page 4
5 Storage Engine Indicates Storage engine of a table. How data is stored How data can be accessed How transactions are processed Speed of with which SQL statements are  processed “Show ENGINES” statement will give a list of  available engines.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6 Engines of MySQL 5.0.18 --------+ | Engine         | Support        |                            Comment                                                        | +------------+---------+--------------------------------------------------------------- MyISAM         DEFAULT      Default engine as of MySQL 3.23 with great performance         | MEMORY          YES             Hash based, stored in memory, useful for temporary tables        InnoDB            YES              Supports transactions, row-level locking, and foreign keys       | BerkeleyDB       NO               Supports transactions and page-level locking                    | BLACKHOLE      NO             /dev/null storage engine (anything you write to it disappears)  | EXAMPLE          NO               Example storage engine                                          ARCHIVE          YES               Archive storage engine                                           | CSV                  NO                 CSV storage engine                                             
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/26/2009 for the course CSC CSC 134 taught by Professor Jinyin during the Spring '09 term at CSU Sacramento.

Page1 / 28

Note14-mySQL - MYSQL MySQLisnamedaftercofounderMonty...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online