mysqldump will backup by default all the triggers but NOT the stored procedures/functions. There are 2 mysqldump parameters that control this behavior: –routines – FALSE by default –triggers – TRUE by default so in mysqldump command , add –routines like : mysqldump <other mysqldump options> –routines > outputfile.sql See the MySQL documentation about mysqldump arguments.
With quotes around the date: mysql> CALL insertEvent(‘2012.01.01 12:12:12’);
I figured it out now. Here’s the correct answer CREATE PROCEDURE checkUser ( brugernavn1 varchar(64), password varchar(64) ) BEGIN SELECT COUNT(*) FROM bruger WHERE bruger.brugernavn=brugernavn1 AND bruger.pass=password; END; @ points to a global var in mysql. The above syntax is correct.
In general, non-commutative case you can use apply: (defn sum [& args] (apply + args)) Since addition is commutative, something like this should work too: (defn sum [& args] (reduce + args)) & causes args to be bound to the remainder of the argument list (in this case the whole list, as there’s nothing to … Read more
We start with Microsoft’s .NET guidelines: http://msdn.microsoft.com/en-us/library/ms229042.aspx (link updated for .NET 4.5) Microsoft’s C# guidelines: http://blogs.msdn.com/brada/articles/361363.aspx. and then document the differences from and additions to that baseline.
A function returns a value and a procedure just executes commands. The name function comes from math. It is used to calculate a value based on input. A procedure is a set of commands which can be executed in order. In most programming languages, even functions can have a set of commands. Hence the difference … Read more