Stuff
public sql v1 · immutableCREATE TABLE OPTIONS ( OPTION_KEY varchar(30) NOT NULL, OPTION_VALUE varchar(100), DATE_CREATE timestamp NOT NULL, DATE_MOD timestamp NOT NULL, PRIMARY KEY (OPTION_KEY));INSERT INTO OPTIONS (OPTION_KEY, OPTION_VALUE) VALUES ('BasePath', '/home/wladek/armoury');DELIMITER //CREATE FUNCTION FUNC_GET_OPTION (OPTION_KEY char(30)) RETURNS char(100)BEGIN DECLARE hi char(100); SELECT OPTION_VALUE INTO hi FROM OPTIONS WHERE OPTION_KEY = 'BasePath' LIMIT 1; RETURN hi;END;//