Previous Next JavaScript must be enabled to correctly display this content

## SQLBasicExamples Script

The script `SQLBasicExamples` creates the following table:

    CREATE TABLE Users (
      id integer,
      firstname string,
      lastname string,
      age integer,
      income integer,
      primary key (id)
    );

The script also load data into the Users table with the following rows (shown here in JSON format):

    {
      "id":1,
      "firstname":"David",
      "lastname":"Morrison",
      "age":25,
      "income":100000,
    }

    {
      "id":2,
      "firstname":"John",
      "lastname":"Anderson",
      "age":35,
      "income":100000,
    }

    {
      "id":3,
      "firstname":"John",
      "lastname":"Morgan",
      "age":38,
      "income":null,
    }

    {
      "id":4,
      "firstname":"Peter",
      "lastname":"Smith",
      "age":38,
      "income":80000,
    }

    {
      "id":5,
      "firstname":"Dana",
      "lastname":"Scully",
      "age":47,
      "income":400000,
    }

You run the SQLBasicExamples script using the load command:

    > cd <installdir>/examples/sql
    > java -jar <KVHOME>/lib/sql.jar -helper-hosts <host>:<port> \
    -store <storename> load \
    -file <KVHOME>/examples/sql/SQLBasicExamples.cli