On Thu, Oct 29, 2020 at 9:37 AM Rich Shepard <rshep...@appl-ecosys.com> wrote:
> On Thu, 29 Oct 2020, David G. Johnston wrote: > > > That said seeing the first few rows, in addition to the last few, would > > help. > > David, > > insert into organizations > (org_nbr,org_name,org_url,org_email,industry,status,comment) values > (1,'Tidewater Contractors Inc',null,null,'Mining','Opportunity','GEN12A'), > (2,'All Rock LLC','www.allrockllc.com > ',null,'Mining','Opportunity','GEN12A'), > ... > > As your general syntax seems correct I would suspect an issue in the data values - like having a single quote in an organization name that isn't properly escaped (doubled). I'd first make sure insert one record works then begin bisecting your values, only inserting subsets at a time, until you narrow down the offending record. David J.
