Export Data From Mysql to CSV

Hi How can I export data, from the database tables in Mysql, to a Comma Seperated File(CSV). Urgent Amit Lonkar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Mysql Functions

Hi Can anyone tell me how to call Mysql UDF functions from Java?? Thanks Amit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Decrypt Password

Hi Can anyone tell me if there is a function as DECRYPT. If there is not, then how to decrypt a field which is Encrypted by the Mysql function ENCRYPT. URGENT Thanks Amit Lonkar - Before posting, please check:

Re: Re: Innodb Row Locks

Mysql Row Locking On Wed, 13 Feb 2002 [EMAIL PROTECTED] wrote : Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to

Mysql Commit Problem

HI I am using java. i am fireing the following query ,after and insert or update in Mysql through Java int returnValue = backend.setQueryResult(commit); where setQueryResult(String sql) is method that updates data in database. i have set the connection.setAutoCommit(false). The returValue

Mysql Row Lock Problem

Hi I have set lock on a row in Mysql by the command SELECT + selCols + FROM ATTRIBUTE LOCK IN SHARE MODE; Now when the user who has set the lock updates the record the the lock is still not released. Hence no other user is able to update. How do i release this lock ? Also If i have

JDBC Driver

Hi!!!=0A=0AI am using the Mysql JDBC Driver 2.0.11. I am trying to use the = methods getImportedKeys(), and getExportedKeys()=0A=0ABut it returns an emp= ty result set.=0A=0AI am using Innodb tables.=0A=0AThanks =0AAmit =0A -

JDBC Driver

Hi!!! I am using the Mysql JDBC Driver 2.0.11. I am trying to use the methods getImportedKeys(), and getExportedKeys() But it returns an empty result set. I am using Innodb tables. Thanks Amit - Before posting, please

Query Problem Please Help

I am trying to fire the following query but it is generating an error:- select color from colortable where colorcode = select max(colorcode) from colortable where colorcode = 5 Please Help Thanks Amit Lonkar -

Nested Queries

Hi!! I am trying to execute the following query. But it is giving an error at select max(columnname). select columname from tablename where columname1 = select max(columnname) from tablename Thanks Amit Lonkar -