Function: nornix_site.session_destroy

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Destroy session data, returns number of deleted rows

CREATE DEFINER=`root`@`localhost` FUNCTION `session_destroy`(vId VARBINARY(32)) RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Destroy session data, returns number of deleted rows'
BEGIN
 DELETE FROM phpsession WHERE id = vId;
 RETURN ROW_COUNT();
END