replace qeustion
Table_1 - A B C - 1018 9 4 3 1 -- how can i change column C's "9" to say "20" without inserting a new record and columns A and B remain unchanged? do i use REPLACE or what?please advice. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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
replace qeustion
Table_1 - A B C - 1018 9 4 3 1 -- how can i change column C's "9" to say "20" without inserting a new record and columns A and B remain unchanged? do i use REPLACE or what?please advice. chee keong _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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
Error 1052:Query problem
Table_A: ID APPL B BI A BII * * * * C BII * * D BI Table_B: Cnty ID USC Aus A Aus B USD * signifies no data why does the following produce an error: 1052?? SELECT DISTINCT APPL FROM Table_A, Table_B WHERE Table_A.ID=Table_B.ID AND Cnty="US" AND ID="*"; _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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
cant connect to local mysql server
hi..could someone pls help me i had created mysql server before in my pc but this morning i discovered that i cant access my mysql server.this is what i typed: shell mysql this is what i got: ERROR 2002:Can't connect to local MySQL Server through socket '/tmp/mysql.sock'(111) what is it trying to say??? by the way, i wasn't logged on to the internet at that moment. Is that the reason why it fails to connect _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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