In SQLite I try to create function and I can't.
CREATE FUNCTION "MD"() RETURNS TINYINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT '' BEGIN SELECT small||5-small AS MD FROM ( SELECT
- (L1 BETWEEN 1 AND 21)
- (L2 BETWEEN 1 AND 21)
- (L3 BETWEEN 1 AND 21)
- (L4 BETWEEN 1 AND 21)
- (L5 BETWEEN 1 AND 21) AS small FROM ALLMINI) END
It is created by HeidiSQL submenu CREATE NEW / stored function but I receive error near FUNCTION and can't save. It drive me crazy as I saw at youtoube it works but in MYSQL
Any idea? Have I got bad settings?
The same problem when I try to edit table, go to BASIC TAB? and try to add column and save. Now I was succeded but when I tryied to delete this column I can't save it and error near drop. So the problem is maybe in the syntax or in savings the sequnence of my actions. In code ALTER there were as well new column add as drop and I can't edited it.