There are two tables that unrelated. I want to update a field in first table with data that selected from second table in some order. There is no relations between tables, fields and data.
I have just errors from my try outs.
PS: Using MySQL.
Mysql – How to update a column in a table with data from another, unrelated tables columns data jus in order it selected
MySQLupdate
Related Question
- Ms-access – Updating one table from another table where non-primary-key field is similar string
- Mysql – How to update a (very) large table without locking in MySQL
- Update data of one table from another with comparing columns have same initial strings
- Mysql – SELECT Dynamic columns with values from other table
- Mysql update table from another table with condition
Best Answer
Create a column in each table that you can update with a sequence. Then you have something to join on.