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 --- Duplicate Table --- id (int) | val (varchar) --- 1 d 5 e 6 f --- I want result for id 1 like this --- id (int) | val (varchar) --- 1 a 1 d --- Thanks in advance DK Dubey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
special character
Hi, Can naybody tell me how do i ignore special character while insering in mysql database. For example while i m inserting string 'dk\bd\r' it takes \b and \r as diffenrent character, although i can ignore it with one more escape character like this 'dk\\bd\\r'. Field type is Text. Is there any 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 this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
escape character
Hi can anybody tell me how can i insert rtf data in my sql, since it contains escape characters like this {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Verdana;}{\f1\fnil\fcharset2 Webdings;}{\f2\fnil\fcharset0 MS Sans Serif;}} {\colortbl ;\red0\green0\blue0;\red0\green0\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, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Result using after statement and connection close
Hi, I am using MySQL with the mm.mysql-2.0.14 dirver. I got connection with the databse after that i created an object of statement and after that i got the object of ResultSet, then i closed the statement and then conection. But when i use this resultset it works fine. Can anybody tell me how 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, Hamilton court DLF phase IV Gurgaon, India - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 (O) Mobile# 91-9811294209 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Ph# 91-124-6392896/7 (O) Mobile# 91-9811294209 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php