Mysql5.0造数据
上一篇 / 下一篇 2007-08-01 00:14:09 / 个人分类:数据库
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软件测试网-x vD,a*p}
`xsmallint` smallint(6) default NULL,8FZo/Y&pi)ro#`v3y0
)b"C*Zi1tX0 `xmediumint` mediumint(9) default NULL,51Testing软件测试网t([k$fP&gA51Testing软件测试网pFYDd
`xint` int(11) default NULL,;Ne4Pa#d0
emt.s0R:fE x.^Z YU0 `xinteger` int(11) default NULL,51Testing软件测试网{+~4`)U1W!Sd(wH/lmKp@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%?'l O5}0
H:X0cer0 `xdouble` double default NULL,*ec s{I+I Spm0RPI051Testing软件测试网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|2h sD051Testing软件测试网^*VZd{^Ku O
`xdate` date default NULL,51Testing软件测试网2j;U&r*z4cuVd!f8C R2W"d-E7Z6H)Er?0 `xtime` time default NULL,{JsR.l3j5JcX0
/h9Y{2mi|7Otm0 `xyear` year(4) default NULL,51Testing软件测试网/I(S^L)b ui51Testing软件测试网4B,cnKQ9l
`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$iJ3BlPl51Testing软件测试网`]+rK0J!lS%y&k
`xtext` text,$A1F&Q3F*{@051Testing软件测试网 N {1RA:X+[J
`xmediumtext` mediumtext,