Mysql5.0造数据

51Testing软件测试网&Eet|%^*B!A5q!B

客户端工具Navicat(MySQL Client) v7.2.9，安装MysqlOdbc数据引擎

@4N0ZP Gg%W{051Testing软件测试网h5E-FH&yR|7o}

建表语句51Testing软件测试网I3_6qN:J

,d:hY4H^0

.P#@,b3V8q#V$u*R0 

)L U'Cm])V J051Testing软件测试网O |)Z#mZ_

CREATE TABLE `testdba` (51Testing软件测试网 O%b S?"H+?6T

'j8A6~/e7K/eu0  `xtinyint` tinyint(4) default NULL,

gxi@BpdM*O051Testing软件测试网-xvD,a*p}

  `xsmallint` smallint(6) default NULL,

8FZo/Y&pi)ro#`v3y0

)b"C*Zi1tX0  `xmediumint` mediumint(9) default NULL,51Testing软件测试网t([
k$fP&gA

51Testing软件测试网pF
YDd

  `xint` int(11) default NULL,

;Ne4Pa#d0

emt.s0R:fE x.^ZYU0  `xinteger` int(11) default NULL,51Testing软件测试网{+~4`)U1W!Sd(wH

/lmKp@qv:OH'M0  `xbigint` bigint(20) default NULL,

]g,zS8{;bvj0

8vg6gQ[4Gn(x0  `xbit` bit(1) default NULL,

QO*_'H8b&v^051Testing软件测试网x0_TR
|8Y

  `xreal` double default NULL,

z LV%?'lO5}0

H:X0cer0  `xdouble` double default NULL,

*ecs{I+ISp
m0RPI051Testing软件测试网C1aV |-j+A$b

  `xfloat` float default NULL,

DT[2P~
U(t1TS@051Testing软件测试网G~
U{s1n@@

  `xdecimal` decimal(10,0) default NULL,

8?$P8K,`jw2?gVq051Testing软件测试网 R.Z` rQ4q*B

  `xnumeric` decimal(10,0) default NULL,

X4\]L ?(qK0

J {YNX(m0  `xchar` char(5) default 'char',

,s1FB)tf/R:B051Testing软件测试网M*I*~3m,ZM

  `xvarchar` varchar(50) default 'varchar',

C7N&HC:l|2hsD051Testing软件测试网^*VZd{^Ku O

  `xdate` date default NULL,51Testing软件测试网2j;U&r*z4cuVd

!f8C R2W"d-E7Z6H)Er?0  `xtime` time default NULL,

{JsR.l3j5JcX0

/h9Y{2mi|7Otm0  `xyear` year(4) default NULL,51Testing软件测试网/I(S^L)b ui

51Testing软件测试网4B,cnKQ9l

  `xtimestamp` timestamp NULL default NULL on update CURRENT_TIMESTAMP,

8vxNV!nfn051Testing软件测试网w"aN*ans:d

  `xdatetime` datetime default NULL,51Testing软件测试网.rC7V0IXd

U!@6cX"c6}m0  `xtinytext` tinytext,51Testing软件测试网*H$iJ3BlP
l

51Testing软件测试网`]+rK0J!lS%y&k

  `xtext` text,

$A1F&Q3F*{@051Testing软件测试网 N {1RA:X+[J

  `xmediumtext` mediumtext,

n] p]kO_0

d!i+o_GG6w7x!l*l0  `xlongtext` longtext,51Testing软件测试网 G-Ehw_}.`N

51Testing软件测试网n]!m h{H

  `xenum` enum('') default NULL,

)I,ua E X0

P8yJ:G*y
X3tF'?/y!Q0  `xset` set('') default NULL,

:hJ6I'Q(q"m051Testing软件测试网4hH(e,J%@#kR

  `xbinary` binary(255) default NULL,51Testing软件测试网Z*}:D6d1b4T"~4L

$YMje3PnB,BE0  `xvarbinary` varbinary(255) default NULL51Testing软件测试网Y3QoB.vC1m

I(P0x:T1r8P0G'v0) ENGINE=InnoDB DEFAULT CHARSET=latin1;

{P/PGL#Po^'D
XC0

4LYKw8eBQ0插入一条记录

h:[u'`c8M0

9?E~I$A0INSERT INTO testdba51Testing软件测试网d9J{$P4|&]xI

n,V)u\uw)d#]0  (xtinyint, xsmallint, xmediumint, xint, xinteger, xbigint, xbit, xreal, xdouble, xfloat, xdecimal, xnumeric, xchar, xvarchar, xdate, xtime, xyear, xtimestamp, xdatetime, xtinytext, xtext, xmediumtext, xlongtext, xenum, xset, xbinary, xvarbinary)51Testing软件测试网8iY4dL7p3pt#v

;k;L w4Ac1k W)OSHR0VALUES

L,B+G+HW)A&F)E?0

2g7g3u ny"ZU0  (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, "char", "varchar", "2007-7-3", "00:00:00", 2007, "2007-7-3 14:20:36", "2007-7-3 14:20:41", "", "NULL", "NULL", "NULL", "", "", " 0x0001E24000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "0x2020202020202020202020202020202020202020202020202020202020202020");51Testing软件测试网I*t2Dj/zL(O-_

I M9zB9i0批量插入10000条数据

im4\y+CGo0

!d!D;q:s Df {#I*J0在命令行下执行存储过程：

j
t@Zi051Testing软件测试网)g[.M&YU\z v

Use test;

+r/K?:Z P
@'R?6X#b051Testing软件测试网1V@|p@

Show testdba;51Testing软件测试网*YT J:k0H Devi

51Testing软件测试网O8e+v}z
K5E'x

call `dowhile`();

|M$y`!Mz0

3IoLf:a,s1i*?v0创建存储过程51Testing软件测试网_ |@"S q fP

51Testing软件测试网T'u3_"_8gX

CREATE PROCEDURE `dowhile`()51Testing软件测试网oA4?&wrt:Dolq

51Testing软件测试网ux iR3O0HC

BEGIN

9f wl)E&o&Gm051Testing软件测试网&NO3?7Xd%Y'M6c)F

  DECLARE v1 INT DEFAULT 10;

b v+H;qG/L)~0

1pr,W|O0  WHILE v1 <=10000 DO

]{YA4[m!R\0

0PU
f2Xs"L0     INSERT INTO testdba51Testing软件测试网uy8A7X5N

51Testing软件测试网1re3P,|mZq fo

  (xtinyint, xsmallint, xmediumint, xint, xinteger, xbigint, xbit, xreal, xdouble, xfloat, xdecimal, xnumeric, xchar, xvarchar, xdate, xtime, xyear, xtimestamp, xdatetime, xtinytext, xtext, xmediumtext, xlongtext, xenum, xset, xbinary, xvarbinary)

%}+X:t
RgoI-i051Testing软件测试网A+`r:z\

VALUES51Testing软件测试网 aq8q%z&m-Y'|r)rC

Rq3rBY+yaR5lX0  (1, 1, 1, v1, 1, 1, 1, 1, 1, 1, 1, 1, "char", "varchar", "2007-7-3", "00:00:00", 2007, "2007-7-3 14:20:36", "2007-7-3 14:20:41", "", "NULL", "NULL", "NULL", "", "", " 0x0001E24000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "0x2020202020202020202020202020202020202020202020202020202020202020");

!kP u|-BttK051Testing软件测试网 N&eal{D

    SET v1 = v1 + 1;51Testing软件测试网 S G*A:Aia

z~_'B'c8zC T0  END WHILE;

y.M xOV%r)Q8gU+s051Testing软件测试网N(F9Ugcl]

END

:@#dN2MK^&E |%C0

l p)BaT
M#m2z0