0 SQL SQL SELECT DISTINCT city, state FROM customers; SQL SQL DBMS SQL DBMS SQL 0-1 SQL SQL
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
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 100 0-2 SQL 0-1 Visual Basic Access SELECT au_fname, au_lname FROM authors; xv
0SQL SQL SQL DBMS SQL SQL SQL host language C++Java COBOL PerlPHP Python PHP CGI SQL MySQL MySQL PHP SQL Visual Basic 0-3 0-3Visual 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 3.2 0-1 ISO/IEC 9075:2003 SQL:2003 www.ansi.org www.iso.org SQL DBMS
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 http:// troels.arvin.dk/db/rdbms www.fehily.com 2.6 Contact SQL Server DBMS SQL DBMS / SQL SQL / xviii
1 DBMS SQL DBMSDatabase Management System DBMS DBMS DBMS DBMS host SQL DBMS DBMS DBMS Oracle 300 1.1 SQL DBMS SQL Microsoft Access 2007 Microsoft SQL Server 2008 Oracle 11g IBM DB2 9.5 MySQL 5.1 PostgreSQL 8.3
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 www.cygwin.com UWINwww.research.att.com/sw/ tools/uwin Unix shell 1-2
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.com SAS DBMS ANSI DBMS SQL PROC SQL SAS/ Access SAS SAS SQL observation SQL variable SQL http://en.wikipedia.org/wiki/comparison_of_relational_database_management_ systems Comparison of Relational Database Management Systems 1.2 Microsoft Access Microsoft Access DBMS www. microsoft.com/office/ access Access 60 Microsoft Access 2007 20002002 Access XP 2003 Access Access 2003 Help About 1-1 This database ANSI-92 SQL 1-4
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 1. 2. SQL SQL token SQL
03 SQL 3. SQL SQL SELECTFROMWHERE ORDER BY 4 4. SQL DBMS DBMS 5. au_fnameau_lnameauthors state 3.3 6. SQL ; SQL 3-1 SQL SQL SELECTselect select 3-2 SQL 3-1 3-2 3-2
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 3-1 3-3