L06 - DRC, TRC, and SQL

L06 DRC TRC and - DRC TRC and SQL Before we get into"connecting the dots on the logicbased expression of queries and SQL we need to spend just a

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

View Full Document Right Arrow Icon
DRC, TRC, and SQL DRC, TRC, and SQL ± Before we get into “connecting the dots” on the logic- based expression of queries and SQL, we need to spend just a little time on pragmatic issues ± We will be using MySQL this semester. ² “official” pronunciation is My Ess Queue Ell but (according to the mysql.com web page, they don’t care if you say my sequel. ² The MySQL web page claims that it is the world’s most popular open source database ² You’ll need to install it on your own machine so you can play with things ± The good news is that because this is open source – you can download it for free
Background image of page 1

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

View Full DocumentRight Arrow Icon
Obtaining and Installing Obtaining and Installing MySQL MySQL ± Which version to install? ± mysql.com advises: “Normally, if you are beginning to use MySQL for the first time or trying to port it to some system for which there is no binary distribution, we recommend going with the production release series. Currently, this is MySQL 5.0.” ± So I recommend version 5.0. ± How to get it? ² Go to http://dev.mysql.com/ ² Click on Downloads (second link from the left near the top of the page). ² Locate the clickable link for ± Current Release (Recommended) : MySQL 5.0 -- Generally Available (GA) release for production use ± You’ll have to scroll down the page a bit to get to this ± Follow the link and choose: ² Windows (x86) ZIP/Setup.EXE (if you plan to run under Windows) ² Your favorite Linux choice (if you plan to run under Linux) ± Installation instructions in the User’s Manual: http://dev.mysql.com/doc/refman/5.0/en/index.html
Background image of page 2
What is in Which Versions of What is in Which Versions of MySQL MySQL ? ? Feature MySQL Series Unions 4.0 R-trees 4.1 (for the MyISAM storage engine) Subqueries 4.1 Cursors 5.0 Stored procedures 5.0 Triggers 5.0 and 5.1 Views 5.0 XA transactions 5.0 Event scheduler 5.1 Partitioning 5.1 Plugin API 5.1 Row-based replication 5.1 Server log tables 5.1 Foreign keys 5.2 (implemented in 3.23 for InnoDB )
Background image of page 3

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

View Full DocumentRight Arrow Icon
Creating a Database: Creating a Database: ± To create a database, at the mysql prompt: CREATE DATABASE dbname; the command is not case sensitive, the semicolon is important ± To use the database you just created: use dbname; again, the semicolon is important ± To make a table in the database: create table <table name and definition>; create table student(name char(30), college char(10), major
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/08/2008 for the course EE 468 taught by Professor Conry during the Spring '08 term at Clarkson University .

Page1 / 21

L06 DRC TRC and - DRC TRC and SQL Before we get into"connecting the dots on the logicbased expression of queries and SQL we need to spend just a

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

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