[Brett Kaiser]

Does mySQL have them?

got a sample syntax?

[r937]

avast, ye lazy landlubber, have ye no internet connection? can ye not reach the mysql.com site?

here ye go, ye flea-bitten scurvy knave...

http://dev.mysql.com/doc/refman/5.0/...rocedures.html

[mike_bike_kite]

Yes - from version 5 upwards.

Procedures look like this :

drop procedure if exists db_log_action;
$

create procedure db_log_action(
        IN      in_user_id      int,
        IN      in_logType      varchar( 20 ),
        IN      in_logMsg       varchar( 200 )
)
begin
        if in_logType != 'test' and in_logMsg != 'Searching for logs' then
                insert  db_Log ( id, logType, updTime, msgTxt )
                values ( in_user_id, ifnull(in_logType,'error'),
                        now(),ifnull( in_logMsg,'EMPTY') );
        end if;
end
$

Functions work well too:

drop function if exists db_return_hello
$

create function db_return_hello(
        in_name          varchar(250) ) returns varchar(250)
begin
        declare v_str   varchar(250);

        set v_str = concat( 'Hello ', in_name );

        return v_str;
end;
$

Mike

[Brett Kaiser]

Thanks guys

I'll go look at the link Rudy, but where can mySQL be installed?

Does it need a server?

[r937]

if you are developing, i would recommend installing it on your C drive

i managed to do it, and it was dead easy

but please don't ask me for particulars, i am ~so~ not a DBA

[mike_bike_kite]

If you have a server or web space on a server then you'll probably find it already has mysql. There usually an admin page to turn it on and set an admin password.

It's not diffiicult to put on your own PC but then it's more of a game writing web apps (assuming that's what you want to do) if the db's on your PC. You can pull the exe from their site.

Good luck

Mike

[healdem]

if you are planning unsing MySQL one thing to bear in mind is the MySQL does have one really really annoying feature... the Windows variant, like most Microsoft applications is case insensitive, whereas the other versions are case sensitive..

so you can develop an app happily on a MS hosted MySQL server, and find it passes all manner of testing.. but you come to grief on a Linux or other server, becaue of CaPiTaLiSaTiOn

[aschk]

If you want a development environment on your pc then google XAMPP