File: col_types.sql

package info (click to toggle)
percona-toolkit 3.2.1-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, bullseye, forky, sid, trixie
  • size: 68,916 kB
  • sloc: perl: 241,287; sql: 22,868; sh: 19,746; javascript: 6,799; makefile: 353; awk: 38; python: 30; sed: 1
file content (20 lines) | stat: -rw-r--r-- 517 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
USE test;

-- Add more column types in another col_type_N table so that previous
-- tests won't break after being surprised with new colums.

DROP TABLE IF EXISTS col_types_1;
CREATE TABLE col_types_1 (
   id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
   i  INT,
   f  FLOAT,
   d  DECIMAL(5,2),
   dt DATETIME,
   ts TIMESTAMP,
   c  char,
   c2 char(15) not null,
   v  varchar(32),
   t  text
);
INSERT INTO col_types_1 VALUES (NULL, 1, 3.14, 5.08, NOW(), NOW(), 'c', 'c2', 'hello world', 'this is text');