PDA

View Full Version : mysql


Branks
01-03-2005, 12:35 AM
whats the command to add a value to a 2D table, a single values i mean, or is it only possible to replace the etire row? ive tried everything i can think of and it seems google and the help file have failed me. so it would be much appreciated if anyone knows, again i have a table with 2 indexes, and i need to replace only a few of the values, and commands such as "replace into 'table' where indexA = blah and indexB= blahblah values val1, val2, val3", just keep giving errors, i hope i explained that clearly enough and if anyone knows, thanks in advance.

jbb
01-03-2005, 12:47 AM
update TABLENAME set COLUMN = VALUE where CONDITION
is probably what you want

Branks
01-03-2005, 01:13 AM
omg, thank you! that was just simple enough to confuse me for hours! =/