mySql error 1064

Question

This drives me craze, whatever i do in SqlQueryBrowser i have the same 1064 error:

CREATE Function surname (uid int(11)) Returns TEXT

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

What is the problem ? Thanks

Answer 1

This

CREATE Function surname (uid int(11)) Returns TEXT

is not a valid function yet: It needs a BEGIN / END block, and a return statement.