File: simple-db.sql

package info (click to toggle)
lnav 0.7.0-3
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 2,808 kB
  • ctags: 3,343
  • sloc: cpp: 24,027; sh: 4,750; ansic: 4,541; makefile: 446; python: 165; sql: 56
file content (12 lines) | stat: -rw-r--r-- 305 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
 

CREATE TABLE IF NOT EXISTS  person (
    id integer PRIMARY KEY,
    first_name text,
    last_name text,
    age integer
);

INSERT INTO person (id, first_name, last_name, age)
    VALUES (0, "Phil", "Myman", 30);
INSERT INTO person (id, first_name, last_name, age)
    VALUES (1, "Lem", "Hewitt", 35);