Create a table in the database
CREATE TABLE main.xkota (
VARCHAR,
xkotaId VARCHAR); xkotaName
Add records to the database
INSERT INTO main.xkota (xkotaId,xkotaName)
VALUES ('xk1000','fictional name');
Query the database
SELECT * FROM main.xkota;
xkotaId | xkotaName |
---|---|
xk1000 | fictional name |
A more complete example of relational dbms