Back
Query
Template: ../../test4.core.tenanthandbooks.com/httpdocs/components/utilities/databaseconnector.cfc:138
Execution Time: 2.27 ms
Record Count: 8
Cached: No
Lazy: No
SQL:
SELECT
COLUMN_NAME,
DATA_TYPE,
NUMERIC_SCALE,
COLUMN_KEY,
COLUMN_DEFAULT,
IS_NULLABLE,
CHARACTER_MAXIMUM_LENGTH,
COLUMN_TYPE,
EXTRA,
CHARACTER_SET_NAME
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'UserSessionSavedValues'
AND TABLE_SCHEMA = DATABASE()
ORDER BY
ORDINAL_POSITION
COLUMN_NAMEDATA_TYPENUMERIC_SCALECOLUMN_KEYCOLUMN_DEFAULTIS_NULLABLECHARACTER_MAXIMUM_LENGTHCOLUMN_TYPEEXTRACHARACTER_SET_NAME
1idint0PRINOintauto_increment
2LoginIDvarcharMULYES255varchar(255)latin1
3UserIDint0YESint
4NamevarcharYES255varchar(255)latin1
5ValuelongtextYES4294967295longtextlatin1
6DateAddeddatetimeYESdatetime(6)
7LastUpdateddatetimeYESdatetime(6)
8LastAccesseddatetimeMULYESdatetime(6)