Debian Codegraph @

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

raw
1 CREATE SCHEMA xtest;
2 CREATE TABLE xtest.xtable (x INT AUTO_INCREMENT PRIMARY KEY, y VARCHAR(1) NOT NULL, z INT UNSIGNED UNIQUE);
3 INSERT INTO xtest.xtable VALUES (1,2,3);
4 CREATE TABLE xtest.ytable (a INT ZEROFILL, b TIMESTAMP, c FLOAT UNSIGNED, INDEX(a));
5 Warnings:
6 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
7 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
8 INSERT INTO xtest.ytable VALUES (1,'2015-02-15',3);
9 x y z
10 1 2 3
11 x:SINT: NOT_NULL PRIMARY_KEY AUTO_INCREMENT
12 y:BYTES: NOT_NULL
13 z:UINT: UNIQUE_KEY
14 command ok
15 a b c
16 1 2015-02-15 00:00:00 3
17 a:UINT: ZEROFILL MULTIPLE_KEY
18 b:DATETIME: TIMESTAMP
19 c:FLOAT: UNSIGNED
20 command ok
21 Mysqlx.Ok {
22 msg: "bye!"
23 }
24 ok