Skip to content

Instantly share code, notes, and snippets.

<head>
<script language="javascript" src="http://p5js.org/js/p5.min.js"></script>
<script language="javascript" src="http://p5js.org/js/p5.dom.js"></script>
<script language="javascript" src="http://p5js.org/js/p5.sound.js"></script>
<script language="javascript" src="sketch.js"></script>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
</body>
@rdsilver
rdsilver / index.html
Created October 13, 2014 04:15
Eli Gist
<head>
<script language="javascript" src="http://p5js.org/js/p5.min.js"></script>
<script language="javascript" src="http://p5js.org/js/p5.dom.js"></script>
<script language="javascript" src="http://p5js.org/js/p5.sound.js"></script>
<script language="javascript" src="sketch.js"></script>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
</body>
<html>
<head>
<script language="javascript" src="http://p5js.org/js/p5.min.js"></script>
<script language="javascript" src="http://p5js.org/js/p5.dom.js"></script>
<script language="javascript" src="http://p5js.org/js/p5.sound.js"></script>
<script language="javascript" src="sketch.js"></script>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
I want to be able to call this function with something like "SELECT test() FROM tableName"
I'm getting an error on line 8 when I try to make the function
DELIMITER $$
CREATE FUNCTION test()
RETURNS TEXT
BEGIN
DECLARE max_id INT;
SET max_id = SELECT max(id); //Erroring
RETURN CONCAT('Max ID is', max_id, ' !');