-
Notifications
You must be signed in to change notification settings - Fork 26
Expand file tree
/
Copy pathmysql.sql
More file actions
230 lines (218 loc) · 58.5 KB
/
Copy pathmysql.sql
File metadata and controls
230 lines (218 loc) · 58.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
create database mydb;
use mydb;
CREATE TABLE my_table (
my_id BIGINT AUTO_INCREMENT PRIMARY KEY,
my_char CHAR(10),
my_varchar VARCHAR(255),
my_longtext LONGTEXT,
my_mediumtext MEDIUMTEXT,
my_text TEXT,
my_tinytext TINYTEXT,
my_enum ENUM('value1', 'value2'),
my_unsigned_bigint BIGINT UNSIGNED,
my_bigint BIGINT,
my_unsigned_int INT UNSIGNED,
my_int INT,
my_unsigned_mediumint MEDIUMINT UNSIGNED,
my_mediumint MEDIUMINT,
my_unsigned_smallint SMALLINT UNSIGNED,
my_smallint SMALLINT,
my_unsigned_tinyint TINYINT UNSIGNED,
my_tinyint TINYINT,
my_double DOUBLE,
my_float FLOAT,
my_decimal DECIMAL(18, 5),
my_datetime DATETIME(6),
my_timestamp TIMESTAMP(6),
my_date DATE,
my_time TIME(6),
my_year YEAR,
my_binary BINARY(50),
my_varbinary VARBINARY(255),
my_longblob LONGBLOB,
my_mediumblob MEDIUMBLOB,
my_blob BLOB,
my_tinyblob TINYBLOB,
my_geometry GEOMETRY,
my_bit BIT(25),
my_json JSON,
my_set SET('value1', 'value2'),
last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
DELIMITER //
CREATE PROCEDURE InsertDataMultipleTimes()
BEGIN
DECLARE i INT DEFAULT 0;
WHILE i < 100 DO
INSERT INTO my_table (
my_char, my_varchar, my_longtext, my_mediumtext, my_text, my_tinytext,
my_enum, my_unsigned_bigint, my_bigint, my_unsigned_int, my_int,
my_unsigned_mediumint, my_mediumint, my_unsigned_smallint, my_smallint,
my_unsigned_tinyint, my_tinyint, my_double, my_float, my_decimal,
my_datetime, my_timestamp, my_date, my_time, my_year, my_binary,
my_varbinary, my_longblob, my_mediumblob, my_blob, my_tinyblob, my_geometry,
my_bit, my_json, my_set
)
VALUES
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'0001111111', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'0011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1'),
('abc', 'abc', 'This "is" a test', 'This is a test', 'This is a test', 'Test', 'value1', 123456789012345678, 123456789012345678, 12345678, 12345678, 1234567, 1234567, 12345, 12345, 123, 123, 1.23456789012345678, 1.2345678, 123.456, '2023-07-22 12:34:56.765432', '2023-07-22 12:34:56.765432', '2023-07-22', '12:34:56.765432', 2023, 0b110011, 0b110011, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, 0x89504E470D0A1A0A, ST_GeomFromText('POINT(1 1)'), b'1011001101', '{"key": "value"}', 'value1');
SET i = i + 1;
END WHILE;
END //
DELIMITER ;
-- Call the procedure
CALL InsertDataMultipleTimes();
-- Optionally, you can drop the procedure afterwards
DROP PROCEDURE IF EXISTS InsertDataMultipleTimes;
-- Insert a row with all NULLs
INSERT INTO my_table (
my_char, my_varchar, my_longtext, my_mediumtext, my_text, my_tinytext,
my_enum, my_unsigned_bigint, my_bigint, my_unsigned_int, my_int,
my_unsigned_mediumint, my_mediumint, my_unsigned_smallint, my_smallint,
my_unsigned_tinyint, my_tinyint, my_double, my_float, my_decimal,
my_datetime, my_timestamp, my_date, my_time, my_year, my_binary,
my_varbinary, my_longblob, my_mediumblob, my_blob, my_tinyblob, my_geometry,
my_bit, my_json, my_set
)
VALUES (
NULL, 'one not null', NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL
);
-- {name:my_char databaseType:CHAR scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_varchar databaseType:VARCHAR scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_longtext databaseType:TEXT scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_mediumtext databaseType:TEXT scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_text databaseType:TEXT scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_tinytext databaseType:TEXT scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_enum databaseType:CHAR scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_unsigned_bigint databaseType:UNSIGNED BIGINT scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_bigint databaseType:BIGINT scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_unsigned_int databaseType:UNSIGNED INT scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_int databaseType:INT scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_unsigned_mediumint databaseType:MEDIUMINT scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_mediumint databaseType:MEDIUMINT scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_unsigned_smallint databaseType:UNSIGNED SMALLINT scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_smallint databaseType:SMALLINT scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_unsigned_tinyint databaseType:UNSIGNED TINYINT scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_tinyint databaseType:TINYINT scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_double databaseType:DOUBLE scanType:sql.NullFloat64 decimalOk:true precision:9223372036854775807 scale:9223372036854775807 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_float databaseType:FLOAT scanType:sql.NullFloat64 decimalOk:true precision:9223372036854775807 scale:9223372036854775807 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_decimal databaseType:DECIMAL scanType:sql.RawBytes decimalOk:true precision:18 scale:5 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_datetime databaseType:DATETIME scanType:sql.NullTime decimalOk:true precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_timestamp databaseType:TIMESTAMP scanType:sql.NullTime decimalOk:true precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_date databaseType:DATE scanType:sql.NullTime decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_time databaseType:TIME scanType:sql.RawBytes decimalOk:true precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_year databaseType:YEAR scanType:sql.NullInt64 decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_binary databaseType:BINARY scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_varbinary databaseType:VARBINARY scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_longblob databaseType:BLOB scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_mediumblob databaseType:BLOB scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_blob databaseType:BLOB scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_tinyblob databaseType:BLOB scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_geometry databaseType:GEOMETRY scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_bit databaseType:BIT scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_json databaseType:JSON scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}
-- {name:my_set databaseType:CHAR scanType:sql.RawBytes decimalOk:false precision:0 scale:0 lengthOk:false length:0 nullableOk:true nullable:true}