Debian Codegraph @

mysql-test/suite/x/r/delete_del_table.result

raw
1 create schema xtest;
2 RUN use xtest
3
4 0 rows affected
5 RUN create table mytable (id int primary key, name varchar(40), price decimal(5,2), info json)
6
7 0 rows affected
8 RUN insert into mytable values (1, 'banana', 1.20, '{"color": "yellow"}')
9
10 1 rows affected
11 RUN insert into mytable values (2, 'apple', 0.25, '{"color":"red"}')
12
13 1 rows affected
14 RUN insert into mytable values (3, 'tomato', 1.80, '{"color":"red"}')
15
16 1 rows affected
17 RUN insert into mytable values (4, 'mango', 3.14, '{"color":"green"}')
18
19 1 rows affected
20 RUN insert into mytable values (5, 'orange', 0.90, '{"color":"orange"}')
21
22 1 rows affected
23 send Mysqlx.Crud.Delete {
24 collection {
25 name: "mytable"
26 schema: "xtest"
27 }
28 data_model: TABLE
29 criteria {
30 type: OPERATOR
31 operator {
32 name: "=="
33 param {
34 type: IDENT
35 identifier {
36 name: "name"
37 }
38 }
39 param {
40 type: LITERAL
41 literal {
42 type: V_OCTETS
43 v_octets {
44 value: "banana"
45 }
46 }
47 }
48 }
49 }
50 }
51
52
53 1 rows affected
54 Mysqlx.Ok {
55 msg: "bye!"
56 }
57 ok