SuSE GmbH

SuSE Support Database

Title: LNX: Error in document

----------

Mainpage o Searchform o History o Versions o Categories o 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 o Searchform o History o Versions o Categories o Contents
Deutsch

----------

SDB-lnx7, Copyright SuSE GmbH, Nuremberg, Germany - Version:
SuSE GmbH - Last generated: 07. Oct 1999 16:57:46 by maddin with sdb_gen 1.00.0