1 DROP TABLE IF EXISTS t1;
3 auto int(5) unsigned NOT NULL auto_increment,
4 string char(10) default "hello",
5 vstring varchar(10) default "hello",
8 tiny tinyint(4) DEFAULT '0' NOT NULL ,
9 short smallint(6) DEFAULT '1' NOT NULL ,
10 medium mediumint(8) DEFAULT '0' NOT NULL,
11 long_int int(11) DEFAULT '0' NOT NULL,
12 longlong bigint(13) DEFAULT '0' NOT NULL,
13 real_float float(13,1) DEFAULT 0.0 NOT NULL,
14 real_double double(16,4),
15 real_decimal decimal(16,4),
16 utiny tinyint(3) unsigned DEFAULT '0' NOT NULL,
17 ushort smallint(5) unsigned zerofill DEFAULT '00000' NOT NULL,
18 umedium mediumint(8) unsigned DEFAULT '0' NOT NULL,
19 ulong int(11) unsigned DEFAULT '0' NOT NULL,
20 ulonglong bigint(13) unsigned DEFAULT '0' NOT NULL,
22 options enum('one','two','tree') not null,
23 flags set('one','two','tree') not null,
28 time_stamp timestamp not null default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
33 KEY any_name (medium),
39 KEY (ulonglong,ulong),
44 (string,vstring,bin,vbin,tiny,short,medium,long_int,longlong,
45 real_float,real_double, real_decimal,utiny, ushort, umedium,ulong,ulonglong,
46 bits,options,flags,date_field,year_field,time_field,date_time)
48 ("aaaa","aaaa",0xAAAA,0xAAAA,-1,-1,-1,-1,-1,1.1,1.1,1.1,1,1,1,1,1,
49 b'001','one','one', '1901-01-01','1901','01:01:01','1901-01-01 01:01:01');
50 select auto,string,vstring,bin,vbin,tiny,short,medium,long_int,longlong,
51 real_float,real_double,real_decimal,utiny,ushort,umedium,ulong,ulonglong,
52 bits,options,flags,date_field,year_field,time_field,date_time
54 auto string vstring bin vbin tiny short medium long_int longlong real_float real_double real_decimal utiny ushort umedium ulong ulonglong bits options flags date_field year_field time_field date_time
55 1 aaaa aaaa ªª ªª -1 -1 -1 -1 -1 1.1 1.1000 1.1000 1 00001 1 1 1
\x01 one one 1901-01-01 1901 01:01:01 1901-01-01 01:01:01
56 select time_stamp>@now from t1;
60 update t1 set string="bbbb",vstring="bbbb",bin=0xBBBB,vbin=0xBBBB,
61 tiny=-2,short=-2,medium=-2,long_int=-2,longlong=-2,real_float=2.2,
62 real_double=2.2,real_decimal=2.2,utiny=2,ushort=2,umedium=2,ulong=2,
63 ulonglong=2, bits=b'010',
64 options='one',flags='one', date_field='1902-02-02',year_field='1902',
65 time_field='02:02:02',date_time='1902-02-02 02:02:02' where auto=1;
66 select auto,string,vstring,bin,vbin,tiny,short,medium,long_int,longlong,
67 real_float,real_double,real_decimal,utiny,ushort,umedium,ulong,ulonglong,
68 bits,options,flags,date_field,year_field,time_field,date_time
70 auto string vstring bin vbin tiny short medium long_int longlong real_float real_double real_decimal utiny ushort umedium ulong ulonglong bits options flags date_field year_field time_field date_time
71 1 bbbb bbbb »» »» -2 -2 -2 -2 -2 2.2 2.2000 2.2000 2 00002 2 2 2
\x02 one one 1902-02-02 1902 02:02:02 1902-02-02 02:02:02
72 select time_stamp>@now from t1;