MySQL :: Re: Select table within a table and update column based on initials and surname

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: Select table within a table and update column based on initials and surname

Posted by: Peter Brawley
Date: May 30, 2018 07:47AM

Those look like Describe results. Let's see Show Create Table results.

> update newCustomerID with CustomerID in the services copy table

You failed to specify row-matching criteria.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Select table within a table and update column based on initials and surname

John Biddulph

May 29, 2018 05:36PM

Re: Select table within a table and update column based on initials and surname

Peter Brawley

May 29, 2018 05:58PM

Re: Select table within a table and update column based on initials and surname

John Biddulph

May 30, 2018 02:37AM

Re: Select table within a table and update column based on initials and surname

Peter Brawley

May 30, 2018 07:47AM

Re: Select table within a table and update column based on initials and surname

John Biddulph

May 30, 2018 08:38AM

Re: Select table within a table and update column based on initials and surname

John Biddulph

May 30, 2018 08:54AM

Re: Select table within a table and update column based on initials and surname

Peter Brawley

May 30, 2018 01:58PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.