"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:
As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard
) with prefixed line numbers.
Alternatively you can here view
the uninterpreted source code file.
2 Create table notes
5 - INDEX specifier
7 MySQL syntax: INDEX [index_name] (index_col_name1,index_col_name2(length))
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.
15 e.g. custumer_index(12)
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
20 e.g. (12)
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.
25 To create a *TEXT primary key, put the required lenght for the key in the Index textbox
27 - UNIQUE specifier
29 MySQL syntax: UNIQUE [index_name] (index_col_name,...)
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
36 - LENGTH, DECIMALS and DEFAULT specifiers
38 Actually there is no control for the values submitted in the text input
39 controls for LENGTH, DECIMALS and DEFAULT type specifiers.
42 - YEAR
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).
49 - SET, ENUM
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 '').
55 e.g. 'val1','val2','val3'
58 - FULLTEXT
60 Supported from MySQL 3.23.23, can be created for VARCHAR and TEXT columns