Zoo tutorials:
[
SQL
|
SQLzoo.cn
|
Linux
|
Java
|
XML
]
SQL
zoo.net
Quick Ref.
SELECT
FUNCTIONS
SELECT
WHERE
SELECT
GROUP BY
SELECT
JOIN
SELECT
SELECT
INSERT
VALUES
INSERT
SELECT
UPDATE
DELETE
CREATE
TABLE
CREATE
VIEW
CREATE
INDEX
DROP
ALTER
TABLE
Name of the server
ingres
Name of the client
sql also isql
Typical command line to start the client
source ~ingres/.ingIIbash
sql iidbdb
server
iidbdb is the system database - where you create users and databases
operating system authentication
Ingres relies on the operatong system for authentication.
Useful commands
help\g
Beware!
Put \g at the end of each sql command
