Insert in Relational Database?

Sorry for the late reply. Actually first table is like a lookuptable and from the value of os given in that table I want to fetch the id and then use that id in INSERT query for the second table. Simply fetching the corresponding id and then using it is not working.

Neither it is showing an error nor it is inserting. So I would like to know the appropriate syntax for this INSERT query.

Assuming you want a new table that looks like this: uid, name, hdd, ram, id, os and id refers to the OS id, What I would do first is add the os field to your second table. Then run a SQL query to copy the values of the os field over from the first table. I don't know how standard the SQL is in MySQL, so I'm just going to use standard SQL.

UPDATE Table1 INNER JOIN Table2 ON Table1. Id = Table2. Id SET Table1.

Os = table2.os.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions