507
507
Warning 1101 BLOB/TEXT column 'imagem' can't have a default value
508
508
insert into t1 (id) values (1);
510
charset(load_file('../std_data_ln/words.dat')),
511
collation(load_file('../std_data_ln/words.dat')),
512
coercibility(load_file('../std_data_ln/words.dat'));
513
charset(load_file('../std_data_ln/words.dat')) collation(load_file('../std_data_ln/words.dat')) coercibility(load_file('../std_data_ln/words.dat'))
510
charset(load_file('../../std_data/words.dat')),
511
collation(load_file('../../std_data/words.dat')),
512
coercibility(load_file('../../std_data/words.dat'));
513
charset(load_file('../../std_data/words.dat')) collation(load_file('../../std_data/words.dat')) coercibility(load_file('../../std_data/words.dat'))
515
515
explain extended select
516
charset(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat')),
517
collation(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat')),
518
coercibility(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat'));
516
charset(load_file('MYSQLTEST_VARDIR/std_data/words.dat')),
517
collation(load_file('MYSQLTEST_VARDIR/std_data/words.dat')),
518
coercibility(load_file('MYSQLTEST_VARDIR/std_data/words.dat'));
519
519
id select_type table type possible_keys key key_len ref rows filtered Extra
520
520
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
522
Note 1003 select charset(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat')) AS `charset(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat'))`,collation(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat')) AS `collation(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat'))`,coercibility(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat')) AS `coercibility(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat'))`
523
update t1 set imagem=load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat') where id=1;
522
Note 1003 select charset(load_file('MYSQLTEST_VARDIR/std_data/words.dat')) AS `charset(load_file('MYSQLTEST_VARDIR/std_data/words.dat'))`,collation(load_file('MYSQLTEST_VARDIR/std_data/words.dat')) AS `collation(load_file('MYSQLTEST_VARDIR/std_data/words.dat'))`,coercibility(load_file('MYSQLTEST_VARDIR/std_data/words.dat')) AS `coercibility(load_file('MYSQLTEST_VARDIR/std_data/words.dat'))`
523
update t1 set imagem=load_file('MYSQLTEST_VARDIR/std_data/words.dat') where id=1;
524
524
select if(imagem is null, "ERROR", "OK"),length(imagem) from t1 where id = 1;
525
525
if(imagem is null, "ERROR", "OK") length(imagem)
528
create table t1 select load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat') l;
528
create table t1 select load_file('MYSQLTEST_VARDIR/std_data/words.dat') l;
529
529
show full fields from t1;
530
530
Field Type Collation Null Key Default Extra Privileges Comment
531
531
l longblob NULL YES NULL #
891
891
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2))' at line 1
892
892
CREATE TABLE b15776 (a timestamp(4294967294));
894
Warning 1287 The syntax 'TIMESTAMP(4294967294)' is deprecated and will be removed in MySQL 5.2. Please use 'TIMESTAMP' instead
894
Warning 1287 The syntax 'TIMESTAMP(4294967294)' is deprecated and will be removed in MySQL 6.0. Please use 'TIMESTAMP' instead
895
895
DROP TABLE b15776;
896
896
CREATE TABLE b15776 (a timestamp(4294967295));
898
Warning 1287 The syntax 'TIMESTAMP(4294967295)' is deprecated and will be removed in MySQL 5.2. Please use 'TIMESTAMP' instead
898
Warning 1287 The syntax 'TIMESTAMP(4294967295)' is deprecated and will be removed in MySQL 6.0. Please use 'TIMESTAMP' instead
899
899
DROP TABLE b15776;
900
900
CREATE TABLE b15776 (a timestamp(4294967296));
901
901
ERROR 42000: Display width out of range for column 'a' (max = 4294967295)