~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT

386

NULL test t1 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references

387

NULL test t1 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

388

NULL test t1 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references

389

NULL test t1 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

390

NULL test t1 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

391

NULL test t1 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

392

NULL test t10 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references

393

NULL test t10 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

394

NULL test t10 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references

395

NULL test t10 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

396

NULL test t10 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

397

NULL test t10 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

398

NULL test t11 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references

399

NULL test t11 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

400

NULL test t11 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references

401

NULL test t11 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

402

NULL test t11 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

403

NULL test t11 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

404

NULL test t2 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references

405

NULL test t2 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

406

NULL test t2 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references

407

NULL test t2 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

408

NULL test t2 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

409

NULL test t2 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

410

NULL test t3 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references

411

NULL test t3 f2 2 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references

412

NULL test t3 f3 3 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

413

NULL test t4 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references

414

NULL test t4 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

415

NULL test t4 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references

416

NULL test t4 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

417

NULL test t4 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

418

NULL test t4 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

419

NULL test t7 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references

420

NULL test t7 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

421

NULL test t7 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references

422

NULL test t7 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

423

NULL test t8 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references

424

NULL test t8 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

425

NULL test t8 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references

426

NULL test t8 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

427

NULL test t9 f1 1 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

428

NULL test t9 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

429

NULL test t9 f3 3 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

430

NULL test tb1 f1 1 NULL YES char 0 0 NULL NULL latin1 latin1_swedish_ci char(0) select,insert,update,references

431

NULL test tb1 f10 10 NULL YES mediumblob 16777215 16777215 NULL NULL NULL NULL mediumblob select,insert,update,references

432

NULL test tb1 f11 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL longblob select,insert,update,references

433

NULL test tb1 f12 12 NULL YES binary 1 1 NULL NULL NULL NULL binary(1) select,insert,update,references

434

NULL test tb1 f13 13 NULL YES tinyint NULL NULL 3 0 NULL NULL tinyint(4) select,insert,update,references

435

NULL test tb1 f14 14 NULL YES tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned select,insert,update,references

436

NULL test tb1 f15 15 NULL YES tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned zerofill select,insert,update,references

437

NULL test tb1 f16 16 NULL YES tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned zerofill select,insert,update,references

438

NULL test tb1 f17 17 NULL YES smallint NULL NULL 5 0 NULL NULL smallint(6) select,insert,update,references

439

NULL test tb1 f18 18 NULL YES smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned select,insert,update,references

440

NULL test tb1 f19 19 NULL YES smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned zerofill select,insert,update,references

441

NULL test tb1 f2 2 NULL YES char 0 0 NULL NULL latin1 latin1_bin char(0) select,insert,update,references

442

NULL test tb1 f20 20 NULL YES smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned zerofill select,insert,update,references

443

NULL test tb1 f21 21 NULL YES mediumint NULL NULL 7 0 NULL NULL mediumint(9) select,insert,update,references

444

NULL test tb1 f22 22 NULL YES mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned select,insert,update,references

445

NULL test tb1 f23 23 NULL YES mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned zerofill select,insert,update,references

446

NULL test tb1 f24 24 NULL YES mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned zerofill select,insert,update,references

447

NULL test tb1 f25 25 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

448

NULL test tb1 f26 26 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references

449

NULL test tb1 f27 27 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned zerofill select,insert,update,references

450

NULL test tb1 f28 28 NULL YES int NULL NULL 10 0 NULL NULL int(10) unsigned zerofill select,insert,update,references

451

NULL test tb1 f29 29 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references

452

NULL test tb1 f3 3 NULL YES char 0 0 NULL NULL latin1 latin1_swedish_ci char(0) select,insert,update,references

453

NULL test tb1 f30 30 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned select,insert,update,references

454

NULL test tb1 f31 31 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned zerofill select,insert,update,references

455

NULL test tb1 f32 32 NULL YES bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned zerofill select,insert,update,references

456

NULL test tb1 f33 33 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

457

NULL test tb1 f34 34 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

458

NULL test tb1 f35 35 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

459

NULL test tb1 f36 36 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

460

NULL test tb1 f37 37 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

461

NULL test tb1 f38 38 10 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) select,insert,update,references

462

NULL test tb1 f39 39 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

463

NULL test tb1 f4 4 NULL YES tinytext 255 255 NULL NULL latin1 latin1_swedish_ci tinytext select,insert,update,references

464

NULL test tb1 f40 40 10 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned select,insert,update,references

465

NULL test tb1 f41 41 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

466

NULL test tb1 f42 42 0000000000000000000000000000000000000000000000000000000000000010 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references

467

NULL test tb1 f43 43 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

468

NULL test tb1 f44 44 0000000000000000000000000000000000000000000000000000000000000010 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references

469

NULL test tb1 f45 45 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

470

NULL test tb1 f46 46 9.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) select,insert,update,references

471

NULL test tb1 f47 47 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

472

NULL test tb1 f48 48 9.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned select,insert,update,references

473

NULL test tb1 f49 49 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

474

NULL test tb1 f5 5 NULL YES text 65535 65535 NULL NULL latin1 latin1_swedish_ci text select,insert,update,references

475

NULL test tb1 f50 50 000000000000000000000000000000009.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references

476

NULL test tb1 f51 51 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

477

NULL test tb1 f52 52 000000000000000000000000000000009.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references

478

NULL test tb1 f53 53 99 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

479

NULL test tb1 f54 54 99 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

480

NULL test tb1 f55 55 0000000099 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

481

NULL test tb1 f56 56 0000000099 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

482

NULL test tb1 f57 57 99 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

483

NULL test tb1 f58 58 99 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) select,insert,update,references

484

NULL test tb1 f6 6 NULL YES mediumtext 16777215 16777215 NULL NULL latin1 latin1_swedish_ci mediumtext select,insert,update,references

485

NULL test tb1 f7 7 NULL YES longtext 4294967295 4294967295 NULL NULL latin1 latin1_swedish_ci longtext select,insert,update,references

486

NULL test tb1 f8 8 NULL YES tinyblob 255 255 NULL NULL NULL NULL tinyblob select,insert,update,references

487

NULL test tb1 f9 9 NULL YES blob 65535 65535 NULL NULL NULL NULL blob select,insert,update,references

488

NULL test tb2 f100 42 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

489

NULL test tb2 f101 43 2000-01-01 NO date NULL NULL NULL NULL NULL NULL date select,insert,update,references

490

NULL test tb2 f102 44 00:00:20 NO time NULL NULL NULL NULL NULL NULL time select,insert,update,references

491

NULL test tb2 f103 45 0002-02-02 00:00:00 NO datetime NULL NULL NULL NULL NULL NULL datetime select,insert,update,references

492

NULL test tb2 f104 46 2000-12-31 23:59:59 NO timestamp NULL NULL NULL NULL NULL NULL timestamp select,insert,update,references

493

NULL test tb2 f105 47 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references

494

NULL test tb2 f106 48 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references

495

NULL test tb2 f107 49 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references

496

NULL test tb2 f108 50 1enum NO enum 5 5 NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references

497

NULL test tb2 f109 51 1set NO set 9 9 NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references

498

NULL test tb2 f59 1 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

499

NULL test tb2 f60 2 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned select,insert,update,references

500

NULL test tb2 f61 3 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

501

NULL test tb2 f62 4 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references

502

NULL test tb2 f63 5 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

503

NULL test tb2 f64 6 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references

504

NULL test tb2 f65 7 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

505

NULL test tb2 f66 8 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) select,insert,update,references

506

NULL test tb2 f67 9 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

507

NULL test tb2 f68 10 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned select,insert,update,references

508

NULL test tb2 f69 11 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

509

NULL test tb2 f70 12 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references

510

NULL test tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

511

NULL test tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references

512

NULL test tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references

513

NULL test tb2 f74 16 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references

514

NULL test tb2 f75 17 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

515

NULL test tb2 f76 18 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

516

NULL test tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references

517

NULL test tb2 f78 20 7.7 YES double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references

518

NULL test tb2 f79 21 00000000000000000007.7 YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

519

NULL test tb2 f80 22 00000000000000000008.8 YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

520

NULL test tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references

521

NULL test tb2 f82 24 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

522

NULL test tb2 f83 25 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

523

NULL test tb2 f84 26 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

524

NULL test tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references

525

NULL test tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references

526

NULL test tb2 f87 29 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

527

NULL test tb2 f88 30 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

528

NULL test tb2 f89 31 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

529

NULL test tb2 f90 32 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

530

NULL test tb2 f91 33 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

531

NULL test tb2 f92 34 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

532

NULL test tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references

533

NULL test tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references

534

NULL test tb2 f95 37 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

535

NULL test tb2 f96 38 8.8 NO double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references

536

NULL test tb2 f97 39 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

537

NULL test tb2 f98 40 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

538

NULL test tb2 f99 41 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

539

NULL test tb3 f118 1 a NO char 1 1 NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references

540

NULL test tb3 f119 2 NO char 1 1 NULL NULL latin1 latin1_bin char(1) select,insert,update,references

541

NULL test tb3 f120 3 NO char 1 1 NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references

542

NULL test tb3 f121 4 NULL YES tinytext 255 255 NULL NULL latin1 latin1_swedish_ci tinytext select,insert,update,references

543

NULL test tb3 f122 5 NULL YES text 65535 65535 NULL NULL latin1 latin1_swedish_ci text select,insert,update,references

544

NULL test tb3 f123 6 NULL YES mediumtext 16777215 16777215 NULL NULL latin1 latin1_swedish_ci mediumtext select,insert,update,references

545

NULL test tb3 f124 7 NULL YES longtext 4294967295 4294967295 NULL NULL latin1 latin1_swedish_ci longtext select,insert,update,references

546

NULL test tb3 f125 8 NULL YES tinyblob 255 255 NULL NULL NULL NULL tinyblob select,insert,update,references

547

NULL test tb3 f126 9 NULL YES blob 65535 65535 NULL NULL NULL NULL blob select,insert,update,references

548

NULL test tb3 f127 10 NULL YES mediumblob 16777215 16777215 NULL NULL NULL NULL mediumblob select,insert,update,references

549

NULL test tb3 f128 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL longblob select,insert,update,references

550

NULL test tb3 f129 12 NO binary 1 1 NULL NULL NULL NULL binary(1) select,insert,update,references

551

NULL test tb3 f130 13 99 NO tinyint NULL NULL 3 0 NULL NULL tinyint(4) select,insert,update,references

552

NULL test tb3 f131 14 99 NO tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned select,insert,update,references

553

NULL test tb3 f132 15 099 NO tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned zerofill select,insert,update,references

554

NULL test tb3 f133 16 099 NO tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned zerofill select,insert,update,references

555

NULL test tb3 f134 17 999 NO smallint NULL NULL 5 0 NULL NULL smallint(6) select,insert,update,references

556

NULL test tb3 f135 18 999 NO smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned select,insert,update,references

557

NULL test tb3 f136 19 00999 NO smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned zerofill select,insert,update,references

558

NULL test tb3 f137 20 00999 NO smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned zerofill select,insert,update,references

559

NULL test tb3 f138 21 9999 NO mediumint NULL NULL 7 0 NULL NULL mediumint(9) select,insert,update,references

560

NULL test tb3 f139 22 9999 NO mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned select,insert,update,references

561

NULL test tb3 f140 23 00009999 NO mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned zerofill select,insert,update,references

562

NULL test tb3 f141 24 00009999 NO mediumint NULL NULL 7 0 NULL NULL mediumint(8) unsigned zerofill select,insert,update,references

563

NULL test tb3 f142 25 99999 NO int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

564

NULL test tb3 f143 26 99999 NO int NULL NULL 10 0 NULL NULL int(10) unsigned select,insert,update,references

565

NULL test tb3 f144 27 0000099999 NO int NULL NULL 10 0 NULL NULL int(10) unsigned zerofill select,insert,update,references

566

NULL test tb3 f145 28 0000099999 NO int NULL NULL 10 0 NULL NULL int(10) unsigned zerofill select,insert,update,references

567

NULL test tb3 f146 29 999999 NO bigint NULL NULL 19 0 NULL NULL bigint(20) select,insert,update,references

568

NULL test tb3 f147 30 999999 NO bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned select,insert,update,references

569

NULL test tb3 f148 31 00000000000000999999 NO bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned zerofill select,insert,update,references

570

NULL test tb3 f149 32 00000000000000999999 NO bigint NULL NULL 19 0 NULL NULL bigint(20) unsigned zerofill select,insert,update,references

571

NULL test tb3 f150 33 1000 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

572

NULL test tb3 f151 34 999 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

573

NULL test tb3 f152 35 0000001000 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

574

NULL test tb3 f153 36 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

575

NULL test tb3 f154 37 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

576

NULL test tb3 f155 38 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) select,insert,update,references

577

NULL test tb3 f156 39 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

578

NULL test tb3 f157 40 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned select,insert,update,references

579

NULL test tb3 f158 41 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

580

NULL test tb3 f159 42 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references

581

NULL test tb3 f160 43 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

582

NULL test tb3 f161 44 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references

583

NULL test tb3 f162 45 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

584

NULL test tb3 f163 46 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) select,insert,update,references

585

NULL test tb3 f164 47 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

586

NULL test tb3 f165 48 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned select,insert,update,references

587

NULL test tb3 f166 49 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

588

NULL test tb3 f167 50 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references

589

NULL test tb3 f168 51 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

590

NULL test tb3 f169 52 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references

591

NULL test tb3 f170 53 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

592

NULL test tb3 f171 54 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

593

NULL test tb3 f172 55 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

594

NULL test tb3 f173 56 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

595

NULL test tb3 f174 57 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

596

NULL test tb3 f175 58 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) select,insert,update,references

597

NULL test tb4 f176 1 9 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

598

NULL test tb4 f177 2 9 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned select,insert,update,references

599

NULL test tb4 f178 3 0000000009 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

600

NULL test tb4 f179 4 0000000000000000000000000000000000000000000000000000000000000009 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references

601

NULL test tb4 f180 5 0000000009 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

602

NULL test tb4 f181 6 0000000000000000000000000000000000000000000000000000000000000009 NO decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references

603

NULL test tb4 f182 7 9 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

604

NULL test tb4 f183 8 9.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) select,insert,update,references

605

NULL test tb4 f184 9 9 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

606

NULL test tb4 f185 10 9.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned select,insert,update,references

607

NULL test tb4 f186 11 0000000009 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

608

NULL test tb4 f187 12 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references

609

NULL test tb4 f188 13 0000000009 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

610

NULL test tb4 f189 14 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references

611

NULL test tb4 f190 15 88.8 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references

612

NULL test tb4 f191 16 88.8 NO double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references

613

NULL test tb4 f192 17 00000000000000000088.8 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

614

NULL test tb4 f193 18 00000000000000000088.8 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

615

NULL test tb4 f194 19 55.5 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references

616

NULL test tb4 f195 20 55.5 NO double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references

617

NULL test tb4 f196 21 00000000000000000055.5 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

618

NULL test tb4 f197 22 00000000000000000055.5 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

619

NULL test tb4 f198 23 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references

620

NULL test tb4 f199 24 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

621

NULL test tb4 f200 25 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

622

NULL test tb4 f201 26 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

623

NULL test tb4 f202 27 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references

624

NULL test tb4 f203 28 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references

625

NULL test tb4 f204 29 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

626

NULL test tb4 f205 30 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

627

NULL test tb4 f206 31 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

628

NULL test tb4 f207 32 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

629

NULL test tb4 f208 33 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

630

NULL test tb4 f209 34 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

631

NULL test tb4 f210 35 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references

632

NULL test tb4 f211 36 NULL YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references

633

NULL test tb4 f212 37 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

634

NULL test tb4 f213 38 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references

635

NULL test tb4 f214 39 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

636

NULL test tb4 f215 40 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

637

NULL test tb4 f216 41 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

638

NULL test tb4 f217 42 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

639

NULL test tb4 f218 43 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references

640

NULL test tb4 f219 44 NULL YES time NULL NULL NULL NULL NULL NULL time select,insert,update,references

641

NULL test tb4 f220 45 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select,insert,update,references

642

NULL test tb4 f221 46 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL NULL NULL timestamp on update CURRENT_TIMESTAMP select,insert,update,references

643

NULL test tb4 f222 47 NULL YES year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references

644

NULL test tb4 f223 48 NULL YES year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references

645

NULL test tb4 f224 49 NULL YES year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references

646

NULL test tb4 f225 50 NULL YES enum 5 5 NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references

647

NULL test tb4 f226 51 NULL YES set 9 9 NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references

648

NULL test tb4 f235 52 NULL YES char 0 0 NULL NULL latin1 latin1_swedish_ci char(0) select,insert,update,references

649

NULL test tb4 f236 53 NULL YES char 90 90 NULL NULL latin1 latin1_swedish_ci char(90) select,insert,update,references

650

NULL test tb4 f237 54 NULL YES char 255 255 NULL NULL latin1 latin1_swedish_ci char(255) select,insert,update,references

651

NULL test tb4 f238 55 NULL YES varchar 0 0 NULL NULL latin1 latin1_swedish_ci varchar(0) select,insert,update,references

652

NULL test tb4 f239 56 NULL YES varchar 20000 20000 NULL NULL latin1 latin1_bin varchar(20000) select,insert,update,references

653

NULL test tb4 f240 57 NULL YES varchar 2000 2000 NULL NULL latin1 latin1_swedish_ci varchar(2000) select,insert,update,references

654

NULL test tb4 f241 58 NULL YES char 100 100 NULL NULL latin1 latin1_swedish_ci char(100) select,insert,update,references

655

NULL test1 tb2 f100 42 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

656

NULL test1 tb2 f101 43 2000-01-01 NO date NULL NULL NULL NULL NULL NULL date select,insert,update,references

657

NULL test1 tb2 f102 44 00:00:20 NO time NULL NULL NULL NULL NULL NULL time select,insert,update,references

658

NULL test1 tb2 f103 45 0002-02-02 00:00:00 NO datetime NULL NULL NULL NULL NULL NULL datetime select,insert,update,references

659

NULL test1 tb2 f104 46 2000-12-31 23:59:59 NO timestamp NULL NULL NULL NULL NULL NULL timestamp select,insert,update,references

660

NULL test1 tb2 f105 47 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references

661

NULL test1 tb2 f106 48 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references

662

NULL test1 tb2 f107 49 2000 NO year NULL NULL NULL NULL NULL NULL year(4) select,insert,update,references

663

NULL test1 tb2 f108 50 1enum NO enum 5 5 NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references

664

NULL test1 tb2 f109 51 1set NO set 9 9 NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references

665

NULL test1 tb2 f59 1 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

666

NULL test1 tb2 f60 2 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned select,insert,update,references

667

NULL test1 tb2 f61 3 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

668

NULL test1 tb2 f62 4 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references

669

NULL test1 tb2 f63 5 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

670

NULL test1 tb2 f64 6 NULL YES decimal NULL NULL 64 0 NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references

671

NULL test1 tb2 f65 7 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references

672

NULL test1 tb2 f66 8 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) select,insert,update,references

673

NULL test1 tb2 f67 9 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references

674

NULL test1 tb2 f68 10 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned select,insert,update,references

675

NULL test1 tb2 f69 11 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

676

NULL test1 tb2 f70 12 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references

677

NULL test1 tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references

678

NULL test1 tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references

679

NULL test1 tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references

680

NULL test1 tb2 f74 16 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references

681

NULL test1 tb2 f75 17 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

682

NULL test1 tb2 f76 18 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

683

NULL test1 tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references

684

NULL test1 tb2 f78 20 7.7 YES double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references

685

NULL test1 tb2 f79 21 00000000000000000007.7 YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

686

NULL test1 tb2 f80 22 00000000000000000008.8 YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

687

NULL test1 tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references

688

NULL test1 tb2 f82 24 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

689

NULL test1 tb2 f83 25 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

690

NULL test1 tb2 f84 26 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

691

NULL test1 tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references

692

NULL test1 tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references

693

NULL test1 tb2 f87 29 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

694

NULL test1 tb2 f88 30 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

695

NULL test1 tb2 f89 31 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

696

NULL test1 tb2 f90 32 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

697

NULL test1 tb2 f91 33 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

698

NULL test1 tb2 f92 34 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

699

NULL test1 tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references

700

NULL test1 tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references

701

NULL test1 tb2 f95 37 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references

702

NULL test1 tb2 f96 38 8.8 NO double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references

703

NULL test1 tb2 f97 39 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

704

NULL test1 tb2 f98 40 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references

705

NULL test1 tb2 f99 41 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references

706

NULL test4 t6 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references

707

NULL test4 t6 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

708

NULL test4 t6 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references

709

NULL test4 t6 f4 4 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

710

NULL test4 t6 f5 5 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references

711

NULL test4 t6 f6 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) select,insert,update,references

712

##########################################################################

713

# Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH

714

##########################################################################

715

SELECT DISTINCT

716

CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,

717

DATA_TYPE,

718

CHARACTER_SET_NAME,

719

COLLATION_NAME

720

FROM information_schema.columns

721

WHERE table_schema LIKE 'test%'

722

AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1

723

ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;

724

COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME

725

1.0000 binary NULL NULL

726

1.0000 blob NULL NULL

727

1.0000 longblob NULL NULL

728

1.0000 mediumblob NULL NULL

729

1.0000 tinyblob NULL NULL

730

1.0000 char latin1 latin1_bin

731

1.0000 varchar latin1 latin1_bin

732

1.0000 char latin1 latin1_swedish_ci

733

1.0000 enum latin1 latin1_swedish_ci

734

1.0000 longtext latin1 latin1_swedish_ci

735

1.0000 mediumtext latin1 latin1_swedish_ci

736

1.0000 set latin1 latin1_swedish_ci

737

1.0000 text latin1 latin1_swedish_ci

738

1.0000 tinytext latin1 latin1_swedish_ci

739

1.0000 varchar latin1 latin1_swedish_ci

740

SELECT DISTINCT

741

CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,

742

DATA_TYPE,

743

CHARACTER_SET_NAME,

744

COLLATION_NAME

745

FROM information_schema.columns

746

WHERE table_schema LIKE 'test%'

747

AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1

748

ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;

749

COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME

750

SELECT DISTINCT

751

CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,

752

DATA_TYPE,

753

CHARACTER_SET_NAME,

754

COLLATION_NAME

755

FROM information_schema.columns

756

WHERE table_schema LIKE 'test%'

757

AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL

758

ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;

759

COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME

760

NULL bigint NULL NULL

761

NULL date NULL NULL

762

NULL datetime NULL NULL

763

NULL decimal NULL NULL

764

NULL double NULL NULL

765

NULL float NULL NULL

766

NULL int NULL NULL

767

NULL mediumint NULL NULL

768

NULL smallint NULL NULL

769

NULL time NULL NULL

770

NULL timestamp NULL NULL

771

NULL tinyint NULL NULL

772

NULL year NULL NULL

773

NULL char latin1 latin1_bin

774

NULL char latin1 latin1_swedish_ci

775

NULL varchar latin1 latin1_swedish_ci

776

--> CHAR(0) is allowed (see manual), and here both CHARACHTER_* values

777

--> are 0, which is intended behavior, and the result of 0 / 0 IS NULL

778

SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,

779

TABLE_SCHEMA,

780

TABLE_NAME,

781

COLUMN_NAME,

782

DATA_TYPE,

783

CHARACTER_MAXIMUM_LENGTH,

784

CHARACTER_OCTET_LENGTH,

785

CHARACTER_SET_NAME,

786

COLLATION_NAME,

787

COLUMN_TYPE

788

FROM information_schema.columns

789

WHERE table_schema LIKE 'test%'

790

ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;

791

COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE

792

1.0000 test t1 f1 char 20 20 latin1 latin1_swedish_ci char(20)

793

1.0000 test t1 f2 char 25 25 latin1 latin1_swedish_ci char(25)

794

NULL test t1 f3 date NULL NULL NULL NULL date

795

NULL test t1 f4 int NULL NULL NULL NULL int(11)

796

1.0000 test t1 f5 char 25 25 latin1 latin1_swedish_ci char(25)

797

NULL test t1 f6 int NULL NULL NULL NULL int(11)

798

1.0000 test t10 f1 char 20 20 latin1 latin1_swedish_ci char(20)

799

1.0000 test t10 f2 char 25 25 latin1 latin1_swedish_ci char(25)

800

NULL test t10 f3 date NULL NULL NULL NULL date

801

NULL test t10 f4 int NULL NULL NULL NULL int(11)

802

1.0000 test t10 f5 char 25 25 latin1 latin1_swedish_ci char(25)

803

NULL test t10 f6 int NULL NULL NULL NULL int(11)

804

1.0000 test t11 f1 char 20 20 latin1 latin1_swedish_ci char(20)

805

1.0000 test t11 f2 char 25 25 latin1 latin1_swedish_ci char(25)

806

NULL test t11 f3 date NULL NULL NULL NULL date

807

NULL test t11 f4 int NULL NULL NULL NULL int(11)

808

1.0000 test t11 f5 char 25 25 latin1 latin1_swedish_ci char(25)

809

NULL test t11 f6 int NULL NULL NULL NULL int(11)

810

1.0000 test t2 f1 char 20 20 latin1 latin1_swedish_ci char(20)

811

1.0000 test t2 f2 char 25 25 latin1 latin1_swedish_ci char(25)

812

NULL test t2 f3 date NULL NULL NULL NULL date

813

NULL test t2 f4 int NULL NULL NULL NULL int(11)

814

1.0000 test t2 f5 char 25 25 latin1 latin1_swedish_ci char(25)

815

NULL test t2 f6 int NULL NULL NULL NULL int(11)

816

1.0000 test t3 f1 char 20 20 latin1 latin1_swedish_ci char(20)

817

1.0000 test t3 f2 char 20 20 latin1 latin1_swedish_ci char(20)

818

NULL test t3 f3 int NULL NULL NULL NULL int(11)

819

1.0000 test t4 f1 char 20 20 latin1 latin1_swedish_ci char(20)

820

1.0000 test t4 f2 char 25 25 latin1 latin1_swedish_ci char(25)

821

NULL test t4 f3 date NULL NULL NULL NULL date

822

NULL test t4 f4 int NULL NULL NULL NULL int(11)

823

1.0000 test t4 f5 char 25 25 latin1 latin1_swedish_ci char(25)

824

NULL test t4 f6 int NULL NULL NULL NULL int(11)

825

1.0000 test t7 f1 char 20 20 latin1 latin1_swedish_ci char(20)

826

1.0000 test t7 f2 char 25 25 latin1 latin1_swedish_ci char(25)

827

NULL test t7 f3 date NULL NULL NULL NULL date

828

NULL test t7 f4 int NULL NULL NULL NULL int(11)

829

1.0000 test t8 f1 char 20 20 latin1 latin1_swedish_ci char(20)

830

1.0000 test t8 f2 char 25 25 latin1 latin1_swedish_ci char(25)

831

NULL test t8 f3 date NULL NULL NULL NULL date

832

NULL test t8 f4 int NULL NULL NULL NULL int(11)

833

NULL test t9 f1 int NULL NULL NULL NULL int(11)

834

1.0000 test t9 f2 char 25 25 latin1 latin1_swedish_ci char(25)

835

NULL test t9 f3 int NULL NULL NULL NULL int(11)

836

NULL test tb1 f1 char 0 0 latin1 latin1_swedish_ci char(0)

837

NULL test tb1 f2 char 0 0 latin1 latin1_bin char(0)

838

NULL test tb1 f3 char 0 0 latin1 latin1_swedish_ci char(0)

839

1.0000 test tb1 f4 tinytext 255 255 latin1 latin1_swedish_ci tinytext

840

1.0000 test tb1 f5 text 65535 65535 latin1 latin1_swedish_ci text

841

1.0000 test tb1 f6 mediumtext 16777215 16777215 latin1 latin1_swedish_ci mediumtext

842

1.0000 test tb1 f7 longtext 4294967295 4294967295 latin1 latin1_swedish_ci longtext

843

1.0000 test tb1 f8 tinyblob 255 255 NULL NULL tinyblob

844

1.0000 test tb1 f9 blob 65535 65535 NULL NULL blob

845

1.0000 test tb1 f10 mediumblob 16777215 16777215 NULL NULL mediumblob

846

1.0000 test tb1 f11 longblob 4294967295 4294967295 NULL NULL longblob

847

1.0000 test tb1 f12 binary 1 1 NULL NULL binary(1)

848

NULL test tb1 f13 tinyint NULL NULL NULL NULL tinyint(4)

849

NULL test tb1 f14 tinyint NULL NULL NULL NULL tinyint(3) unsigned

850

NULL test tb1 f15 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill

851

NULL test tb1 f16 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill

852

NULL test tb1 f17 smallint NULL NULL NULL NULL smallint(6)

853

NULL test tb1 f18 smallint NULL NULL NULL NULL smallint(5) unsigned

854

NULL test tb1 f19 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill

855

NULL test tb1 f20 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill

856

NULL test tb1 f21 mediumint NULL NULL NULL NULL mediumint(9)

857

NULL test tb1 f22 mediumint NULL NULL NULL NULL mediumint(8) unsigned

858

NULL test tb1 f23 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill

859

NULL test tb1 f24 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill

860

NULL test tb1 f25 int NULL NULL NULL NULL int(11)

861

NULL test tb1 f26 int NULL NULL NULL NULL int(10) unsigned

862

NULL test tb1 f27 int NULL NULL NULL NULL int(10) unsigned zerofill

863

NULL test tb1 f28 int NULL NULL NULL NULL int(10) unsigned zerofill

864

NULL test tb1 f29 bigint NULL NULL NULL NULL bigint(20)

865

NULL test tb1 f30 bigint NULL NULL NULL NULL bigint(20) unsigned

866

NULL test tb1 f31 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill

867

NULL test tb1 f32 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill

868

NULL test tb1 f33 decimal NULL NULL NULL NULL decimal(10,0)

869

NULL test tb1 f34 decimal NULL NULL NULL NULL decimal(10,0) unsigned

870

NULL test tb1 f35 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

871

NULL test tb1 f36 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

872

NULL test tb1 f37 decimal NULL NULL NULL NULL decimal(10,0)

873

NULL test tb1 f38 decimal NULL NULL NULL NULL decimal(64,0)

874

NULL test tb1 f39 decimal NULL NULL NULL NULL decimal(10,0) unsigned

875

NULL test tb1 f40 decimal NULL NULL NULL NULL decimal(64,0) unsigned

876

NULL test tb1 f41 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

877

NULL test tb1 f42 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill

878

NULL test tb1 f43 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

879

NULL test tb1 f44 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill

880

NULL test tb1 f45 decimal NULL NULL NULL NULL decimal(10,0)

881

NULL test tb1 f46 decimal NULL NULL NULL NULL decimal(63,30)

882

NULL test tb1 f47 decimal NULL NULL NULL NULL decimal(10,0) unsigned

883

NULL test tb1 f48 decimal NULL NULL NULL NULL decimal(63,30) unsigned

884

NULL test tb1 f49 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

885

NULL test tb1 f50 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill

886

NULL test tb1 f51 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

887

NULL test tb1 f52 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill

888

NULL test tb1 f53 decimal NULL NULL NULL NULL decimal(10,0)

889

NULL test tb1 f54 decimal NULL NULL NULL NULL decimal(10,0) unsigned

890

NULL test tb1 f55 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

891

NULL test tb1 f56 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

892

NULL test tb1 f57 decimal NULL NULL NULL NULL decimal(10,0)

893

NULL test tb1 f58 decimal NULL NULL NULL NULL decimal(64,0)

894

NULL test tb2 f59 decimal NULL NULL NULL NULL decimal(10,0) unsigned

895

NULL test tb2 f60 decimal NULL NULL NULL NULL decimal(64,0) unsigned

896

NULL test tb2 f61 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

897

NULL test tb2 f62 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill

898

NULL test tb2 f63 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

899

NULL test tb2 f64 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill

900

NULL test tb2 f65 decimal NULL NULL NULL NULL decimal(10,0)

901

NULL test tb2 f66 decimal NULL NULL NULL NULL decimal(63,30)

902

NULL test tb2 f67 decimal NULL NULL NULL NULL decimal(10,0) unsigned

903

NULL test tb2 f68 decimal NULL NULL NULL NULL decimal(63,30) unsigned

904

NULL test tb2 f69 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

905

NULL test tb2 f70 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill

906

NULL test tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

907

NULL test tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill

908

NULL test tb2 f73 double NULL NULL NULL NULL double

909

NULL test tb2 f74 double NULL NULL NULL NULL double unsigned

910

NULL test tb2 f75 double NULL NULL NULL NULL double unsigned zerofill

911

NULL test tb2 f76 double NULL NULL NULL NULL double unsigned zerofill

912

NULL test tb2 f77 double NULL NULL NULL NULL double

913

NULL test tb2 f78 double NULL NULL NULL NULL double unsigned

914

NULL test tb2 f79 double NULL NULL NULL NULL double unsigned zerofill

915

NULL test tb2 f80 double NULL NULL NULL NULL double unsigned zerofill

916

NULL test tb2 f81 float NULL NULL NULL NULL float

917

NULL test tb2 f82 float NULL NULL NULL NULL float unsigned

918

NULL test tb2 f83 float NULL NULL NULL NULL float unsigned zerofill

919

NULL test tb2 f84 float NULL NULL NULL NULL float unsigned zerofill

920

NULL test tb2 f85 float NULL NULL NULL NULL float

921

NULL test tb2 f86 float NULL NULL NULL NULL float

922

NULL test tb2 f87 float NULL NULL NULL NULL float unsigned

923

NULL test tb2 f88 float NULL NULL NULL NULL float unsigned

924

NULL test tb2 f89 float NULL NULL NULL NULL float unsigned zerofill

925

NULL test tb2 f90 float NULL NULL NULL NULL float unsigned zerofill

926

NULL test tb2 f91 float NULL NULL NULL NULL float unsigned zerofill

927

NULL test tb2 f92 float NULL NULL NULL NULL float unsigned zerofill

928

NULL test tb2 f93 float NULL NULL NULL NULL float

929

NULL test tb2 f94 double NULL NULL NULL NULL double

930

NULL test tb2 f95 float NULL NULL NULL NULL float unsigned

931

NULL test tb2 f96 double NULL NULL NULL NULL double unsigned

932

NULL test tb2 f97 float NULL NULL NULL NULL float unsigned zerofill

933

NULL test tb2 f98 double NULL NULL NULL NULL double unsigned zerofill

934

NULL test tb2 f99 float NULL NULL NULL NULL float unsigned zerofill

935

NULL test tb2 f100 double NULL NULL NULL NULL double unsigned zerofill

936

NULL test tb2 f101 date NULL NULL NULL NULL date

937

NULL test tb2 f102 time NULL NULL NULL NULL time

938

NULL test tb2 f103 datetime NULL NULL NULL NULL datetime

939

NULL test tb2 f104 timestamp NULL NULL NULL NULL timestamp

940

NULL test tb2 f105 year NULL NULL NULL NULL year(4)

941

NULL test tb2 f106 year NULL NULL NULL NULL year(4)

942

NULL test tb2 f107 year NULL NULL NULL NULL year(4)

943

1.0000 test tb2 f108 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')

944

1.0000 test tb2 f109 set 9 9 latin1 latin1_swedish_ci set('1set','2set')

945

1.0000 test tb3 f118 char 1 1 latin1 latin1_swedish_ci char(1)

946

1.0000 test tb3 f119 char 1 1 latin1 latin1_bin char(1)

947

1.0000 test tb3 f120 char 1 1 latin1 latin1_swedish_ci char(1)

948

1.0000 test tb3 f121 tinytext 255 255 latin1 latin1_swedish_ci tinytext

949

1.0000 test tb3 f122 text 65535 65535 latin1 latin1_swedish_ci text

950

1.0000 test tb3 f123 mediumtext 16777215 16777215 latin1 latin1_swedish_ci mediumtext

951

1.0000 test tb3 f124 longtext 4294967295 4294967295 latin1 latin1_swedish_ci longtext

952

1.0000 test tb3 f125 tinyblob 255 255 NULL NULL tinyblob

953

1.0000 test tb3 f126 blob 65535 65535 NULL NULL blob

954

1.0000 test tb3 f127 mediumblob 16777215 16777215 NULL NULL mediumblob

955

1.0000 test tb3 f128 longblob 4294967295 4294967295 NULL NULL longblob

956

1.0000 test tb3 f129 binary 1 1 NULL NULL binary(1)

957

NULL test tb3 f130 tinyint NULL NULL NULL NULL tinyint(4)

958

NULL test tb3 f131 tinyint NULL NULL NULL NULL tinyint(3) unsigned

959

NULL test tb3 f132 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill

960

NULL test tb3 f133 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill

961

NULL test tb3 f134 smallint NULL NULL NULL NULL smallint(6)

962

NULL test tb3 f135 smallint NULL NULL NULL NULL smallint(5) unsigned

963

NULL test tb3 f136 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill

964

NULL test tb3 f137 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill

965

NULL test tb3 f138 mediumint NULL NULL NULL NULL mediumint(9)

966

NULL test tb3 f139 mediumint NULL NULL NULL NULL mediumint(8) unsigned

967

NULL test tb3 f140 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill

968

NULL test tb3 f141 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill

969

NULL test tb3 f142 int NULL NULL NULL NULL int(11)

970

NULL test tb3 f143 int NULL NULL NULL NULL int(10) unsigned

971

NULL test tb3 f144 int NULL NULL NULL NULL int(10) unsigned zerofill

972

NULL test tb3 f145 int NULL NULL NULL NULL int(10) unsigned zerofill

973

NULL test tb3 f146 bigint NULL NULL NULL NULL bigint(20)

974

NULL test tb3 f147 bigint NULL NULL NULL NULL bigint(20) unsigned

975

NULL test tb3 f148 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill

976

NULL test tb3 f149 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill

977

NULL test tb3 f150 decimal NULL NULL NULL NULL decimal(10,0)

978

NULL test tb3 f151 decimal NULL NULL NULL NULL decimal(10,0) unsigned

979

NULL test tb3 f152 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

980

NULL test tb3 f153 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

981

NULL test tb3 f154 decimal NULL NULL NULL NULL decimal(10,0)

982

NULL test tb3 f155 decimal NULL NULL NULL NULL decimal(64,0)

983

NULL test tb3 f156 decimal NULL NULL NULL NULL decimal(10,0) unsigned

984

NULL test tb3 f157 decimal NULL NULL NULL NULL decimal(64,0) unsigned

985

NULL test tb3 f158 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

986

NULL test tb3 f159 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill

987

NULL test tb3 f160 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

988

NULL test tb3 f161 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill

989

NULL test tb3 f162 decimal NULL NULL NULL NULL decimal(10,0)

990

NULL test tb3 f163 decimal NULL NULL NULL NULL decimal(63,30)

991

NULL test tb3 f164 decimal NULL NULL NULL NULL decimal(10,0) unsigned

992

NULL test tb3 f165 decimal NULL NULL NULL NULL decimal(63,30) unsigned

993

NULL test tb3 f166 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

994

NULL test tb3 f167 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill

995

NULL test tb3 f168 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

996

NULL test tb3 f169 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill

997

NULL test tb3 f170 decimal NULL NULL NULL NULL decimal(10,0)

998

NULL test tb3 f171 decimal NULL NULL NULL NULL decimal(10,0) unsigned

999

NULL test tb3 f172 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

1000

NULL test tb3 f173 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

1001

NULL test tb3 f174 decimal NULL NULL NULL NULL decimal(10,0)

1002

NULL test tb3 f175 decimal NULL NULL NULL NULL decimal(64,0)

1003

NULL test tb4 f176 decimal NULL NULL NULL NULL decimal(10,0) unsigned

1004

NULL test tb4 f177 decimal NULL NULL NULL NULL decimal(64,0) unsigned

1005

NULL test tb4 f178 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

1006

NULL test tb4 f179 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill

1007

NULL test tb4 f180 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

1008

NULL test tb4 f181 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill

1009

NULL test tb4 f182 decimal NULL NULL NULL NULL decimal(10,0)

1010

NULL test tb4 f183 decimal NULL NULL NULL NULL decimal(63,30)

1011

NULL test tb4 f184 decimal NULL NULL NULL NULL decimal(10,0) unsigned

1012

NULL test tb4 f185 decimal NULL NULL NULL NULL decimal(63,30) unsigned

1013

NULL test tb4 f186 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

1014

NULL test tb4 f187 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill

1015

NULL test tb4 f188 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

1016

NULL test tb4 f189 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill

1017

NULL test tb4 f190 double NULL NULL NULL NULL double

1018

NULL test tb4 f191 double NULL NULL NULL NULL double unsigned

1019

NULL test tb4 f192 double NULL NULL NULL NULL double unsigned zerofill

1020

NULL test tb4 f193 double NULL NULL NULL NULL double unsigned zerofill

1021

NULL test tb4 f194 double NULL NULL NULL NULL double

1022

NULL test tb4 f195 double NULL NULL NULL NULL double unsigned

1023

NULL test tb4 f196 double NULL NULL NULL NULL double unsigned zerofill

1024

NULL test tb4 f197 double NULL NULL NULL NULL double unsigned zerofill

1025

NULL test tb4 f198 float NULL NULL NULL NULL float

1026

NULL test tb4 f199 float NULL NULL NULL NULL float unsigned

1027

NULL test tb4 f200 float NULL NULL NULL NULL float unsigned zerofill

1028

NULL test tb4 f201 float NULL NULL NULL NULL float unsigned zerofill

1029

NULL test tb4 f202 float NULL NULL NULL NULL float

1030

NULL test tb4 f203 float NULL NULL NULL NULL float

1031

NULL test tb4 f204 float NULL NULL NULL NULL float unsigned

1032

NULL test tb4 f205 float NULL NULL NULL NULL float unsigned

1033

NULL test tb4 f206 float NULL NULL NULL NULL float unsigned zerofill

1034

NULL test tb4 f207 float NULL NULL NULL NULL float unsigned zerofill

1035

NULL test tb4 f208 float NULL NULL NULL NULL float unsigned zerofill

1036

NULL test tb4 f209 float NULL NULL NULL NULL float unsigned zerofill

1037

NULL test tb4 f210 float NULL NULL NULL NULL float

1038

NULL test tb4 f211 double NULL NULL NULL NULL double

1039

NULL test tb4 f212 float NULL NULL NULL NULL float unsigned

1040

NULL test tb4 f213 double NULL NULL NULL NULL double unsigned

1041

NULL test tb4 f214 float NULL NULL NULL NULL float unsigned zerofill

1042

NULL test tb4 f215 double NULL NULL NULL NULL double unsigned zerofill

1043

NULL test tb4 f216 float NULL NULL NULL NULL float unsigned zerofill

1044

NULL test tb4 f217 double NULL NULL NULL NULL double unsigned zerofill

1045

NULL test tb4 f218 date NULL NULL NULL NULL date

1046

NULL test tb4 f219 time NULL NULL NULL NULL time

1047

NULL test tb4 f220 datetime NULL NULL NULL NULL datetime

1048

NULL test tb4 f221 timestamp NULL NULL NULL NULL timestamp

1049

NULL test tb4 f222 year NULL NULL NULL NULL year(4)

1050

NULL test tb4 f223 year NULL NULL NULL NULL year(4)

1051

NULL test tb4 f224 year NULL NULL NULL NULL year(4)

1052

1.0000 test tb4 f225 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')

1053

1.0000 test tb4 f226 set 9 9 latin1 latin1_swedish_ci set('1set','2set')

1054

NULL test tb4 f235 char 0 0 latin1 latin1_swedish_ci char(0)

1055

1.0000 test tb4 f236 char 90 90 latin1 latin1_swedish_ci char(90)

1056

1.0000 test tb4 f237 char 255 255 latin1 latin1_swedish_ci char(255)

1057

NULL test tb4 f238 varchar 0 0 latin1 latin1_swedish_ci varchar(0)

1058

1.0000 test tb4 f239 varchar 20000 20000 latin1 latin1_bin varchar(20000)

1059

1.0000 test tb4 f240 varchar 2000 2000 latin1 latin1_swedish_ci varchar(2000)

1060

1.0000 test tb4 f241 char 100 100 latin1 latin1_swedish_ci char(100)

1061

NULL test1 tb2 f59 decimal NULL NULL NULL NULL decimal(10,0) unsigned

1062

NULL test1 tb2 f60 decimal NULL NULL NULL NULL decimal(64,0) unsigned

1063

NULL test1 tb2 f61 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

1064

NULL test1 tb2 f62 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill

1065

NULL test1 tb2 f63 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

1066

NULL test1 tb2 f64 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill

1067

NULL test1 tb2 f65 decimal NULL NULL NULL NULL decimal(10,0)

1068

NULL test1 tb2 f66 decimal NULL NULL NULL NULL decimal(63,30)

1069

NULL test1 tb2 f67 decimal NULL NULL NULL NULL decimal(10,0) unsigned

1070

NULL test1 tb2 f68 decimal NULL NULL NULL NULL decimal(63,30) unsigned

1071

NULL test1 tb2 f69 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

1072

NULL test1 tb2 f70 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill

1073

NULL test1 tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill

1074

NULL test1 tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill

1075

NULL test1 tb2 f73 double NULL NULL NULL NULL double

1076

NULL test1 tb2 f74 double NULL NULL NULL NULL double unsigned

1077

NULL test1 tb2 f75 double NULL NULL NULL NULL double unsigned zerofill

1078

NULL test1 tb2 f76 double NULL NULL NULL NULL double unsigned zerofill

1079

NULL test1 tb2 f77 double NULL NULL NULL NULL double

1080

NULL test1 tb2 f78 double NULL NULL NULL NULL double unsigned

1081

NULL test1 tb2 f79 double NULL NULL NULL NULL double unsigned zerofill

1082

NULL test1 tb2 f80 double NULL NULL NULL NULL double unsigned zerofill

1083

NULL test1 tb2 f81 float NULL NULL NULL NULL float

1084

NULL test1 tb2 f82 float NULL NULL NULL NULL float unsigned

1085

NULL test1 tb2 f83 float NULL NULL NULL NULL float unsigned zerofill

1086

NULL test1 tb2 f84 float NULL NULL NULL NULL float unsigned zerofill

1087

NULL test1 tb2 f85 float NULL NULL NULL NULL float

1088

NULL test1 tb2 f86 float NULL NULL NULL NULL float

1089

NULL test1 tb2 f87 float NULL NULL NULL NULL float unsigned

1090

NULL test1 tb2 f88 float NULL NULL NULL NULL float unsigned

1091

NULL test1 tb2 f89 float NULL NULL NULL NULL float unsigned zerofill

1092

NULL test1 tb2 f90 float NULL NULL NULL NULL float unsigned zerofill

1093

NULL test1 tb2 f91 float NULL NULL NULL NULL float unsigned zerofill

1094

NULL test1 tb2 f92 float NULL NULL NULL NULL float unsigned zerofill

1095

NULL test1 tb2 f93 float NULL NULL NULL NULL float

1096

NULL test1 tb2 f94 double NULL NULL NULL NULL double

1097

NULL test1 tb2 f95 float NULL NULL NULL NULL float unsigned

1098

NULL test1 tb2 f96 double NULL NULL NULL NULL double unsigned

1099

NULL test1 tb2 f97 float NULL NULL NULL NULL float unsigned zerofill

1100

NULL test1 tb2 f98 double NULL NULL NULL NULL double unsigned zerofill

1101

NULL test1 tb2 f99 float NULL NULL NULL NULL float unsigned zerofill

1102

NULL test1 tb2 f100 double NULL NULL NULL NULL double unsigned zerofill

1103

NULL test1 tb2 f101 date NULL NULL NULL NULL date

1104

NULL test1 tb2 f102 time NULL NULL NULL NULL time

1105

NULL test1 tb2 f103 datetime NULL NULL NULL NULL datetime

1106

NULL test1 tb2 f104 timestamp NULL NULL NULL NULL timestamp

1107

NULL test1 tb2 f105 year NULL NULL NULL NULL year(4)

1108

NULL test1 tb2 f106 year NULL NULL NULL NULL year(4)

1109

NULL test1 tb2 f107 year NULL NULL NULL NULL year(4)

1110

1.0000 test1 tb2 f108 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')

1111

1.0000 test1 tb2 f109 set 9 9 latin1 latin1_swedish_ci set('1set','2set')

1112

1.0000 test4 t6 f1 char 20 20 latin1 latin1_swedish_ci char(20)

1113

1.0000 test4 t6 f2 char 25 25 latin1 latin1_swedish_ci char(25)

1114

NULL test4 t6 f3 date NULL NULL NULL NULL date

1115

NULL test4 t6 f4 int NULL NULL NULL NULL int(11)

1116

1.0000 test4 t6 f5 char 25 25 latin1 latin1_swedish_ci char(25)

1117

NULL test4 t6 f6 int NULL NULL NULL NULL int(11)

1118

DROP DATABASE test1;

1119

DROP DATABASE test4;

1120

DROP TABLE test.t1;

1121

DROP TABLE test.t2;

1122

DROP TABLE test.t3;

1123

DROP TABLE test.t4;

1124

DROP TABLE test.t7;

1125

DROP TABLE test.t8;

1126

DROP TABLE test.t9;

1127

DROP TABLE test.t10;

1128

DROP TABLE test.t11;

1129

DROP TABLE test.tb1;

1130

DROP TABLE test.tb2;

1131

DROP TABLE test.tb3;

1132

DROP TABLE test.tb4;

Older »