diff options
| author | mo khan <mo.khan@gmail.com> | 2019-12-30 16:30:43 -0700 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2019-12-30 16:30:43 -0700 |
| commit | 3f12cde2a878fa2be83c6b3242e00e83395e43d5 (patch) | |
| tree | ba790a45483bf368ab772416218d2f8535e8258e /labs | |
| parent | 601055ee1b0d1b283868e6a8be658eb2da72c01d (diff) | |
Use auto increment primary key
Diffstat (limited to 'labs')
| -rw-r--r-- | labs/1/run.sh | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/labs/1/run.sh b/labs/1/run.sh index 1cca564..30d8472 100644 --- a/labs/1/run.sh +++ b/labs/1/run.sh @@ -1,6 +1,6 @@ #!/bin/sh -./bin/console -c 'CREATE TABLE people (id integer, address varchar(20), phone_number varchar(15));' -./bin/console -c "INSERT INTO people values (10, '123 sesame street', '7803333222');" -./bin/console -c "INSERT INTO people values (11, '1 university drive', '7805555444');" +./bin/console -c 'CREATE TABLE people (id SERIAL, address VARCHAR(20), phone_number VARCHAR(15));' +./bin/console -c "INSERT INTO people (address, phone_number) values ('123 sesame street', '7803333222');" +./bin/console -c "INSERT INTO people (address, phone_number) values ('1 university drive', '7805555444');" ./bin/console -c "SELECT * FROM people;" |