Re: MySQL 5 problem with select and stored procs
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 same issue in Mysql 5. Any help appreciated. - Original Message - From: Aleksandar Bradaric [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 16, 2004 1:15 PM Subject: Re: MySQL 5 problem with select and stored procs Hi, Any ideas why it's looking for the table .1? Could you post your query? Take care, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5 problem with select and stored procs
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 ('mytable')and inserted a row, when selecting from that table within CC I get: 1 row in set (0.01) sec [RM_SERVER] ERROR 1146: Table 'rm_development.1' doesn't exist Any ideas why it's looking for the table .1? Secondly when I try and create a stored procedure : create procedure sp_test() BEGIN select count(*) from mytable; END I get the following error message: [RM_SERVER] ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 1 Looks OK to me! Is there anywhere I can get hold of the SQL:2003 syntax? TIA - Email provided by http://www.ntlhome.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL 5 Stored Procedure
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 this should have been created as part of the installation. Any ideas as to why this is and what I can do? Thanks - Email provided by http://www.ntlhome.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]