clear_functions()
cur.execute("""
SET @base_value = 3,
@extracting_column = 30,
@number_of_columns = 40,
@number_of_layers = 5,
@active_side = 1;
""")
cur.execute("""
DELIMITER //
CREATE FUNCTION flip_side
(
side INT
)
RETURNS int
BEGIN
IF (side = 1) THEN
return 2;
ELSE
return 1;
END IF;
END // DELIMITER;
""")
cur.execute("""
CREATE FUNCTION flip_column
(
column_ INT
)
RETURNS int
BEGIN
return @number_of_columns - column_ + 1;
END
""")
cur.execute('SELECT flip_column(4)')
cur.fetchall()
Comments
0 B
|👍
/👎