"Fossies" - the Fresh Open Source Software Archive

Member "mysqlwdb-1.5.4/CREATE_NOTES" (3 Nov 2003, 1857 Bytes) of package /linux/www/old/mysqlwdb-1.5.4.tar.gz:

    1 
    2 Create table notes
    3 ==================
    4 
    5 - INDEX specifier
    6 
    7   MySQL syntax: INDEX [index_name] (index_col_name1,index_col_name2(length))
    8 
    9   To specify the index_col_name just check the checkbox of the field
   10   To specify index_name just type it in the 'Index' field
   11   If you want to omit the index_name just type a space in the 'Index' field
   12   To specify index_name plus the length for the field just type the name
   13   followed by (number) in the 'Index' field.
   14 
   15 	e.g. custumer_index(12)
   16 
   17   If you want to omit the index_name but followed by the length for the field
   18   just type a space followed by (number) in the 'Index' field
   19 
   20 	e.g.  (12)
   21 
   22   Indexing of *BLOB and *TEXT is permitted only with MySQL Version 3.23.2 and 
   23   newer, always with a length for the field.
   24 
   25   To create a *TEXT primary key, put the required lenght for the key in the Index textbox
   26 
   27 - UNIQUE specifier
   28 
   29   MySQL syntax: UNIQUE [index_name] (index_col_name,...)
   30 
   31   To specify the index_col_name just check the checkbox of the field
   32   To specify index_name just type it in the 'Unique' field
   33   If you want to omit the index_name just type a space in the 'Unique' field
   34 
   35 
   36 - LENGTH, DECIMALS and DEFAULT specifiers
   37 
   38   Actually there is no control for the values submitted in the text input
   39   controls for LENGTH, DECIMALS and DEFAULT type specifiers.
   40 
   41 
   42 - YEAR
   43 
   44   YEAR column type is new from MySQL 3.22.
   45   If you have an older version of MySQL please go to the end of file and
   46   remove the line that becomes with YEAR (around line 5523).
   47 
   48 
   49 - SET, ENUM
   50 
   51   If you want to create a SET or ENUM column, please choose the
   52   appropriate type from "Field type" column and write the list of values
   53   in the "Lenght" column (without brackets, comma separated, contained by '').
   54   
   55   e.g. 'val1','val2','val3'
   56 
   57 
   58 - FULLTEXT
   59 
   60   Supported from MySQL 3.23.23, can be created for VARCHAR and TEXT columns