Calling a procedure with parameters

Hi, If this possible in MYSQL (capability of procedure with parameterized parameters). Assume a procedure with parameters a1,a2,a3 test(a1,a2,a3) begin . . end Can I call the procedure test by following way call test(a2 = 5, a1 = 4, a3 = 7); i.e changing the ord

Stored procedures

Hi, I'm testing stored procedure on MySQL5.0.My question is can I change the definition of a procedure body using ALTER PROCEDURE?(Not the characteristics). I'm not sure if it is implemented! TIA, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Thread safe client

Hi, Is there any sample code available for MYSQL thread safe client using C API? Thanks in advance, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL benchmarks

Hi All, Is there any AS3AP benchmark suite readily available for MySQL? Thanks in advance, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Needing help for JDBC issue

Hi, I'm getting the following error while connecting to a MySQL databases using JDBC. Any clues?? "java.net.SocketException: errno: 48, error: Address already in use" Thanks, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

java.net.SocketException: errno: 48, error: Address already in use

Hi, I'm getting the following error while connecting to a MySQL databases using JDBC. Any clues?? Thanks, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4 Built in SSL?

Hi, 1.First generate un encrypted certificates. This can be done by using an Open SSL library. The instructions are available at http://www.mysql.com/doc/en/Secure_Create_Certs.html Note: Here un encrypted certificates means certificates that are not protected by any password. When MySQL code

Re: Error 2013 during query

Check the connection timeout parameter. Increase it if it's low and try.. >>> "W. Bauer" <[EMAIL PROTECTED]> 10/16/2003 6:20:44 PM >>> Dear all When I run a query on a table with about 22 Mio records and three columns of type bigint, I get a Error 2013 Lost connection to MySQL server during que

Re: Select always "Using FileSort"

Whenever you use select * MySQL will skip using index. For more information, http://www.mysql.com/doc/en/MySQL_indexes.html . Thanks, Ram >>> mos <[EMAIL PROTECTED]> 10/15/2003 10:17:22 AM >>> I want to speed up a large query and I noticed if I do an: Explain select * from LargeTable order by

Migration tools for sybase to MySQL

Hi, Are there any tools to migrate db schema as well as data from sybase to mysql? Thanks, Prasad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

XML support for MySQL

Is it possible to direct xml support for queryiing a SQL statement and get the result in also in xml? Prasad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqladmin: connect to server at 'localhost' failed

Check the sysntax! It should be mysqladmin -u root -p shutdown (If u r shutting down the server) You should provide the password if you have one for the root user. >>> Saravanan Kulandaivelu <[EMAIL PROTECTED]> 7/23/2003 3:21:59 PM >>> Hi, I am getting the following error: mysqladmin: connect

Help required on testing MySQL with Open SSL

Hi, I'm looking for information on testing MySQL server with Open SSL using any client(JDBC/ODBC). Please let me know how to test using a MySQL client for SSL. I was able to compile mysql with using open SSL Thanks Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

How to Archive and restore the data in MySQL database.

Hi, Can any of you give me links about Archiving and restoring the data in MySQL database. Are there any utilities for the same? Thanks in advance, Ram - Before posting, please check: http://www.mysql.com/manual.php (the man

Java.lang.outofMemoryException while accessing MySQL usingJDBC

Hi, I have a JDBC application connecting to MySQL database. It was working fine for the queries that retrieve small amounts of data. But when the database contains 600,000 records and the query SELECT * is fired it gives Java.lang.outofMemoryException. Can any of you help me out what could be the