R與商業應用 - Install SQL

Install MySQL & Sample Database

• MySQL Community Downloads

• MySQL on Windows
  • MySQL Installer (v)
  
  • MySQL Server (v)
    • install using zip
  • MySQL Connectors (v)
    • Connector/ODBC (v)
    • Connector/Net
    • Connector/J
    • Connector/Python
    • Connector/C++
    • Connector/C (libmysqlclient)
    • MySQL native driver for PHP - mysqlnd
  • MySQL Workbench and Sample models (v)
  • Sample Database (v)
    • Connector/Net
  • MySQL for Excel
  • MySQL Notifier
  • MySQL for Visual Studio
  • Documentation
• WindowsInstaller
• Type of Server Select

• Packages to install

## Using sakilla Database * ### Look @ Sakilla schema in Workbench

File -> Open models -> C:FilesWorkbench 6.3 CE

• Setup ODBC

• open odbc -> search for odbc

• Select sakilla

  

• Configure sakilla

  

• Test sakilla Press Test

• Using MySQL in R

• install RODBC library

  tools -> install Packages -> RODBC

  

• loading rodbc

    require(RODBC)

  ## Loading required package: RODBC

• connect to database

    ch <- odbcConnect(dsn="sakila")

• Sql Command

  sql <- 'SELECT film_id, title, rental_rate, rating, length  FROM 
  film WHERE film.film_id=19'

• Sql Query

    customer <- sqlQuery(channel=ch, query=sql)
    customer

  ##   film_id        title rental_rate rating length
  ## 1      19 AMADEUS HOLY        0.99     PG    113

• close DB

    odbcClose(channel=ch)