Multiselect

Hi, can anybody tell me how can i select,update, delete the records from two table having same structure in the mysql. For ex MainTable --- id(int)|val (varchar) --- 1 a 2 b 3 c

special character

other way to do this. Thanks in advance, Regards Daya Krishan Dubey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

escape character

\blue255;} \viewkind4\uc1\pard\cf1\b\f0\fs20 SanjivnullKapila\b0\f1\fs24 4\cf2\f2\fs17 455 \par \pard } So it deletes the characters \r and \b. Column type is text. Thanks in advance Regards Daya Krishan Dubey - Before posting

How can i update the column with some value

Hi, I want to update a field like this 1) update table abc set col=col+'some const' 2) update table abc set col=col+col2 Is is it possible in mysql if yes then how. Thanks and Regards Daya Krishan Dubey - Before posting

Result using after statement and connection close

it works. If it cache the data as soon as object of result set is created then in case of updatable result how it will update the data in the resultset as well as in the database since connection is no more with database. Thanks in advance. Regards Daya Krishan Dubey Core Solucomm Ltd 423 B

function as default value

Hi, Can anybody tell me is it possible in the my sql to set the function as default value, for example can i set the now() function for the date column field. Thanks in advance. Regards Daya Krishan Dubey Core Solucomm Ltd 423 B, Hamilton court DLF phase IV Gurgaon, India Ph# 91-124-6392896/7

default date time insertion in the database

Hi, can anyone tell me how can i set the default datetime as current datetime in the mysql. so that every time i insert a record in the table current datetime automaticall inserted. Thanks in advance. Regards Daya Krishan Dubey Core Solucomm Ltd 423 B, Hamilton court DLF phase IV Gurgaon, India