Data Retrieval on MySQL
The offset option, order by, and where clauses of the read ProcScript statement are supported, with some restrictions.
Stepped Hitlists
The stepped hitlist mechanism is fully supported.
By default, 10 hits are selected per step. This can be overruled by the step size
connector option.
read
The following clauses of the read ProcScript statement are supported, with the indicated restrictions:
-
offset option for data pagination—supported for the MySQL U3.0 connector and higher.
-
where clause—fully supported. All text between the double quotation marks (
"
) is inserted into the generatedselect
statement literally as entered. -
order by—fully supported. An order by clause is used for ordering. To guarantee that a specific order is returned, use the read
order by
ProcScript statement.
selectdb
The order by clause is not supported in the ProcScript statement selectdb. MySQL does not support the creation of views which include the order by argument, but when a view is created, this clause can be used to access the view.
The table shows the MySQL fields that have restrictions imposed while using the selectdb statement:
MySQL field |
Max |
Min |
Sum |
ave |
count |
---|---|---|---|---|---|
Binary |
Yes |
Yes |
No |
No |
Yes |
Varbinary |
Yes |
Yes |
No |
No |
Yes |
Char |
Yes |
Yes |
No |
No |
Yes |
Varchar |
Yes |
Yes |
No |
No |
Yes |
Date |
Yes |
Yes |
No |
No |
Yes |
Time |
Yes |
Yes |
No |
No |
Yes |
Timestamp |
Yes |
Yes |
No |
No |
Yes |
Decimal |
Yes |
Yes |
Yes |
Yes |
Yes |