query help, I thought this would be simple but I cant get it.

doctorbombay · #1 (**permalink**) 08-19-04, 15:01

Well, Im no guru but I thought I could do this but cant, help please.

For a selection of records in a table, ie; where author_name='john'

I want to take the numeric data in a certain field ie; field is named topic_id

and copy that data into another field in the same record ie; field is named attach_file

thanks in advance

Pat Phelan · #2 (**permalink**) 08-20-04, 01:01

You probably need the Cast() function.

-PatP

r937 · #3 (**permalink**) 08-20-04, 09:33

Code:

update yourtable
   set attach_file = topic_id 
 where author_name='john'

Pat Phelan · #4 (**permalink**) 08-20-04, 09:34

Does MySQL do an implict cast between numeric and string?!?!

-PatP

r937 · #5 (**permalink**) 08-20-04, 09:49

mysql will do an implicit cast to anything depending on context

(one of the reasons it is so cuddly)

in this particular case, there is no evidence that the other field is a string

attach_file could be numeric, no?

but to answer your question, yes, it's implicit

Internet Services

Web Development

Digital Marketing

Consumer Tech