English > Support

SQL statement (moving field contents)

(1/1)

skittle:
Hi everybody,

I want to do following:

Take the information of movies field A and move it to the custom field B for every single movie I have in my database.

What I am thinking of is writing a short SQL like following:

UPDATE customfields_table C SET C.mycustomfield=(SELECT M.release FROM movies M);

The question is how to find out the right column and table names of the custom field (marked red)? Or is there an out-fo-the-box way to do what I am attempting to?

rick.ca:

--- Quote ---The question is how to find out the right column and table names of the custom field (marked red)?
--- End quote ---

Assuming you understand SQL and know how to use the SQL tool (on the Help menu when the program is started with the -debug switch), you could get those using an SQL query tool like FlySpeed SQL Query.


--- Quote ---Or is there an out-fo-the-box way to do what I am attempting to?
--- End quote ---

Not exactly "out-of-the-box," but you could export [A] with [Title], [Year] and/or [ID] (to match records) and import the A data to [B].

Navigation

[0] Message Index