Re: MySQL 5.0 and Stored Procedures
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 Database to a MySQL-5.0 database. I have learned a lot from the internal mail archive, and I found 2 pdf documents, stored-procedures.pdf, Moving-Towards-MySQL-5.0.pdf. As well there is documentation as mentioned in the docs directory. gr. Bob - Original Message - From: Jim Winstead [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 7:10 PM Subject: Re: MySQL 5.0 and Stored Procedures On Wed, Oct 15, 2003 at 11:57:02AM -0500, woody at nfri dot com wrote: On Wed, 2003-10-15 at 10:55, Josh Wilson wrote: I have just recently compiled Mysql 5.0 onto my redhat linux box, and have been trying to set up some store procedures, but have yet to be able to figure out how. Can anyone help me on this on how to go about creating a stored proc in Mysql 5.0?? Any help or suggestions would be great. When you install development test releases (pre-alpha) you are pretty much on your own... Unless any documentation was included with the download, the only other thing around is the blurb on mysql.com In the MySQL 5.0 tree, the file Docs/sp-implemented.txt details the current state of the stored procedures implementation. Examples of the syntax can be found in mysql-test/t/sp.test Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] http://www.beheervisie.nl/disclaimer. 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]
packages en global session variables?
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://www.beheervisie.nl/disclaimer.
Re: MySQL 3.23.58 and sub-seletcs
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 work (syntax error in console): select iphdr.ip_src, timestamp \ from iphdr , acid_event \ where iphdr.sid = acid_event.sid \ and iphdr.cid = acid_event.cid \ and acid_event.sig_name = STATEMENT \ and acid_event.timestamp select max(another_database.dataz.timestamp) \ from another_database.dataz; greetz boka -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] http://www.beheervisie.nl/disclaimer. 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]
Exponentiation operator
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
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; end; Is this a bug or do I do something wrong? gr. 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]