Databases Reference
In-Depth Information
$cfg['RestrictFunctions'] = array(
'FUNC_CHAR' => array(
'ASCII',
'CHAR',
'SOUNDEX',
'LCASE',
'UCASE',
'PASSWORD',
'OLD_PASSWORD',
'MD5',
'SHA1',
'ENCRYPT',
'COMPRESS',
'UNCOMPRESS',
'LAST_INSERT_ID',
'USER',
'CONCAT'
), [...]
As depicted in the following screenshot, we apply the
UCASE
function to the title
when saving
this row
:
This feature may be disabled by setting
$cfg['ShowFunctionFields']
to
FALSE
to
gain some screen space (to be able to see more of the data).
Duplicating Rows of Data
During the course of data maintenance (for permanent duplication or for test
purposes), we often have to generate a copy of a row. If this is done in the same
table, we must respect the rules of key uniqueness.
Search WWH ::
Custom Search