Page 1 of 1

Mysql Functions

Posted: Tue Sep 19, 2006 10:00 pm
by Mr Tech
I've been programming with MySQL for some time now but I am only just discovering there is a lot more you can do with MySQL without using PHP to do all the work...

I'm having a look at http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html and it's all jargon to me... it's the hardest documentation I've ever come across...

Does anyone know a website that is easy to understand and lists all the functions you can use with MySQL?

Posted: Tue Sep 19, 2006 10:08 pm
by Christopher
I have not found anything easier or clearer than that, but there may be some reference books around. The page you provided a link to seem great to me. Each function is defined and there are actual examples of what the function will return in a SELECT. That was nice of them.

Posted: Tue Sep 19, 2006 10:12 pm
by feyd
I have to agree with arborint (as usual) on this. The respective manuals are quite simple to follow for me.

Posted: Tue Sep 19, 2006 10:20 pm
by Mr Tech
I find all the italics etc hard to follow... Also, when it gives an example, it shows it like this:

Code: Select all

mysql> SELECT ASCII('2');
        -> 50
Is the character/number after the -> the value it would return?

Posted: Tue Sep 19, 2006 10:23 pm
by n00b Saibot
Yes.. and I would also suggest running some example queries against your (test) database so that you learn while you read it.