· 9 years ago · Oct 20, 2016, 06:28 PM
1# SQL INFO:
2# EVENTS:
3# Lave en table:
4# update "CREATE TABLE table (colonne VARCHAR(250) NOT NULL PRIMARY KEY, colonne2 INTEGER NOT NULL)"
5# update "CREATE TABLE IF NOT EXISTS table (colonne VARCHAR(250) NOT NULL PRIMARY KEY, colonne2 INTEGER NOT NULL)"
6# Indsætte noget i en table:
7# update "INSERT INTO table (colonne, colonne2) VALUES ('data1','2')"
8# Ændre noget i en table:
9# update "UPDATE table SET colonne2='3' WHERE colonne='data1'"
10# Slette noget i en table:
11# update "DELETE FROM table WHERE colonne='data1'"
12# INFO:
13# Få ét stk. info:
14# set {_query} to the first element out of objects in column "colonne2" from result of query "SELECT colonne2 FROM table WHERE colonne='data1'" and close
15# FÃ¥ en liste med info:
16# add objects in column "colonne" from result of query "SELECT colonne FROM table" and close to {_query::*}