Changing columns descriptions...

2008-12-30 Thread Carlos Savoretti
MMENT ON COLUMN products.product_id IS 'Foo'; Thanks in advance Carlos Savoretti. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Information schema question.

2008-03-18 Thread Carlos Savoretti
=usesysid AND typrelid = 0 AND typname !~ '^_' -- Is there some way to obtain equivalent columns from INFORMATION_SCHEMA, as similar as possible ? Thanks in advance... Carlos Savoretti. -- MySQL General Ma

Prepared statement cursors problem.

2008-07-29 Thread Carlos Savoretti
ql_stmt_store_result failed: %s\n", mysql_stmt_error (cdata->mysql_stmt)); } --- fails giving: The statement (1) has no open cursor. ??? Why could be this ? , provided the cursor was set up before successfully What I missed up ? Thanks in advance. Carlos Savoretti

Prepared statement cursors problem.

2008-07-29 Thread Carlos Savoretti
ql_stmt_store_result failed: %s\n", mysql_stmt_error (cdata->mysql_stmt)); } --- fails giving: The statement (1) has no open cursor. ??? Why could be this ? , provided the cursor was set up before successfully What I missed up ? Thanks in advance. Carlos Savoretti

Optimizing a big query...

2005-03-09 Thread Carlos Savoretti
lient-3.23.58) and what is the the recommended value to clamp the `page' for a gui app. (For 1000 rows it uses about 12 seconds). Thanks a lot... -- Carlos Savoretti <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

Local variables

2004-09-10 Thread Carlos Savoretti
operation is carried out, and `Total' is NULL. What am I doing bad ? Please, help me Thanks all Carlos Savoretti [EMAIL PROTECTED] ... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can I do this ?

2001-05-24 Thread Carlos Savoretti
I'm using C API to access MySQL from another database in order to re-use a lot of existing software. Due the way the old database works I need a query be done like this: SELECT * FROM some_table WHERE field1 = 1 AND field2 > 0 ORDER BY CONCAT(field1,field2) LIMIT 1 This is for not to create

Alternative for storing results...

2001-06-01 Thread Carlos Savoretti
Hi. I'm using the C API to access mySQL database (trying to reuse a lot of existing software, mixing an old database & mySQL, but it's not the point). Due the way the old database (named Ideafix) run the keys sometimes the translated query produce too many rows (running out ot memory) although

Help me with mysql_store_result()

2001-06-01 Thread Carlos Savoretti
Hello, mysql: Can anyone say if exist some function in the C API that do not store all the requested rows before returning but it returns inmediatly for each one and the storing be in the remote server. Thanks a lot ! [EMAIL PROTECTED] ---