Skip to content

Instantly share code, notes, and snippets.

@dasl-
Created September 25, 2019 22:01
Show Gist options
  • Save dasl-/70e8fb019e4a2d9b88c61644a39b5a90 to your computer and use it in GitHub Desktop.
Save dasl-/70e8fb019e4a2d9b88c61644a39b5a90 to your computer and use it in GitHub Desktop.
Length: 1
"insert into shop_data(shop_id, k, v) values (:vtg1, :vtg2, :vtg3)"
{
"PlanID": "INSERT_PK",
"Reason": "DEFAULT",
"Table": {
"Name": "shop_data",
"Columns": [
{
"Name": "shop_id",
"Type": 778,
"IsAuto": false,
"Default": null
},
{
"Name": "k",
"Type": 6165,
"IsAuto": false,
"Default": null
},
{
"Name": "v",
"Type": 6165,
"IsAuto": false,
"Default": null
}
],
"Indexes": [
{
"Name": "PRIMARY",
"Unique": true,
"Columns": [
"shop_id",
"k"
],
"Cardinality": [
1,
2
]
}
],
"PKColumns": [
0,
1
],
"Type": 0,
"SequenceInfo": null,
"MessageInfo": null,
"TopicInfo": null,
"TableRows": {},
"DataLength": {},
"IndexLength": {},
"DataFree": {},
"MaxDataLength": {}
},
"NewName": "",
"Permissions": [
{
"TableName": "shop_data",
"Role": 1
}
],
"FieldQuery": null,
"FullQuery": "insert into shop_data(shop_id, k, v) values (:vtg1, :vtg2, :vtg3)",
"OuterQuery": "insert into shop_data(shop_id, k, v) values (:vtg1, :vtg2, :vtg3)",
"Subquery": null,
"UpsertQuery": null,
"ColumnNumbers": null,
"PKValues": [
[
":vtg1"
],
[
":vtg2"
]
],
"SecondaryPKValues": null,
"WhereClause": null,
"SubqueryPKColumns": null
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment