242
242
INSERT INTO t1 VALUES ('hello', 'hello');
243
243
INSERT INTO t1 VALUES ('he', 'he');
244
244
INSERT INTO t1 VALUES ('hello ', 'hello ');
246
Note 1265 Data truncated for column 'col1' at row 1
245
ERROR 22001: Data too long for column 'col1' at row 1
247
246
INSERT INTO t1 (col1) VALUES ('hellobob');
248
247
ERROR 22001: Data too long for column 'col1' at row 1
249
248
INSERT INTO t1 (col2) VALUES ('hellobob');
250
249
ERROR 22001: Data too long for column 'col2' at row 1
251
250
INSERT INTO t1 (col2) VALUES ('hello ');
253
Note 1265 Data truncated for column 'col2' at row 1
251
ERROR 22001: Data too long for column 'col2' at row 1
254
252
UPDATE t1 SET col1 ='hellobob' WHERE col1 ='he';
255
253
ERROR 22001: Data too long for column 'col1' at row 2
256
254
UPDATE t1 SET col2 ='hellobob' WHERE col2 ='he';
257
255
ERROR 22001: Data too long for column 'col2' at row 2
258
256
INSERT IGNORE INTO t1 VALUES ('hellobob', 'hellobob');
260
Warning 1265 Data truncated for column 'col1' at row 1
261
Warning 1265 Data truncated for column 'col2' at row 1
258
Error 1406 Data too long for column 'col1' at row 1
259
Error 1406 Data too long for column 'col2' at row 1
262
260
UPDATE IGNORE t1 SET col2 ='hellotrudy' WHERE col2 ='he';
264
Warning 1265 Data truncated for column 'col2' at row 2
262
Error 1406 Data too long for column 'col2' at row 2
265
263
SELECT * FROM t1;
273
269
CREATE TABLE t1 (col1 enum('red','blue','green'));