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 request

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: http

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 hav

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

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 repl

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 - B

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 c

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 - Bef

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 -