Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
PosgresSQL Sandbox: Legitimate Resale
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
--PostgreSQL 9.5 --'\\' is a delimiter CREATE TABLE legitimate_resale(UPC INTEGER, item VARCHAR, in_stock INTEGER, price INTEGER, ship_day DATE, hazard_class VARCHAR)\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (101, 'generator', 16, 5999, '12-1-2065', 'neutral')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (102, 'mini generator', 25, 3000, '12-1-2065', 'neutral')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (991, 'toy robot', 1, 99000, '12-28-2065', 'banned')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (204, 'blank tape', 93, 5999, '12-31-2065', 'neutral')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (303, 'irradiator', 4, 3000, '1-2-2066', 'restricted')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (321, 'irradiator gamma', 1, 99000, '12-25-2065', 'banned')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (201, 'A WasteLand Pocket Guide', 2, 5999, '12-28-2065', 'neutral')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (301, 'gas mask', 17, 3000, '12-19-2065', 'neutral')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (212, 'fingerprinting kit', 1, 99000, '12-4-2065', 'neutral')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (401, 'guppy', 31, 100, '12-16-2065', 'neutral')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (405, 'mutant guppy', 3, 1000, '12-6-2065', 'restricted')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (404, 'guppy food', 28, 299, '12-6-2065', 'neutral')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (107, 'powdered rations', 56, 1349, '1-3-2066', 'restricted')\\ INSERT INTO legitimate_resale (UPC, item, in_stock, price, ship_day, hazard_class) VALUES (999, 'extra life', 1, 10000, '1-6-2066', 'neutral')\\ SELECT * from legitimate_resale\\
absolute service time: 0,43 sec
fork mode
|
history
|
discussion
upc
item
in_stock
price
ship_day
hazard_class
1
101
generator
16
5999
01.12.2065 00:00:00
neutral
2
102
mini generator
25
3000
01.12.2065 00:00:00
neutral
3
991
toy robot
1
99000
28.12.2065 00:00:00
banned
4
204
blank tape
93
5999
31.12.2065 00:00:00
neutral
5
303
irradiator
4
3000
02.01.2066 00:00:00
restricted
6
321
irradiator gamma
1
99000
25.12.2065 00:00:00
banned
7
201
A WasteLand Pocket Guide
2
5999
28.12.2065 00:00:00
neutral
8
301
gas mask
17
3000
19.12.2065 00:00:00
neutral
9
212
fingerprinting kit
1
99000
04.12.2065 00:00:00
neutral
10
401
guppy
31
100
16.12.2065 00:00:00
neutral
11
405
mutant guppy
3
1000
06.12.2065 00:00:00
restricted
12
404
guppy food
28
299
06.12.2065 00:00:00
neutral
13
107
powdered rations
56
1349
03.01.2066 00:00:00
restricted
14
999
extra life
1
10000
06.01.2066 00:00:00
neutral