Mysql Functions

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Mr Tech
Forum Contributor
Posts: 424
Joined: Tue Aug 10, 2004 3:08 am

Mysql Functions

Post 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?
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post 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.
(#10850)
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I have to agree with arborint (as usual) on this. The respective manuals are quite simple to follow for me.
User avatar
Mr Tech
Forum Contributor
Posts: 424
Joined: Tue Aug 10, 2004 3:08 am

Post 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?
User avatar
n00b Saibot
DevNet Resident
Posts: 1452
Joined: Fri Dec 24, 2004 2:59 am
Location: Lucknow, UP, India
Contact:

Post 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.
Post Reply