7 lines
356 B
Plaintext
7 lines
356 B
Plaintext
# Create a table to associate a key with 0 or more values
|
|
CREATE TABLE associative_array (KEY_COLUMN VARCHAR(10), VALUE_COLUMN VARCHAR(100));
|
|
# Insert a Key Value pair
|
|
INSERT INTO associative_array (KEY_COLUMN, VALUE_COLUMN) VALUES ('KEY', 'VALUE');
|
|
# Retrieve a key value pair
|
|
SELECT aa.value_column FROM associative_array aa where aa.key_column = 'KEY';
|