SQL

[ZamoraM831]

I juss started to learn a LIL about mySQL database programming which i intend to use with PHP. I was juss wondering, i have an old book called :
SQL*Plus
User's guide
Version 2.0
would this book teach the same stuff as in mySQL?
are SQL and mySQL even different?
and is this book ok to use to help guide me to use mySQL?
thx in advance

------------------
Z

[kid A]

Whatis.com on MySQL:
mySQL

MySQL (pronounced "my ess cue el," not "my sequel") is an open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database. Because it is open source, anyone can download mySQL and tailor it to their needs in accordance with the general public license. MySQL is noted mainly for its speed, reliability, and flexibility. Most agree, however, that it works best when managing content and not executing transactions.
The mySQL relational database system was first released in January, 1998. It is fully multi-threaded using kernel threads, provides application program interfaces (APIs) for C, C++, Eiffel, Java, Perl, PHP, Python, and Tcl, allows for many column types, and offers full operator and function support in the SELECT and WHERE parts of queries.

The development team working on future releases of mySQL plan to unveil mySQL 4.0 in mid-2001. Its features will include a new table definition file format, enhanced replication, and more functions for a full-text search. Later, mySQL developers hope to add fail-safe replication, a port of mySQL to BeOS, and an option to periodically flush key pages for tables with delayed keys. Over time, MySQL plans to be fully ANSI 92/ANSI 99- compliant.

MySQL currently runs on the Linux, UNIX, and Windows platforms. Many Internet startups have been especially interested in mySQL as an alternative to the proprietary database systems from Oracle, IBM, and Informix. Yahoo's news site uses mySQL.

Whatis.com on SQL:
Structured Query Language

SQL (Structured Query Language) is a standard interactive and programming language for getting information from and updating a database. Although SQL is both an American National Standards Institute and an International Organization for Standardization standard, many database products support SQL with proprietary extensions to the standard language. Queries take the form of a command language that lets you select, insert, update, find out the location of data, and so forth. There is also a programming interface.

So, yes - it would help o read that old book - to some extent

Sources: http://whatis.techtarget.com/definit...ml?query=MySQL http://whatis.techtarget.com/definit...214230,00.html

Hope this helps

------------------
Now listening to:
Mogwai - Rock Action
[This is an ad for]

[Momaw]

SQL*Plus is a client program that allows you to talk to a database and retreive information from it, as well as work with the results. It will teach you the general format of an SQL query, but it won't teach you about how to install, set up, or administer a database.

Another program you might want to look at is called SQL Navigator. There's a few people at my work place that use it and swear by it. Only runs under Windows though, so most of us are out of luck with Linux boxes

------------------
/earth is 98% full ... please delete anyone you can.