Entering data into a table

Question

There are 3 tables:

Vigruzka User_Name0 Name0 DisplayName0 Publisher0 LastW Anna.CM Anna Skype Microsoft 2.0.9 ... rows 700 Users Id_users User_Name0 Name0 1 Anna.CM Anna ... rows 3 Programs Id_programs DisplayName0 Publisher0 1 Skype Microsoft ... rows 300

Primary keys are set.

It is necessary to create the Updates table with connections in order to do this:

 Updates Id_updates id_Users Id_programs LastW 1 1 1 2.0.9 ... rows 300

The number of entries in the tables is different (No duplicates) in Users 3, Programs 300, Vigruzka 700.

Alexander Muksimov Alexander Muksimov 1,237 one 9 18 · Accepted Answer · 2017-03-02T08:00:35

I do not have the opportunity to check the request now (syntax errors are possible), but here, IMHO, the starting point from where you can start:

 SELECT DISTINCT Users.Id_users as id_Users,Programs.Id_programs as Id_programs, Vigruzka.LastW as LastW FROM Programs, Vigruzka, Users where Programs.DisplayName0 = Vigruzka.DisplayName0 AND Vigruzka.Name0 = Users.Name0 INSERT INTO Updates

In this case, the Id_updates field should be made auto-increment. Naturally, all this implies the uniqueness of Programs.DisplayName0 and Users.Name0

Happened! slightly changed the code, but everything works, Thank you - Fedor

Entering data into a table

1 answer 1

More articles: