~stewart/drizzle/embedded-innodb-create-select-transaction-arrgh

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 STORAGE FORMAT

364

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

365

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

366

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

367

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

368

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

369

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

370

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

371

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

372

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

373

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

374

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

375

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

376

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

377

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

378

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

379

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

380

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

381

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

382

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

383

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

384

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

385

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

386

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

387

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

388

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

389

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

390

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

391

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

392

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

393

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

394

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

395

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

396

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

397

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

398

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

399

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

400

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

401

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

402

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

403

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

404

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

405

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

406

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

407

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

408

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

409

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

410

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

411

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

412

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

413

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

414

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

415

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

416

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

417

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

418

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

419

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

420

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

421

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

422

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

423

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

424

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

425

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

426

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

427

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

428

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

429

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

430

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

431

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

432

NULL test tb1 f33 25 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) select,insert,update,references Default Default

433

NULL test tb1 f34 26 10 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned select,insert,update,references Default Default

434

NULL test tb1 f35 27 0000000010 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references Default Default

435

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

436

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

437

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

438

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

439

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

440

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

441

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

442

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

443

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

444

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

445

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

446

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

447

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

448

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

449

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

450

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

451

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

452

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

453

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

454

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

455

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

456

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

457

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

458

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

459

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

460

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

461

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

462

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

463

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

464

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

465

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

466

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

467

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

468

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

469

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

470

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

471

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

472

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

473

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

474

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

475

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

476

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

477

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

478

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

479

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

480

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

481

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

482

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

483

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

484

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

485

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

486

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

487

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

488

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

489

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

490

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

491

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

492

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

493

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

494

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

495

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

496

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

497

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

498

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

499

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

500

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

501

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

502

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

503

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

504

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

505

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

506

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

507

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

508

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

509

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

510

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

511

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

512

NULL test tb3 f121 4 NULL YES char 50 50 NULL NULL latin1 latin1_swedish_ci char(50) select,insert,update,references Default Default

513

NULL test tb3 f122 5 NULL YES char 50 50 NULL NULL latin1 latin1_swedish_ci char(50) select,insert,update,references Default Default

514

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

515

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

516

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

517

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

518

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

519

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

520

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

521

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

522

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

523

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

524

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

525

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

526

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

527

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

528

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

529

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

530

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

531

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

532

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

533

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

534

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

535

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

536

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

537

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

538

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

539

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

540

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

541

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

542

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

543

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

544

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

545

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

546

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

547

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

548

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

549

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

550

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

551

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

552

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

553

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

554

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

555

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

556

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

557

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

558

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

559

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

560

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

561

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

562

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

563

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

564

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

565

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

566

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

567

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

568

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

569

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

570

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

571

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

572

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

573

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

574

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

575

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

576

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

577

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

578

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

579

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

580

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

581

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

582

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

583

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

584

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

585

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

586

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

587

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

588

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

589

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

590

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

591

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

592

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

593

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

594

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

595

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

596

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

597

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

598

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

599

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

600

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

601

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

602

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

603

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

604

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

605

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

606

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

607

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

608

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

609

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

610

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

611

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

612

NULL test tb4 f236 52 NULL YES char 95 190 NULL NULL ucs2 ucs2_general_ci char(95) select,insert,update,references Default Default

613

NULL test tb4 f237 54 NULL YES char 130 130 NULL NULL latin1 latin1_bin char(130) select,insert,update,references Default Default

614

NULL test tb4 f238 55 NULL YES varchar 25000 25000 NULL NULL latin1 latin1_bin varchar(25000) select,insert,update,references Default Default

615

NULL test tb4 f239 56 NULL YES varbinary 0 0 NULL NULL NULL NULL varbinary(0) select,insert,update,references Default Default

616

NULL test tb4 f240 57 NULL YES varchar 1200 2400 NULL NULL ucs2 ucs2_general_ci varchar(1200) select,insert,update,references Default Default

617

NULL test tb4 f241 53 NULL YES char 255 510 NULL NULL ucs2 ucs2_general_ci char(255) select,insert,update,references Default Default

618

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

619

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

620

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

621

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

622

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

623

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

624

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

625

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

626

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

627

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

628

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

629

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

630

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

631

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

632

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

633

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

634

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

635

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

636

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

637

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

638

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

639

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

640

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

641

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

642

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

643

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

644

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

645

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

646

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

647

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

648

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

649

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

650

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

651

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

652

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

653

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

654

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

655

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

656

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

657

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

658

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

659

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

660

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

661

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

662

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

663

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

664

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

665

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

666

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

667

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

668

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

669

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

670

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

671

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

672

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

673

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

674

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

675

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

676

# Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH

677

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

678

SELECT DISTINCT

679

CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,

680

DATA_TYPE,

681

CHARACTER_SET_NAME,

682

COLLATION_NAME

683

FROM information_schema.columns

684

WHERE table_schema LIKE 'test%'

685

AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1

686

ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;

687

COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME

688

1.0000 binary NULL NULL

689

1.0000 char latin1 latin1_bin

690

1.0000 varchar latin1 latin1_bin

691

1.0000 char latin1 latin1_swedish_ci

692

1.0000 enum latin1 latin1_swedish_ci

693

1.0000 set latin1 latin1_swedish_ci

694

SELECT DISTINCT

695

CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,

696

DATA_TYPE,

697

CHARACTER_SET_NAME,

698

COLLATION_NAME

699

FROM information_schema.columns

700

WHERE table_schema LIKE 'test%'

701

AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1

702

ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;

703

COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME

704

2.0000 char ucs2 ucs2_general_ci

705

2.0000 varchar ucs2 ucs2_general_ci

706

SELECT DISTINCT

707

CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,

708

DATA_TYPE,

709

CHARACTER_SET_NAME,

710

COLLATION_NAME

711

FROM information_schema.columns

712

WHERE table_schema LIKE 'test%'

713

AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL

714

ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;

715

COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME

716

NULL bigint NULL NULL

717

NULL date NULL NULL

718

NULL datetime NULL NULL

719

NULL decimal NULL NULL

720

NULL double NULL NULL

721

NULL double unsigned NULL NULL

722

NULL double unsigned zerofill NULL NULL

723

NULL float NULL NULL

724

NULL float unsigned NULL NULL

725

NULL float unsigned zerofill NULL NULL

726

NULL int NULL NULL

727

NULL mediumint NULL NULL

728

NULL smallint NULL NULL

729

NULL time NULL NULL

730

NULL timestamp NULL NULL

731

NULL tinyint NULL NULL

732

NULL varbinary NULL NULL

733

NULL year NULL NULL

734

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

735

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

736

SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,

737

TABLE_SCHEMA,

738

TABLE_NAME,

739

COLUMN_NAME,

740

DATA_TYPE,

741

CHARACTER_MAXIMUM_LENGTH,

742

CHARACTER_OCTET_LENGTH,

743

CHARACTER_SET_NAME,

744

COLLATION_NAME,

745

COLUMN_TYPE

746

FROM information_schema.columns

747

WHERE table_schema LIKE 'test%'

748

ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;

749

COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE

750

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

751

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

752

NULL test t1 f3 date NULL NULL NULL NULL date

753

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

754

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

755

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

756

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

757

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

758

NULL test t10 f3 date NULL NULL NULL NULL date

759

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

760

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

761

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

762

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

763

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

764

NULL test t11 f3 date NULL NULL NULL NULL date

765

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

766

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

767

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

768

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

769

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

770

NULL test t2 f3 date NULL NULL NULL NULL date

771

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

772

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

773

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

774

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

775

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

776

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

777

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

778

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

779

NULL test t4 f3 date NULL NULL NULL NULL date

780

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

781

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

782

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

783

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

784

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

785

NULL test t7 f3 date NULL NULL NULL NULL date

786

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

787

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

788

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

789

NULL test t8 f3 date NULL NULL NULL NULL date

790

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

791

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

792

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

793

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

794

1.0000 test tb1 f1 char 1 1 latin1 latin1_swedish_ci char(1)

795

1.0000 test tb1 f2 char 1 1 latin1 latin1_bin char(1)

796

1.0000 test tb1 f3 char 1 1 latin1 latin1_swedish_ci char(1)

797

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

798

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

799

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

800

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

801

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

802

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

803

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

804

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

805

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

806

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

807

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

808

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

809

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

810

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

811

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

812

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

813

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

814

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

815

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

816

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

817

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

818

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

819

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

820

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

821

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

822

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

823

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

824

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

825

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

826

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

827

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

828

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

829

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

830

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

831

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

832

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

833

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

834

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

835

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

836

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

837

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

838

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

839

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

840

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

841

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

842

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

843

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

844

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

845

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

846

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

847

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

848

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

849

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

850

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

851

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

852

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

853

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

854

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

855

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

856

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

857

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

858

NULL test tb2 f73 double NULL NULL NULL NULL double

859

NULL test tb2 f74 double unsigned NULL NULL NULL NULL double unsigned

860

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

861

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

862

NULL test tb2 f77 double NULL NULL NULL NULL double

863

NULL test tb2 f78 double unsigned NULL NULL NULL NULL double unsigned

864

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

865

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

866

NULL test tb2 f81 float NULL NULL NULL NULL float

867

NULL test tb2 f82 float unsigned NULL NULL NULL NULL float unsigned

868

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

869

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

870

NULL test tb2 f85 float NULL NULL NULL NULL float

871

NULL test tb2 f86 float NULL NULL NULL NULL float

872

NULL test tb2 f87 float unsigned NULL NULL NULL NULL float unsigned

873

NULL test tb2 f88 float unsigned NULL NULL NULL NULL float unsigned

874

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

875

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

876

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

877

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

878

NULL test tb2 f93 float NULL NULL NULL NULL float

879

NULL test tb2 f94 double NULL NULL NULL NULL double

880

NULL test tb2 f95 float unsigned NULL NULL NULL NULL float unsigned

881

NULL test tb2 f96 double unsigned NULL NULL NULL NULL double unsigned

882

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

883

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

884

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

885

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

886

NULL test tb2 f101 date NULL NULL NULL NULL date

887

NULL test tb2 f102 time NULL NULL NULL NULL time

888

NULL test tb2 f103 datetime NULL NULL NULL NULL datetime

889

NULL test tb2 f104 timestamp NULL NULL NULL NULL timestamp

890

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

891

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

892

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

893

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

894

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

895

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

896

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

897

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

898

1.0000 test tb3 f121 char 50 50 latin1 latin1_swedish_ci char(50)

899

1.0000 test tb3 f122 char 50 50 latin1 latin1_swedish_ci char(50)

900

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

901

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

902

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

903

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

904

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

905

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

906

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

907

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

908

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

909

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

910

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

911

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

912

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

913

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

914

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

915

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

916

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

917

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

918

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

919

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

920

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

921

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

922

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

923

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

924

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

925

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

926

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

927

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

928

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

929

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

930

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

931

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

932

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

933

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

934

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

935

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

936

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

937

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

938

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

939

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

940

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

941

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

942

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

943

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

944

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

945

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

946

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

947

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

948

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

949

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

950

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

951

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

952

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

953

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

954

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

955

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

956

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

957

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

958

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

959

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

960

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

961

NULL test tb4 f190 double NULL NULL NULL NULL double

962

NULL test tb4 f191 double unsigned NULL NULL NULL NULL double unsigned

963

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

964

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

965

NULL test tb4 f194 double NULL NULL NULL NULL double

966

NULL test tb4 f195 double unsigned NULL NULL NULL NULL double unsigned

967

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

968

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

969

NULL test tb4 f198 float NULL NULL NULL NULL float

970

NULL test tb4 f199 float unsigned NULL NULL NULL NULL float unsigned

971

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

972

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

973

NULL test tb4 f202 float NULL NULL NULL NULL float

974

NULL test tb4 f203 float NULL NULL NULL NULL float

975

NULL test tb4 f204 float unsigned NULL NULL NULL NULL float unsigned

976

NULL test tb4 f205 float unsigned NULL NULL NULL NULL float unsigned

977

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

978

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

979

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

980

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

981

NULL test tb4 f210 float NULL NULL NULL NULL float

982

NULL test tb4 f211 double NULL NULL NULL NULL double

983

NULL test tb4 f212 float unsigned NULL NULL NULL NULL float unsigned

984

NULL test tb4 f213 double unsigned NULL NULL NULL NULL double unsigned

985

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

986

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

987

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

988

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

989

NULL test tb4 f218 date NULL NULL NULL NULL date

990

NULL test tb4 f219 time NULL NULL NULL NULL time

991

NULL test tb4 f220 datetime NULL NULL NULL NULL datetime

992

NULL test tb4 f221 timestamp NULL NULL NULL NULL timestamp

993

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

994

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

995

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

996

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

997

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

998

2.0000 test tb4 f236 char 95 190 ucs2 ucs2_general_ci char(95)

999

2.0000 test tb4 f241 char 255 510 ucs2 ucs2_general_ci char(255)

1000

1.0000 test tb4 f237 char 130 130 latin1 latin1_bin char(130)

1001

1.0000 test tb4 f238 varchar 25000 25000 latin1 latin1_bin varchar(25000)

1002

NULL test tb4 f239 varbinary 0 0 NULL NULL varbinary(0)

1003

2.0000 test tb4 f240 varchar 1200 2400 ucs2 ucs2_general_ci varchar(1200)

1004

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

1005

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

1006

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

1007

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

1008

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

1009

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

1010

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

1011

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

1012

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

1013

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

1014

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

1015

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

1016

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

1017

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

1018

NULL test1 tb2 f73 double NULL NULL NULL NULL double

1019

NULL test1 tb2 f74 double unsigned NULL NULL NULL NULL double unsigned

1020

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

1021

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

1022

NULL test1 tb2 f77 double NULL NULL NULL NULL double

1023

NULL test1 tb2 f78 double unsigned NULL NULL NULL NULL double unsigned

1024

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

1025

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

1026

NULL test1 tb2 f81 float NULL NULL NULL NULL float

1027

NULL test1 tb2 f82 float unsigned NULL NULL NULL NULL float unsigned

1028

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

1029

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

1030

NULL test1 tb2 f85 float NULL NULL NULL NULL float

1031

NULL test1 tb2 f86 float NULL NULL NULL NULL float

1032

NULL test1 tb2 f87 float unsigned NULL NULL NULL NULL float unsigned

1033

NULL test1 tb2 f88 float unsigned NULL NULL NULL NULL float unsigned

1034

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

1035

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

1036

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

1037

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

1038

NULL test1 tb2 f93 float NULL NULL NULL NULL float

1039

NULL test1 tb2 f94 double NULL NULL NULL NULL double

1040

NULL test1 tb2 f95 float unsigned NULL NULL NULL NULL float unsigned

1041

NULL test1 tb2 f96 double unsigned NULL NULL NULL NULL double unsigned

1042

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

1043

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

1044

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

1045

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

1046

NULL test1 tb2 f101 date NULL NULL NULL NULL date

1047

NULL test1 tb2 f102 time NULL NULL NULL NULL time

1048

NULL test1 tb2 f103 datetime NULL NULL NULL NULL datetime

1049

NULL test1 tb2 f104 timestamp NULL NULL NULL NULL timestamp

1050

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

1051

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

1052

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

1053

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

1054

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

1055

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

1056

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

1057

NULL test4 t6 f3 date NULL NULL NULL NULL date

1058

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

1059

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

1060

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

1061

DROP DATABASE test1;

1062

DROP DATABASE test4;

1063

DROP TABLE test.t1;

1064

DROP TABLE test.t2;

1065

DROP TABLE test.t3;

1066

DROP TABLE test.t4;

1067

DROP TABLE test.t7;

1068

DROP TABLE test.t8;

1069

DROP TABLE test.t9;

1070

DROP TABLE test.t10;

1071

DROP TABLE test.t11;

1072

DROP TABLE test.tb1;

1073

DROP TABLE test.tb2;

1074

DROP TABLE test.tb3;

1075

DROP TABLE test.tb4;

Older »