Re: MySQL 5.0 and Stored Procedures

2003-10-16 Thread Bob Brands
Hi, I'm working with version 5.0 as well, like you I find it hard to find documentation on MySQL-5.0 and not much support for MySQL-5.0 on the mysql list, probably because not many people work with 5.0. I'm studding MySQL5.0 to see how far I can come to create a tool to convert a Oracle Databas

packages en global session variables?

2003-10-14 Thread Bob Brands
Hi, Will it be possible in mysql-5.0 to create packages and global session variables? or will this be possible in the near future? I can't find any documentation on this subject, does someone have some documentation on MySQL 5.0 or knows where to find more? greetings, Bob http

Re: MySQL 3.23.58 and sub-seletcs

2003-10-09 Thread Bob Brands
No, its supported by version 4.1 gr. - Original Message - From: "boka" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 11:54 AM Subject: MySQL 3.23.58 and sub-seletcs > Hi ! > > Are sub-selects supported by MySQL 3.23.58, because below query does not > wor

Exponentiation operator

2003-10-08 Thread Bob Brands
What is the correct syntax for using a Exponentiation operator in MySQL? BTW is this even posible? bye, Bob http://www.beheervisie.nl/disclaimer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 5.0, func stored in proc table

2003-09-30 Thread Bob Brands
Hi, I compiled MySQL 5.0 from the source tree to test how stored procedures work. When I create a function, It is not stored in de mysql.func table, but in the mysql.proc table. Example of the function a create: create function fun(a int) returns int begin set a = a + 1; return a