Sign in
apache
/
phoenix
/
0031e5e6de6518c1c016b39c4a6e527f384a2808
/
.
/
examples
/
STOCK_SYMBOL.sql
blob: 3a1a05ec292a744b0cafb5316cd8231f6375048d [
file
] [
log
] [
blame
]
-- creates stock table with single row
CREATE
TABLE
IF
NOT
EXISTS
STOCK_SYMBOL
(
SYMBOL VARCHAR
NOT
NULL
PRIMARY
KEY
,
COMPANY VARCHAR
);
UPSERT
INTO
STOCK_SYMBOL
VALUES
(
'CRM'
,
'SalesForce.com'
);
SELECT
*
FROM
STOCK_SYMBOL
;