syntax error on insert

• CodeCaptain

  SSC Enthusiast

  Points: 173

  More actions

  May 29, 2020 at 12:28 am

  #3758326

  Hi, I am brand new to SQL.  I'm using postgres with PopSQL interface.

  I am trying to run the following basic code from a tutorial but it gives me a Failed Error:

  syntax error at or near "INSERT"

   

  Here is the code:

  CREATE TABLE people (

  id INT,

  name VARCHAR(255),

  PRIMARY KEY(id)

  )

  INSERT INTO people VALUES (1, 'Corey');

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  May 29, 2020 at 2:36 am

  #3758339

  This is a SQL Server forum but...Add a semicolon at the end of the closing parenthesis from the create table -

  CREATE TABLE people (
  
  id INT,
  
  name VARCHAR(255),
  
  PRIMARY KEY(id)
  
  );
  
  INSERT INTO people VALUES (1, 'Corey');

  Sue

   

• CodeCaptain

  SSC Enthusiast

  Points: 173

  More actions

  May 29, 2020 at 7:41 pm

  #3758790

  Thank-you so much!  you fixed the issue!