0SQL SQL SQL SQL SQL 3 SQL DBMS Oracle DBMS DBMS DBMS DBMS RDBMS R DBMS 2 DBMS RDBMS R SQL SQL SQL SQL SELECT au_fname,au_ lname FROM authors ORDER BY

Size: px

Start display at page:

Download "0SQL SQL SQL SQL SQL 3 SQL DBMS Oracle DBMS DBMS DBMS DBMS RDBMS R DBMS 2 DBMS RDBMS R SQL SQL SQL SQL SELECT au_fname,au_ lname FROM authors ORDER BY"

评臧
5 years ago
Views:

1 0 SQL SQL SELECT DISTINCT city, state FROM customers; SQL SQL DBMS SQL DBMS SQL 0-1 SQL SQL

2 0SQL SQL SQL SQL SQL 3 SQL DBMS Oracle DBMS DBMS DBMS DBMS RDBMS R DBMS 2 DBMS RDBMS R SQL SQL SQL SQL SELECT au_fname,au_ lname FROM authors ORDER BY au_lname; C Perl SQL C PHP SQL SQL if-then-elsewhilefor goto xiv

3 Microsoft Access Visual Basic VB SQL 0-1 VB Do Until 0-2 SQL 20 VB SQL 0-1 SQL 0-1 Microsoft Access Visual Basic Sub GetAuthorNames() Dim db As Database Dim rs As Recordset Dim i As Integer Dim au_names() As String Set db = CurrentDb() Set rs = db.openrecordset(authors) rs.movelast ReDim au_names(rs.recordcount - 1, 1) With rs.movefirst i = 0 Do Until.EOF au_names(i, 0) =![au_fname] au_names(i, 1) =![au_lname] i = i + 1.MoveNext Loop End With rs.close db.close End Sub 0-2 SQL SQL SELECT SQL 0-1 Visual Basic Access SELECT au_fname, au_lname FROM authors; xv

4 0SQL SQL SQL DBMS SQL SQL SQL host language C++Java COBOL PerlPHP Python PHP CGI SQL MySQL MySQL PHP SQL Visual Basic Visual Basic SQL Sub GetAuthorNames2() Dim db As Database Dim rs As Recordset Set db = CurrentDb() Set rs = db.openrecordset(select au_fname, au_lname FROM authors;) --Do something with rs here. rs.close db.close End Sub SQL SQL DBMS xvi SQL SQL ISO IEC ANSI 0-1ISO/ IEC SQL ANSI SQL 2003 SQL ANSI SQLSQL:2003 SQL ISO/IEC 9075:2003 SQL: SQL DBMS

5 00-2 SQL 1 3 DBMS SQL Visual QuickStart shell Windows DOS Mac OS X SQL SQL DBMS SQL Peter Gulutzan Trudy Pelzer SQL-99 Complete, Really (CMP Books) SQL-99 SQL DBMS Kevin KlineDaniel Kline Brand Hunt SQL in a Nutshell (O' Reilly) DBMS Access SQL:2003 SQL Troels Arvin Comparison of Different SQL Implementations DBMS SQL SQL SQL:2003 DBMS Access troels.arvin.dk/db/rdbms Contact SQL Server DBMS SQL DBMS / SQL SQL / xviii

6 1 DBMS SQL DBMSDatabase Management System DBMS DBMS DBMS DBMS host SQL DBMS DBMS DBMS Oracle SQL DBMS SQL Microsoft Access 2007 Microsoft SQL Server 2008 Oracle 11g IBM DB2 9.5 MySQL 5.1 PostgreSQL 8.3

7 01 DBMS DBMS SQL SQL Microsoft Access SQL DBMS interactive modescript mode SQL SQL SQL 1-1 SQL DBMS 1-1 listing0101.sql SQL SELECT DBMS SELECT au_fname, au_lname FROM authors ORDER BY au_lname; DBMS SQL 1,000 DBMS HenPlushttp://henplus.sourceforge.net DBMS SQL sql front end sql client Windows Unix Cygwin UWINwww.research.att.com/sw/ tools/uwin Unix shell 1-2

8 Windows \:\ Unix Mac OS X /C:\Program Files\ Microsoft SQL Server Windows /usr/local/bin/mysql Unix scripts\listing0101.sql Windows doc/readme.txt Unix \\ 1-1 SQL PATH SQL DBMS DBMS path Windows echo $PATH Unix Mac OS X path Windows.bash_login.bashrc.cshrc.login.profile.shrc Unix Mac OS X DBMS FileMaker Prowww.filemaker.com SQL SQL Query Builder Execute SQL script SQL Sybasewww.sybase.com DBMS Sybase Microsoft DBMS Microsoft SQL Server SQL Sybase Adaptive Server 1-3

01 DBMS DBMS Teradatawww.teradata.com DBMS Teradata SQL ANSI SQL DBMS Firebirdwww.firebirdsql.org Borland InterBase DBMS ANSI SQL SQLitewww.sqlite.org DBMS ANSI SQL SQLite SASwww.sas.

9 01 DBMS DBMS Teradatawww.teradata.com DBMS Teradata SQL ANSI SQL DBMS Firebirdwww.firebirdsql.org Borland InterBase DBMS ANSI SQL SQLitewww.sqlite.org DBMS ANSI SQL SQLite SASwww.sas.com SAS DBMS ANSI DBMS SQL PROC SQL SAS/ Access SAS SAS SQL observation SQL variable SQL systems Comparison of Relational Database Management Systems 1.2 Microsoft Access Microsoft Access DBMS www. microsoft.com/office/ access Access 60 Microsoft Access Access XP 2003 Access Access 2003 Help About 1-1 This database ANSI-92 SQL 1-4

10 3 SQL SQL SQL SQL SQL 2.2 DBMS DBMS 2-1 SQL SQL SQL SQL SQL SQL data typenull 3.1 SQL 3-1 SQL SQL SQL SQL token SQL

11 03 SQL 3. SQL SQL SELECTFROMWHERE ORDER BY 4 4. SQL DBMS DBMS 5. au_fnameau_lnameauthors state SQL ; SQL 3-1 SQL SQL SELECTselect select 3-2 SQL

12 SQL 3-1 SQL NULL SELECT royalty_share FROM authors SELECT royalty_share FROM title_authors DBMS DBMS CREATE TABLE misspelled_name DBMS SELECT * FROM correct_name SQL verb SELECT SELECT SELECT SELECT DBMS /* */ expression

幻灯片 1

幻灯片 1 沈阳工业大学 2014 年 6 月第 7 章数据库技术基础主要内容 : 7.1 数据库概述数据库基本概念数据模型逻辑数据模型数据库系统的产生和发展常用的数据库管理系统 7.2 Access 2010 数据库创建及维护创建 Access 2010 数据库创建