Phriction Knowledge Center - Hexavara Technology Crema Framework Crema Query Language : Getting Started Create History Version 1 vs 2
Version 1 vs 2
Version 1 vs 2
Content Changes
Content Changes
**1. Create Record**
Standard insert query
```
INSERT INTO users(email,name) VALUES('email@to.me' ,'My Name')
```
translated using Crema QL
```
tableName = "users"
col[0] = "email"
col[1] = "name"
val[0] = "email@to.me"
val[1] = "My Name"
q := crema.Insert(tableName).Columns(col).Values(val)
```
to execute the insertion
```
crema.ExecuteQueryRow(tx, q.QueryString)
```
**Create Record**
Standard insert query
```
INSERT INTO users(email,name) VALUES('email@to.me' ,'My Name')
```
translated using Crema QL
```
tableName = "users"
col[0] = "email"
col[1] = "name"
val[0] = "email@to.me"
val[1] = "My Name"
q := crema.Insert(tableName).Columns(col).Values(val)
```
to execute the insertion
```
crema.ExecuteQueryRow(tx, q.QueryString)
```
**1. Create Record**
Standard insert query
```
INSERT INTO users(email,name) VALUES('email@to.me' ,'My Name')
```
translated using Crema QL
```
tableName = "users"
col[0] = "email"
col[1] = "name"
val[0] = "email@to.me"
val[1] = "My Name"
q := crema.Insert(tableName).Columns(col).Values(val)
```
to execute the insertion
```
crema.ExecuteQueryRow(tx, q.QueryString)
```