replace qeustion

2001-03-21 Thread soon chee keong
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.

replace qeustion

2001-03-21 Thread soon chee keong
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.

Error 1052:Query problem

2001-03-01 Thread soon chee keong
Table_A: ID APPL B BI A BII * * * * C BII * * D BI Table_B: Cnty ID USC Aus A Aus B USD *

cant connect to local mysql server

2001-02-06 Thread soon chee keong
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