SuSE Support Database

Title: LNX: Error in document

---

Mainpage ---- Searchform ---- History ---- Versions ---- Categories ---- Contents
Deutsch
---

LNX: Error in document

Applicable to
S.u.S.E. version: 4.4
LNX version: 3.5 / 4.0

Symptom:

The CREATE TABLE is wrongly described. During the primary key's creation appears in the document:
CREATE TABLE Test (
        Nr Integer,
        Alter Integer)
        PRIMARY KEY Nr

Solution:

The correct one is:
CREATE TABLE Test (
        Nr Integer,
        Alter Integer)
        PRIMARY KEY (Nr)
or in the description should be:
CREATE TABLE <table name> ( <column's name> data type [, 
<column's name>
    data type ... ] ) 
    [ PRIMARY [UNIQUE] KEY (<column's name> [, <column's 
name> 
... ])

Symptom:

The syntax for between is declared as follows:
between value1 - value 2

Solution:

It should be :
between value1 and value2

---

Keywords: LNX, CREATE TABLE

---

Feedback welcome: Send Mail to kfr@suse.de (Please give the following subject: SDB-lnx7)

---

Mainpage ---- Searchform ---- History ---- Versions ---- Categories ---- Contents
Deutsch
---

SDB-lnx7, Copyright SuSE GmbH, Nuremberg, Germany - Version:
Impressum - Last generated: 24. Feb 1999 14:58:22 by maddin with sdb_gen 1.00.0