Re: MySQL 5 problem with select and stored procs

2004-01-17 Thread matthew.darby
It's just a simple select: select * from mytable but run from within the control center The error returned: [RM_SERVER] ERROR 1146: Table 'rm_development.1' doesn't exist where RM_SERVER is the server I created and rm_development is the database. I did see someone else has posted with the

MySQL 5 problem with select and stored procs

2004-01-16 Thread matthew.darby
Hello I've installed MySQL 5 and I seem to have a couple of problems with it (or it does with me). After installing into a clean environment I created a new server (rm_development) in the Control Center, and then created a new database. The first problem/query is after having created a table

MYSQL 5 Stored Procedure

2004-01-07 Thread matthew.darby
Hello I've installed Mysql 5 and have created a database. When I try and create a stored procedure (using the example in the help) it fails. The online help states that there should be a table called 'procs' in the database for stored procedures to work. I can't see this table. The help says