not able to write stored procedures in mysql

[menmysql]

i am using mysql 4.17 and i heard abt it not supporting stored procedures. plz tell me how to excute stored procedres in my system

[cnplnsk]

as per my information you can't create store procedure in mysql 4.17 because it not support for stored procedure so, you will need to use of mysql 5.0.1 and above

[menmysql]

i dowloaded it from mysql.com but im not able to work with that. can you say how to work with mysql 5.0. i downladed 5.0 from mysql.com and installed but it is saying that is mysql server. im in full of confusion. plz solve my problem
and also tell how to update my oldeversion to 5.0

as per my information you can't create store procedure in mysql 4.17 because it not support for stored procedure so, you will need to use of mysql 5.0.1 and above

[cnplnsk]

OK i think i got your problem;
now start mysqld.exe for win98 or mysqld-nt.exe for nt/xp server file from bin directory of mysql.
OK this will start your mysql server.
Now shutdown server by ctrl+alt+delete choose end task

if you have winmysqladmin.e xe file in bin dir you need not do this only start the server and shutdown.

OK now create mysql.bat file in bin directory of mysql edit it and type the
following 4 lines of commands

if your mysql on localhost then type following
@echo off
cls
mysqld.exe /***choose mysqld.exe or mysqld-nt.exe as your system configuration as i told befor plz don't write this comment****/
mysql -u root

if your mysql from other host then type following
@echo off
cls
mysqld.exe /***choose mysqld.exe or mysqld-nt.exe as your system configuration as i told before plz don't write this comment****/
mysql -u root -h host_ip

now save the file
OK double click on mysql.bat this will start your mysql database
type following command.
mysql>use test
now can refer mysql manual for database commands from mysql.com

Note: Every time you have start this bat for restarting if there multiple server is running in ctrl+alt+delete task manager keep only one close other