CREATE SPACE IF NOT EXISTS myspace
CREATE MODEL IF NOT EXISTS myspace.mymodel(
username: string,
password: string,
notes: [string],
null profile_pic: binary,
)
USE myspace
INSERT INTO mymodel {
username: "sayan",
pass: "pass123",
notes: ["this is my first note"],
profile_pic: null,
}
SELECT ALL * FROM mymodel LIMIT 100
SELECT password, notes FROM mymodel WHERE username = 'sayan'
UPDATE mymodel SET notes += "my new note" WHERE username = 'sayan'
ALTER MODEL myspace.mymodel ADD phone_number {
nullable: true,
type: uint8
}