Assuming that 'id' is the name of the MySQL column selected as the unique
identifier when phpMyEditSetup.php script was run, the
key will appear in the script as:
Example 3-3. Unique key definition // Name of field which is the unique key
$opts['key'] = 'id';
 |
There were problems reported by phpMyEdit users regarding the usage of MySQL
reserved word as an unique key name (the example for this is "key" name). Thus
we recommend using another name of unique key. Usage of "id" or "ID"
names should be safe and good idea.
|
The column type for the unique numeric identifier should appear as:
Example 3-4. Unique key type definition // Type of key field (int, real, string, date, etc.)
$opts['key_type'] = 'int';
The argument 'int' shown above indicates the column type is an integer. If the
column type was a date then 'date' would appear above instead of 'int'. Other
possible unique key types are 'real' or 'string'.
|
If you are using 'real' key type and some problems with record manipulaton have
occured, it is probably because your MySQL key datatype is 'float'. Comparsions
with this datatype is a common problem in most computer languages (including SQL),
because floating-point values are not exact values. In most cases, changing
the MySQL datatype from 'float' to 'double' and preserving 'real' as phpMyEdit key type
should solve this problem.
For more information about this issue, read Solving Problems with No
Matching Rows chapter in the MySQL manual (in version 3.23.47 it was A.5.6).
|
| 
Prihlásiť
Registrácia
English
