mysql - Update statement with inner join doesn't update -


I need to break into a table 2. The table will have one-to-many relationship with the other.

These hold credits for the table shows. More than one person can have the same role in the show, so I need a roll table, in which there will be multiple relationships with the names of artists (i.e. a group of all people where "residents" are played ).

Then, it will break:

credits_roles - The main table. Credits_names - Artists name (relationship is with id column in credits_roles).

Basically, it was structured in a table. Each line had a different artist and role. This site is causing problems with many questions and this break will make things easier.

I have transmitted data in credits_roll using the INSERT statement and group BY. I have now only unique roles in Credits_roles.

Where I'm having a problem is an UPDATE statement that will look at the ID in the credit_roles and it will be added to credit_name in the credits_roles_id column.

This is what I have. 

  Include credit_enames at UPDATE credits_names INNER credits_roles. Ro_id = credits_roles.role_id and credits_names.show_id = credits_roles.show_id and credits_names.credit_class = credits_roles.credit_class SET credits_names.credit_role_id = Credits_roles.id

credits_names is the original table and currently all data are After completion of this project, some of these will be removed. Right now, I'm going to join on the basis of the role ID (because "townspeople" will get their roles from a different roles table), the show is that they are for credit, and then there is a credit-class (For the artist versus the crew, or in the CA vs. CR table), all these need to be matched to see credit -_rolls.Id.

The problem is that the query is running ... and running ... and running. I run it overnight and it never ends. Credits_Names have 300,000 records but when I stop the query, no updates have been made.

So, my question is, what will I have to change in this question? It looks like a simple update but it's not doing anything or, if this is not a query, then what do I need to do instead?


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more