My sql

1
My sql

• By Aryan Ghassemi

2
Content

• Intro to MySQL
• How to install MySQL?
• Transferring data
• Basic MySQL Information
• Assignment 4

3
Introduction
4
Advantages of MySQL

• Affordable (595/server/year)
• Fast
• Easy to Use
• Open Source
• Flexible
• Small Size (92 MB vs. 1 GB oracle)
• Scalable

5
Flexible

• It can run on many different operating systems
• Windows
• Linux
• Unix
• Novell
• NetWare

6
Scalable

• Allows up to 50 000 rows in each table.
• The file size limit is 4 GB as default, and it
  allows you to change the file size to 8TB

7
How to install MySQL
8
Download Address

• http//dev.mysql.com/downloads/
• 1- MySQL Community Server
• Free
• 2- MySQL Enterprise
• 595/server/year

9
Installation
10
Installation
Installation
11
Installation
12
Configuration
13
Configuration
14
Configuration
15
Configuration
16
Transferring Data
17
Copy the database to MySQL data

• Copy the folder from
• K\fulltine\mysql
• To
• C\Program Files\MySQL\MySQL Server 5.0\data

18
Transfer Data from Oracle to MySQL (step 1)

• Loading data from oracle to file
• spool c/sql/Person.txt
• set echo off newpage 0 space 0 pagesize 0 feed
  off head off trimspool on
• select
• '-'
• id ','
• firstName ','
• lastName ','
• from person
• spool off

19
Transfer Data from Oracle to MySQL (step 2)

• Loading data from file to MySQL
• LOAD DATA INFILE 'c/sql/PERSON.txt' INTO TABLE
  PERSON
• FIELDS TERMINATED BY ',' LINES STARTING BY
  '-'

20
Basic MySQL Information
21
Run MySQL

• startgt all programsgt mysql gt mysql server 5
• Mysql command line client
• The password is admin

22
Going through databases tables

• SHOW DATABASES
• Shows all the databases on the server
• USE databaseName
• Selects a certain database to use
• SHOW TABLES
• Shows all the tables in the current directory

23
MySQL Data Types
24
MySQL Data Types
25
Some differences between mysql oracle
26
MySQL AND Oracle
27
Running an SQL file in MySQL

• ORACLE
• START PathToYourFile
• MySQL
• Source PathToYourFile