How do I get help on MySQL functions that can be used in Smartform?

Question

Hi,

How do I find help for functions that exist in MySQL that I can apply with Smartform?  For example, sometimes I know the function name but am not sure how to apply it - I'd prefer not to go trawling the internet every time I can't remember something.

Thanks

Answer 1

To find help for MySQL functions, go to Smartform and type:

> HELP contents;

or at a lower level, select

> HELP functions;

or at a lower level still, let's say you are interested in all the functions available for dates and times:

>HELP Date and Time Functions;

Finally, you've settled on the specific function you are interested in.  Let's say it's TIME_FORMAT, so:

>HELP TIME_FORMAT;

will return all the references you need plus example use of this function.  Don't forget to include a Smartform field, such as scheduled_time, in your application of the function.

Answer 2

A great place to learn some basic SQL is at http://www.w3schools.com/sql/default.asp it is completely free and will cover all the basics of SQL so a good place to get started if you are a newbie.