SQL总结
SQL总结
1、英语缩写解释:1-2章
RDB(关系型数据库)DBMS(数据库管理系统)DBA(数据库管理员)OS(操作系统)DDL(数据定义语言)DQL(数据查询语言)DCL(数据控制语言)DML(数据操作语言)PK(主键)FK(外键)
1NF-3NF(第一范式至第三范式)BCNF(扩展的第三范式)B/S(浏览器/服务器模式)C/S(客户/服务器模式)BDC(备份域控制器)PDC(主域控制器)2、选择题:1-2章8章
3、连线题:1-2章8章
sp_addtype:创建用户自定义数据类型sp_help:查看用户自定义数据类型sp_rename:重命名用户自定义数据类型sp_dorptype:删除用户自定义数据类型sp_who[]:查看制定登录用户的信息sp_changedbowner:更改数据库所有者sp_spacecused:查看有关数据库所占空间信息sp_dpoption:显示或更改数据库选项sp_bindefauit:绑定已创建的默认值sp_unbindefault:解除绑定
sp_grantbaccess/hlepuser/revokedbaccss/:创建/查看/删除数据库用户constraint约束index索引
databases数据库简写db4、程序题三章八章建立数据库CreatedatabasejwglOn
Primary(name=数据文件名,filename=‘储存地址.mdf’,Size=储存大小,Maxsize=最大大小,
Filegrowth=%)主要文件
(name=数据文件名,filename=‘储存地址.mdf’,Size=储存大小,Maxsize=最大大小,Filegrowth=%)辅助文件Logon
(name=日志文件名,filename=‘储存地址.ldf’,Size=储存大小,Maxsize=最大大小,Filegrowth=%)Go
Drop删除
Database数据库Table表创建表UsejwglGo
Createtable表名(列名类型是否空……………………)
管理约束Createtabletable_name
Default缺省约束default缺省值for列名Check检查约束check(布尔)
Primarykey主键约束primarykeyclurtered(列名)Clurtered聚簇索引nonclurtered非聚簇索引Unique唯一约束
插入数据
Insertinto表名(插入的数据列名)Values
(插入数据信息)
更新数据Update表名Set新信息Where条件
删除数据Deletefrom表名Where删除条件信息
8-13到8-25SelectFromWhereGroupbyHavingOrderby5、简答题
(1)、使用select语言时应注意以下几点:
答:a、必须按照正确的顺序指定select语句中的子句;b、对数据库对象的每个引用必须具有唯一性;c、在执行select语句时,对象所驻留的数据库不一定总是当前数据库。若要确保总时使用正确的对象,则不论是当前数据库是如何设置的,均在使用数据库和所有者来限制对象名称;d、在from子句中所有指定的表或试图可能有相同的列名,外键很可能和相关的主键同名。加上对象名称来限定列名可解决重复列名称的问题。(2)、主键约束与唯一约束的区别
答:主键约束保证某一列或组列值的组合相对于表中的每一行都是唯一的,这些列就是表的主键。主键不允许有重复值。也不允许有空值。唯一约束限制中指定列上所有的非空值必须唯一,即表中任意两行在指定列上都不允许有相同的值。
区别:1)唯一约束与主键约束都为指定的列建立唯一索引,既不允许唯一索引的列上有相同的值。主键约束限制更严格,不但不允许有重复值,而且也不允许有空值;2)唯一约束与主键约束产生的索引可以是聚簇索引,也可以是非聚簇索引,但是在缺省情况下,唯一约束产生非聚簇索引,主键约束产生聚簇索引。6.5.1数据的完整概念
扩展阅读:SQL总结
3.6SQLAlias(别名)3.7SQLJOIN
用于根据两个或多个表中的列之间的关系,从这些表中查询数据。
语法
INNERJOIN:如果表中有至少一个匹配,则返回行
JOIN:如果表中有至少一个匹配,则返回行(与INNERJOIN相同)LEFTJOIN:即使右表中没有匹配,也从左表返回所有的行RIGHTJOIN:即使左表中没有匹配,也从右表返回所有的行FULLJOIN:只要其中一个表中存在匹配,就返回行
实例
"Persons"表:Id_P123"Orders"表:Id_O12345OrderNo7789544678224562456234764Id_P331165LastNameAdamsBushCarterFirstNameJohnGeorgeThomasAddressOxfordStreetFifthAvenueChanganStreetCityLondonNewYorkBeijing
(JOIN)实例
SELECTPersons.LastName,Persons.FirstName,Orders.OrderNo":[{"c":{"ix":0,"iy":0,"iw":663,"ih":37},"p":{"h":37,"w":663,"x":115,"y":108,"z":1},"ps":{"_drop":1},"s":null,"t":"pic"},{"c":{"ix":0,"iy":42,"iw":893,"ih":3},"p":{"h":3,"opacity":1,"w":892.979,"x":0,"y":107,"z":2},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_2.png"},"t":"pic"},{"c":{"ix":0,"iy":50,"iw":2,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":1.079,"x":119.916,"x0":119.916,"x1":119.916,"x2":120.996,"x3":120.996,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":3},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_3.png"},"t":"pic"},{"c":{"ix":0,"iy":57,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":120.996,"x0":120.996,"x1":120.996,"x2":123.156,"x3":123.156,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":4},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_4.png"},"t":"pic"},{"c":{"ix":0,"iy":64,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":123.156,"x0":123.156,"x1":123.156,"x2":125.316,"x3":125.316,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":5},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_5.png"},"t":"pic"},{"c":{"ix":0,"iy":71,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":125.316,"x0":125.316,"x1":125.316,"x2":127.476,"x3":127.476,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":6},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_6.png"},"t":"pic"},{"c":{"ix":0,"iy":78,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":127.476,"x0":127.476,"x1":127.476,"x2":129.636,"x3":129.636,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":7},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_7.png"},"t":"pic"},{"c":{"ix":0,"iy":85,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":129.636,"x0":129.636,"x1":129.636,"x2":131.796,"x3":131.796,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":8},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_8.png"},"t":"pic"},{"c":{"ix":0,"iy":92,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":131.796,"x0":131.796,"x1":131.796,"x2":133.956,"x3":133.956,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":9},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_9.png"},"t":"pic"},{"c":{"ix":0,"iy":99,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":133.956,"x0":133.956,"x1":133.956,"x2":136.116,"x3":136.116,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":10},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_10.png"},"t":"pic"},{"c":{"ix":0,"iy":106,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":136.116,"x0":136.116,"x1":136.116,"x2":138.276,"x3":138.276,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":11},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_11.png"},"t":"pic"},{"c":{"ix":0,"iy":113,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":138.276,"x0":138.276,"x1":138.276,"x2":140.436,"x3":140.436,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":12},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_12.png"},"t":"pic"},{"c":{"ix":0,"iy":120,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":140.435,"x0":140.435,"x1":140.435,"x2":142.595,"x3":142.595,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":13},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_13.png"},"t":"pic"},{"c":{"ix":0,"iy":127,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":142.596,"x0":142.596,"x1":142.596,"x2":144.756,"x3":144.756,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":14},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_14.png"},"t":"pic"},{"c":{"ix":0,"iy":134,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":144.756,"x0":144.756,"x1":144.756,"x2":146.916,"x3":146.916,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":15},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_15.png"},"t":"pic"},{"c":{"ix":0,"iy":141,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":146.916,"x0":146.916,"x1":146.916,"x2":149.076,"x3":149.076,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":16},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_16.png"},"t":"pic"},{"c":{"ix":0,"iy":148,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":149.076,"x0":149.076,"x1":149.076,"x2":151.236,"x3":151.236,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":17},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_17.png"},"t":"pic"},{"c":{"ix":0,"iy":155,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":151.23,"x0":151.23,"x1":151.23,"x2":153.39,"x3":153.39,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":18},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_18.png"},"t":"pic"},{"c":{"ix":0,"iy":162,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":153.39,"x0":153.39,"x1":153.39,"x2":155.55,"x3":155.55,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":19},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_19.png"},"t":"pic"},{"c":{"ix":0,"iy":169,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":155.55,"x0":155.55,"x1":155.55,"x2":157.71,"x3":157.71,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":20},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_20.png"},"t":"pic"},{"c":{"ix":0,"iy":176,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":157.71,"x0":157.71,"x1":157.71,"x2":159.87,"x3":159.87,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":21},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_21.png"},"t":"pic"},{"c":{"ix":0,"iy":183,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":159.87,"x0":159.87,"x1":159.87,"x2":162.03,"x3":162.03,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":22},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_22.png"},"t":"pic"},{"c":{"ix":0,"iy":190,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":162.03,"x0":162.03,"x1":162.03,"x2":164.19,"x3":164.19,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":23},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_23.png"},"t":"pic"},{"c":{"ix":0,"iy":197,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":164.19,"x0":164.19,"x1":164.19,"x2":166.35,"x3":166.35,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":24},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_24.png"},"t":"pic"},{"c":{"ix":0,"iy":204,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":166.35,"x0":166.35,"x1":166.35,"x2":168.51,"x3":168.51,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":25},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_25.png"},"t":"pic"},{"c":{"ix":0,"iy":211,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":168.51,"x0":168.51,"x1":168.51,"x2":170.67,"x3":170.67,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":26},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_26.png"},"t":"pic"},{"c":{"ix":0,"iy":218,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":170.67,"x0":170.67,"x1":170.67,"x2":172.83,"x3":172.83,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":27},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_27.png"},"t":"pic"},{"c":{"ix":0,"iy":225,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":172.829,"x0":172.829,"x1":172.829,"x2":174.989,"x3":174.989,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":28},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_28.png"},"t":"pic"},{"c":{"ix":0,"iy":232,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":174.99,"x0":174.99,"x1":174.99,"x2":177.15,"x3":177.15,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":29},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_29.png"},"t":"pic"},{"c":{"ix":0,"iy":239,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":177.149,"x0":177.149,"x1":177.149,"x2":179.309,"x3":179.309,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":30},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_30.png"},"t":"pic"},{"c":{"ix":0,"iy":246,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":179.31,"x0":179.31,"x1":179.31,"x2":181.47,"x3":181.47,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":31},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_31.png"},"t":"pic"},{"c":{"ix":0,"iy":253,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":181.47,"x0":181.47,"x1":181.47,"x2":183.63,"x3":183.63,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":32},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_32.png"},"t":"pic"},{"c":{"ix":0,"iy":260,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":183.63,"x0":183.63,"x1":183.63,"x2":185.79,"x3":185.79,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":33},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_33.png"},"t":"pic"},{"c":{"ix":0,"iy":267,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":185.79,"x0":185.79,"x1":185.79,"x2":187.95,"x3":187.95,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":34},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_34.png"},"t":"pic"},{"c":{"ix":0,"iy":274,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":187.95,"x0":187.95,"x1":187.95,"x2":190.109,"x3":190.109,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":35},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_35.png"},"t":"pic"},{"c":{"ix":0,"iy":281,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":190.11,"x0":190.11,"x1":190.11,"x2":192.27,"x3":192.27,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":36},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_36.png"},"t":"pic"},{"c":{"ix":0,"iy":288,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":192.27,"x0":192.27,"x1":192.27,"x2":194.43,"x3":194.43,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":37},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_37.png"},"t":"pic"},{"c":{"ix":0,"iy":295,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":194.43,"x0":194.43,"x1":194.43,"x2":196.59,"x3":196.59,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":38},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_38.png"},"t":"pic"},{"c":{"ix":0,"iy":302,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":196.59,"x0":196.59,"x1":196.59,"x2":198.75,"x3":198.75,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":39},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_39.png"},"t":"pic"},{"c":{"ix":0,"iy":309,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":198.75,"x0":198.75,"x1":198.75,"x2":200.91,"x3":200.91,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":40},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_40.png"},"t":"pic"},{"c":{"ix":0,"iy":316,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":200.91,"x0":200.91,"x1":200.91,"x2":203.07,"x3":203.07,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":41},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_41.png"},"t":"pic"},{"c":{"ix":0,"iy":323,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":203.07,"x0":203.07,"x1":203.07,"x2":205.23,"x3":205.23,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":42},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_42.png"},"t":"pic"},{"c":{"ix":0,"iy":330,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":205.23,"x0":205.23,"x1":205.23,"x2":207.39,"x3":207.39,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":43},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_43.png"},"t":"pic"},{"c":{"ix":0,"iy":337,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":207.39,"x0":207.39,"x1":207.39,"x2":209.549,"x3":209.549,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":44},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_44.png"},"t":"pic"},{"c":{"ix":0,"iy":344,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":209.549,"x0":209.549,"x1":209.549,"x2":211.709,"x3":211.709,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":45},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_45.png"},"t":"pic"},{"c":{"ix":0,"iy":351,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":211.709,"x0":211.709,"x1":211.709,"x2":213.869,"x3":213.869,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":46},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_46.png"},"t":"pic"},{"c":{"ix":0,"iy":358,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":213.87,"x0":213.87,"x1":213.87,"x2":216.03,"x3":216.03,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":47},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_47.png"},"t":"pic"},{"c":{"ix":0,"iy":365,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":216.03,"x0":216.03,"x1":216.03,"x2":218.19,"x3":218.19,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":48},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_48.png"},"t":"pic"},{"c":{"ix":0,"iy":372,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":218.19,"x0":218.19,"x1":218.19,"x2":220.35,"x3":220.35,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":49},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_49.png"},"t":"pic"},{"c":{"ix":0,"iy":379,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":220.35,"x0":220.35,"x1":220.35,"x2":222.51,"x3":222.51,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":50},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_50.png"},"t":"pic"},{"c":{"ix":0,"iy":386,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":222.51,"x0":222.51,"x1":222.51,"x2":224.67,"x3":224.67,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":51},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_51.png"},"t":"pic"},{"c":{"ix":0,"iy":393,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":224.67,"x0":224.67,"x1":224.67,"x2":226.83,"x3":226.83,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":52},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_52.png"},"t":"pic"},{"c":{"ix":0,"iy":400,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":226.829,"x0":226.829,"x1":226.829,"x2":228.989,"x3":228.989,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":53},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_53.png"},"t":"pic"},{"c":{"ix":0,"iy":407,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":228.99,"x0":228.99,"x1":228.99,"x2":231.15,"x3":231.15,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":54},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_54.png"},"t":"pic"},{"c":{"ix":0,"iy":414,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":231.149,"x0":231.149,"x1":231.149,"x2":233.309,"x3":233.309,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":55},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_55.png"},"t":"pic"},{"c":{"ix":0,"iy":421,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":233.31,"x0":233.31,"x1":233.31,"x2":235.47,"x3":235.47,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":56},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_56.png"},"t":"pic"},{"c":{"ix":0,"iy":428,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":235.47,"x0":235.47,"x1":235.47,"x2":237.63,"x3":237.63,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":57},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_57.png"},"t":"pic"},{"c":{"ix":0,"iy":435,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":237.63,"x0":237.63,"x1":237.63,"x2":239.79,"x3":239.79,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":58},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_58.png"},"t":"pic"},{"c":{"ix":0,"iy":442,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.195,"x":239.79,"x0":239.79,"x1":239.79,"x2":241.986,"x3":241.986,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":59},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_59.png"},"t":"pic"},{"c":{"ix":0,"iy":449,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":241.995,"x0":241.995,"x1":241.995,"x2":244.155,"x3":244.155,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":60},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_60.png"},"t":"pic"},{"c":{"ix":0,"iy":456,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":244.154,"x0":244.154,"x1":244.154,"x2":246.314,"x3":246.314,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":61},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_61.png"},"t":"pic"},{"c":{"ix":0,"iy":463,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":246.314,"x0":246.314,"x1":246.314,"x2":248.474,"x3":248.474,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":62},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_62.png"},"t":"pic"},{"c":{"ix":0,"iy":470,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":248.475,"x0":248.475,"x1":248.475,"x2":250.635,"x3":250.635,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":63},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_63.png"},"t":"pic"},{"c":{"ix":0,"iy":477,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":250.635,"x0":250.635,"x1":250.635,"x2":252.795,"x3":252.795,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":64},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_64.png"},"t":"pic"},{"c":{"ix":0,"iy":484,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":252.795,"x0":252.795,"x1":252.795,"x2":254.955,"x3":254.955,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":65},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_65.png"},"t":"pic"},{"c":{"ix":0,"iy":491,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":254.954,"x0":254.954,"x1":254.954,"x2":257.115,"x3":257.115,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":66},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_66.png"},"t":"pic"},{"c":{"ix":0,"iy":498,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":257.115,"x0":257.115,"x1":257.115,"x2":259.275,"x3":259.275,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":67},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_67.png"},"t":"pic"},{"c":{"ix":0,"iy":505,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":259.275,"x0":259.275,"x1":259.275,"x2":261.435,"x3":261.435,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":68},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_68.png"},"t":"pic"},{"c":{"ix":0,"iy":512,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":261.435,"x0":261.435,"x1":261.435,"x2":263.595,"x3":263.595,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":69},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_69.png"},"t":"pic"},{"c":{"ix":0,"iy":519,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":263.594,"x0":263.594,"x1":263.594,"x2":265.755,"x3":265.755,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":70},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_70.png"},"t":"pic"},{"c":{"ix":0,"iy":526,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":265.755,"x0":265.755,"x1":265.755,"x2":267.915,"x3":267.915,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":71},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_71.png"},"t":"pic"},{"c":{"ix":0,"iy":533,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":267.914,"x0":267.914,"x1":267.914,"x2":270.075,"x3":270.075,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":72},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_72.png"},"t":"pic"},{"c":{"ix":0,"iy":540,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":270.075,"x0":270.075,"x1":270.075,"x2":272.235,"x3":272.235,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":73},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_73.png"},"t":"pic"},{"c":{"ix":0,"iy":547,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":272.235,"x0":272.235,"x1":272.235,"x2":274.395,"x3":274.395,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":74},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_74.png"},"t":"pic"},{"c":{"ix":0,"iy":554,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":274.395,"x0":274.395,"x1":274.395,"x2":276.555,"x3":276.555,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":75},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_75.png"},"t":"pic"},{"c":{"ix":0,"iy":561,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":276.555,"x0":276.555,"x1":276.555,"x2":278.715,"x3":278.715,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":76},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_76.png"},"t":"pic"},{"c":{"ix":0,"iy":568,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":278.715,"x0":278.715,"x1":278.715,"x2":280.875,"x3":280.875,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":77},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_77.png"},"t":"pic"},{"c":{"ix":0,"iy":575,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":280.875,"x0":280.875,"x1":280.875,"x2":283.035,"x3":283.035,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":78},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_78.png"},"t":"pic"},{"c":{"ix":0,"iy":582,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":283.034,"x0":283.034,"x1":283.034,"x2":285.195,"x3":285.195,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":79},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_79.png"},"t":"pic"},{"c":{"ix":0,"iy":589,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":285.195,"x0":285.195,"x1":285.195,"x2":287.355,"x3":287.355,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":80},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_80.png"},"t":"pic"},{"c":{"ix":0,"iy":596,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":287.355,"x0":287.355,"x1":287.355,"x2":289.515,"x3":289.515,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":81},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_81.png"},"t":"pic"},{"c":{"ix":0,"iy":603,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":289.515,"x0":289.515,"x1":289.515,"x2":291.675,"x3":291.675,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":82},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_82.png"},"t":"pic"},{"c":{"ix":0,"iy":610,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":291.675,"x0":291.675,"x1":291.675,"x2":293.835,"x3":293.835,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":83},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_83.png"},"t":"pic"},{"c":{"ix":0,"iy":617,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":293.835,"x0":293.835,"x1":293.835,"x2":295.995,"x3":295.995,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":84},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_84.png"},"t":"pic"},{"c":{"ix":0,"iy":624,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":295.995,"x0":295.995,"x1":295.995,"x2":298.155,"x3":298.155,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":85},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_85.png"},"t":"pic"},{"c":{"ix":0,"iy":631,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":298.155,"x0":298.155,"x1":298.155,"x2":300.315,"x3":300.315,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":86},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_86.png"},"t":"pic"},{"c":{"ix":0,"iy":638,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":300.314,"x0":300.314,"x1":300.314,"x2":302.474,"x3":302.474,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":87},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_87.png"},"t":"pic"},{"c":{"ix":0,"iy":645,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":302.475,"x0":302.475,"x1":302.475,"x2":304.635,"x3":304.635,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":88},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_88.png"},"t":"pic"},{"c":{"ix":0,"iy":652,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":304.635,"x0":304.635,"x1":304.635,"x2":306.795,"x3":306.795,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":89},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_89.png"},"t":"pic"},{"c":{"ix":0,"iy":659,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":306.795,"x0":306.795,"x1":306.795,"x2":308.955,"x3":308.955,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":90},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_90.png"},"t":"pic"},{"c":{"ix":0,"iy":666,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":308.955,"x0":308.955,"x1":308.955,"x2":311.115,"x3":311.115,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":91},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_91.png"},"t":"pic"},{"c":{"ix":0,"iy":673,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":311.115,"x0":311.115,"x1":311.115,"x2":313.275,"x3":313.275,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":92},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_92.png"},"t":"pic"},{"c":{"ix":0,"iy":680,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":313.275,"x0":313.275,"x1":313.275,"x2":315.435,"x3":315.435,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":93},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_93.png"},"t":"pic"},{"c":{"ix":0,"iy":687,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":315.435,"x0":315.435,"x1":315.435,"x2":317.595,"x3":317.595,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":94},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_94.png"},"t":"pic"},{"c":{"ix":0,"iy":694,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":317.594,"x0":317.594,"x1":317.594,"x2":319.755,"x3":319.755,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":95},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_95.png"},"t":"pic"},{"c":{"ix":0,"iy":701,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":319.755,"x0":319.755,"x1":319.755,"x2":321.915,"x3":321.915,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":96},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_96.png"},"t":"pic"},{"c":{"ix":0,"iy":708,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":321.914,"x0":321.914,"x1":321.914,"x2":324.075,"x3":324.075,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":97},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_97.png"},"t":"pic"},{"c":{"ix":0,"iy":715,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":324.075,"x0":324.075,"x1":324.075,"x2":326.235,"x3":326.235,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":98},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_98.png"},"t":"pic"},{"c":{"ix":0,"iy":722,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":326.235,"x0":326.235,"x1":326.235,"x2":328.395,"x3":328.395,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":99},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_99.png"},"t":"pic"},{"c":{"ix":0,"iy":729,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":328.395,"x0":328.395,"x1":328.395,"x2":330.555,"x3":330.555,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":100},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_100.png"},"t":"pic"},{"c":{"ix":0,"iy":736,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":330.555,"x0":330.555,"x1":330.555,"x2":332.715,"x3":332.715,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":101},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_101.png"},"t":"pic"},{"c":{"ix":0,"iy":743,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":332.715,"x0":332.715,"x1":332.715,"x2":334.875,"x3":334.875,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":102},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_102.png"},"t":"pic"},{"c":{"ix":0,"iy":750,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":334.875,"x0":334.875,"x1":334.875,"x2":337.035,"x3":337.035,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":103},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_103.png"},"t":"pic"},{"c":{"ix":0,"iy":757,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":337.034,"x0":337.034,"x1":337.034,"x2":339.195,"x3":339.195,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":104},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_104.png"},"t":"pic"},{"c":{"ix":0,"iy":764,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":339.195,"x0":339.195,"x1":339.195,"x2":341.355,"x3":341.355,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":105},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_105.png"},"t":"pic"},{"c":{"ix":0,"iy":771,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":341.355,"x0":341.355,"x1":341.355,"x2":343.515,"x3":343.515,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":106},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_106.png"},"t":"pic"},{"c":{"ix":0,"iy":778,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":343.515,"x0":343.515,"x1":343.515,"x2":345.675,"x3":345.675,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":107},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_107.png"},"t":"pic"},{"c":{"ix":0,"iy":785,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":345.675,"x0":345.675,"x1":345.675,"x2":347.835,"x3":347.835,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":108},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_108.png"},"t":"pic"},{"c":{"ix":0,"iy":792,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":347.835,"x0":347.835,"x1":347.835,"x2":349.995,"x3":349.995,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":109},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_109.png"},"t":"pic"},{"c":{"ix":0,"iy":799,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":349.995,"x0":349.995,"x1":349.995,"x2":352.155,"x3":352.155,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":110},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_110.png"},"t":"pic"},{"c":{"ix":0,"iy":806,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":352.155,"x0":352.155,"x1":352.155,"x2":354.315,"x3":354.315,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":111},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_111.png"},"t":"pic"},{"c":{"ix":0,"iy":813,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":354.314,"x0":354.314,"x1":354.314,"x2":356.474,"x3":356.474,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":112},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_112.png"},"t":"pic"},{"c":{"ix":0,"iy":820,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":356.475,"x0":356.475,"x1":356.475,"x2":358.635,"x3":358.635,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":113},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_113.png"},"t":"pic"},{"c":{"ix":0,"iy":827,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":358.635,"x0":358.635,"x1":358.635,"x2":360.795,"x3":360.795,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":114},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_114.png"},"t":"pic"},{"c":{"ix":0,"iy":834,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":360.795,"x0":360.795,"x1":360.795,"x2":362.955,"x3":362.955,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":115},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_115.png"},"t":"pic"},{"c":{"ix":0,"iy":841,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":362.955,"x0":362.955,"x1":362.955,"x2":365.115,"x3":365.115,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":116},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_116.png"},"t":"pic"},{"c":{"ix":0,"iy":848,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":365.115,"x0":365.115,"x1":365.115,"x2":367.275,"x3":367.275,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":117},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_117.png"},"t":"pic"},{"c":{"ix":0,"iy":855,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":367.275,"x0":367.275,"x1":367.275,"x2":369.435,"x3":369.435,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":118},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_118.png"},"t":"pic"},{"c":{"ix":0,"iy":862,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":369.435,"x0":369.435,"x1":369.435,"x2":371.595,"x3":371.595,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":119},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_119.png"},"t":"pic"},{"c":{"ix":0,"iy":869,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":371.594,"x0":371.594,"x1":371.594,"x2":373.755,"x3":373.755,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":120},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_120.png"},"t":"pic"},{"c":{"ix":0,"iy":876,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":373.755,"x0":373.755,"x1":373.755,"x2":375.915,"x3":375.915,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":121},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_121.png"},"t":"pic"},{"c":{"ix":0,"iy":883,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":375.914,"x0":375.914,"x1":375.914,"x2":378.075,"x3":378.075,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":122},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_122.png"},"t":"pic"},{"c":{"ix":0,"iy":890,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":378.075,"x0":378.075,"x1":378.075,"x2":380.235,"x3":380.235,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":123},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_123.png"},"t":"pic"},{"c":{"ix":0,"iy":897,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":380.235,"x0":380.235,"x1":380.235,"x2":382.395,"x3":382.395,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":124},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_124.png"},"t":"pic"},{"c":{"ix":0,"iy":904,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":382.395,"x0":382.395,"x1":382.395,"x2":384.555,"x3":384.555,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":125},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_125.png"},"t":"pic"},{"c":{"ix":0,"iy":911,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":384.555,"x0":384.555,"x1":384.555,"x2":386.715,"x3":386.715,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":126},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_126.png"},"t":"pic"},{"c":{"ix":0,"iy":918,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":386.715,"x0":386.715,"x1":386.715,"x2":388.875,"x3":388.875,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":127},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_127.png"},"t":"pic"},{"c":{"ix":0,"iy":925,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":388.875,"x0":388.875,"x1":388.875,"x2":391.035,"x3":391.035,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":128},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_128.png"},"t":"pic"},{"c":{"ix":0,"iy":932,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":391.034,"x0":391.034,"x1":391.034,"x2":393.195,"x3":393.195,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":129},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_129.png"},"t":"pic"},{"c":{"ix":0,"iy":939,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":393.195,"x0":393.195,"x1":393.195,"x2":395.355,"x3":395.355,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":130},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_130.png"},"t":"pic"},{"c":{"ix":0,"iy":946,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":395.355,"x0":395.355,"x1":395.355,"x2":397.515,"x3":397.515,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":131},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_131.png"},"t":"pic"},{"c":{"ix":0,"iy":953,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":397.515,"x0":397.515,"x1":397.515,"x2":399.675,"x3":399.675,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":132},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_132.png"},"t":"pic"},{"c":{"ix":0,"iy":960,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.196,"x":399.674,"x0":399.674,"x1":399.674,"x2":401.871,"x3":401.871,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":133},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_133.png"},"t":"pic"},{"c":{"ix":0,"iy":967,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":401.864,"x0":401.864,"x1":401.864,"x2":404.025,"x3":404.025,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":134},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_134.png"},"t":"pic"},{"c":{"ix":0,"iy":974,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":404.025,"x0":404.025,"x1":404.025,"x2":406.185,"x3":406.185,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":135},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_135.png"},"t":"pic"},{"c":{"ix":0,"iy":981,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":406.184,"x0":406.184,"x1":406.184,"x2":408.344,"x3":408.344,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":136},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_136.png"},"t":"pic"},{"c":{"ix":0,"iy":988,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":408.344,"x0":408.344,"x1":408.344,"x2":410.504,"x3":410.504,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":137},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_137.png"},"t":"pic"},{"c":{"ix":0,"iy":995,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":410.505,"x0":410.505,"x1":410.505,"x2":412.665,"x3":412.665,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":138},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_138.png"},"t":"pic"},{"c":{"ix":0,"iy":1002,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":412.665,"x0":412.665,"x1":412.665,"x2":414.825,"x3":414.825,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":139},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_139.png"},"t":"pic"},{"c":{"ix":0,"iy":1009,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":414.825,"x0":414.825,"x1":414.825,"x2":416.985,"x3":416.985,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":140},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_140.png"},"t":"pic"},{"c":{"ix":0,"iy":1016,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":416.984,"x0":416.984,"x1":416.984,"x2":419.144,"x3":419.144,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":141},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_141.png"},"t":"pic"},{"c":{"ix":0,"iy":1023,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":419.144,"x0":419.144,"x1":419.144,"x2":421.304,"x3":421.304,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":142},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_8_142.png"},"t":"pic"},{"c":{"ix":0,"iy":1030,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":421.305,"x0":421.305,"x1":421.305,"x2":423.465,"x3":423.465,"y":108语法","p":{"h":15.84,"w":3.579,"x":166.71,"y":111.853,"z":2},"ps":{"_enter":1},"t":"word","r":[7]},{"c":{"ix":0,"iy":0,"iw":663,"ih":36},"p":{"h":36,"w":663,"x":115,"y":143,"z":3},"ps":{"_drop":1},"s":null,"t":"pic"},{"c":{"ix":0,"iy":41,"iw":893,"ih":3},"p":{"h":3,"opacity":1,"w":892.979,"x":0,"y":141,"z":4},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_28_4.png"},"t":"pic"},{"c":{"ix":0,"iy":49,"iw":2,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":1.079,"x":119.916,"x0":119.916,"x1":119.916,"x2":120.996,"x3":120.996,"y":142.77,"y0":143.849,"y1":142.77,"y2":142.77,"y3":143.849,"z":5},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_28_5.png"},"t":"pic"},{"c":{"ix":0,"iy":56,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":120.996,"x0":120.996,"x1":120.996,"x2":123.156,"x3":123.156,"y":142.77,"y0":143.849,"y1":142.77,"y2":142.77,"y3":143.849,"z":6},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_28_6.png"},"t":"pic"},{"c":{"ix":0,"iy":63,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":123.156,"x0":123.156,"x1":123.156,"x2":125.316,"x3":125.316,"y":142.77,"y0":143.849,"y1":142.77,"y2":142.77,"y3":143.849,"z":7},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//9567165Yes/No逻辑字段,可以显示为Yes/No、True/False或On/Off。在代码中,使用常量True和False(等价于1和0)注释:Yes/No字段中不允许Null值1比特OleObjectHyperlinkLookupWizard可以存储图片、音频、视频或其他BLOBs(BinaryLargeOBjects)包含指向其他文件的链接,包括网页。允许你创建一个可从下列列表中进行选择的选项列表。最多1GB4字节MySQL数据类型
在MySQL中,有三种主要的类型:文本、数字和日期/时间类型。Text类型:数据类型CHAR(size)描述保存固定长度的字符串(可包含字母、数字以及特殊字符)。在括号中指定字符串的长度。最多255个字符。VARCHAR(size)保存可变长度的字符串(可包含字母、数字以及特殊字符)。在括号中指定字符串的最大长度。最多255个字符。注释:如果值的长度大于255,则被转换为TEXT类型。TINYTEXTTEXTBLOBMEDIUMTEXTMEDIUMBLOBLONGTEXTLONGBLOBENUM(x,y,z,etc.)存放最大长度为255个字符的字符串。存放最大长度为65,535个字符的字符串。用于BLOBs(BinaryLargeOBjects)。存放最多65,535字节的数据。存放最大长度为16,777,215个字符的字符串。用于BLOBs(BinaryLargeOBjects)。存放最多16,777,215字节的数据。存放最大长度为4,294,967,295个字符的字符串。用于BLOBs(BinaryLargeOBjects)。存放最多4,294,967,295字节的数据。允许你输入可能值的列表。可以在ENUM列表中列出最大65535个值。如果列表中不存在插入的值,则插入空值。注释:这些值是按照你输入的顺序存储的。可以按照此格式输入可能的值:ENUM("X","Y","Z")SET与ENUM类似,SET最多只能包含64个列表项,不过SET可存储一个以上的值。Number类型:数据类型TINYINT(size)SMALLINT(size)MEDIUMINT(size)INT(size)描述-128到127常规。0到255无符号*。在括号中规定最大位数。-32768到32767常规。0到65535无符号*。在括号中规定最大位数。-8388608到8388607普通。0to16777215无符号*。在括号中规定最大位数。-2147483648到2147483647常规。0到4294967295无符号*。在括号中规定最大位数。BIGINT(size)-9223372036854775808到9223372036854775807常规。0到18446744073709551615无符号*。在括号中规定最大位数。FLOAT(size,d)带有浮动小数点的小数字。在括号中规定最大位数。在d参数中规定小数点右侧的最大位数。DOUBLE(size,d)带有浮动小数点的大数字。在括号中规定最大位数。在d参数中规定小数点右侧的最大位数。DECIMAL(size,d)作为字符串存储的DOUBLE类型,允许固定的小数点。*这些整数类型拥有额外的选项UNSIGNED。通常,整数可以是负数或正数。如果添加UNSIGNED属性,那么范围将从0开始,而不是某个负数。Date类型:数据类型DATE()描述日期。格式:YYYY-MM-DD注释:支持的范围是从"1000-01-01"到"9999-12-31"DATETIME()*日期和时间的组合。格式:YYYY-MM-DDHH:MM:SS注释:支持的范围是从"1000-01-0100:00:00"到"9999-12-3123:59:59"TIMESTAMP()*时间戳。TIMESTAMP值使用Unix纪元("1970-01-0100:00:00"UTC)至今的描述来存储。格式:YYYY-MM-DDHH:MM:SS注释:支持的范围是从"1970-01-0100:00:01"UTC到"2038-01-0903:14:07"UTCTIME()YEAR()时间。格式:HH:MM:SS注释:支持的范围是从"-838:59:59"到"838:59:59"2位或4位格式的年。注释:4位格式所允许的值:1901到2155。2位格式所允许的值:70到69,表示从1970到2069。*即便DATETIME和TIMESTAMP返回相同的格式,它们的工作方式很不同。在INSERT或UPDATE查询中,TIMESTAMP自动把自身设置为当前的日期和时间。TIMESTAMP也接受不同的格式,比如YYYYMMDDHHMMSS、YYMMDDHHMMSS、YYYYMMDD或YYMMDD。
SQLServer数据类型
Character字符串:数据类型char(n)varchar(n)varchar(max)textUnicode字符串:数据类型nchar(n)nvarchar(n)nvarchar(max)ntextBinary类型:数据类型bit描述允许0、1或NULL存储描述固定长度的Unicode数据。最多4,000个字符。可变长度的Unicode数据。最多4,000个字符。可变长度的Unicode数据。最多536,870,912个字符。可变长度的Unicode数据。最多2GB字符数据。存储描述固定长度的字符串。最多8,000个字符。可变长度的字符串。最多8,000个字符。可变长度的字符串。最多1,073,741,824个字符。可变长度的字符串。最多2GB字符数据。存储nbinary(n)varbinary(n)varbinary(max)imageNumber类型:数据类型
tinyintsmallintintbigint
描述
固定长度的二进制数据。最多8,000字节。可变长度的二进制数据。最多8,000字节。可变长度的二进制数据。最多2GB字节。可变长度的二进制数据。最多2GB。存储
允许从0到255的所有数字。允许从-32,768到32,767的所有数字。
1字节2字节4字节8字节
允许从-2,147,483,648到2,147,483,647的所有数字。
允许介于-9,223,372,036,854,775,808和9,223,372,036,854,775,807之间的所有数字。
decimal(p,s)
固定精度和比例的数字。允许从-10^38+1到10^38-1之间的数
字。
p参数指示可以存储的最大位数(小数点左侧和右侧)。p必须是1
到38之间的值。默认是18。
s参数指示小数点右侧存储的最大位数。s必须是0到p之间的
值。默认是0。
5-17字节
numeric(p,s)
固定精度和比例的数字。允许从-10^38+1到10^38-1之间的数
字。
p参数指示可以存储的最大位数(小数点左侧和右侧)。p必须是1
到38之间的值。默认是18。
s参数指示小数点右侧存储的最大位数。s必须是0到p之间的
值。默认是0。
5-17字节
smallmoneymoney
介于-214,748.3648和214,748.3647之间的货币数据。介于-922,337,203,685,477.5808和922,337,203,685,477.5807
之间的货币数据。
4字节8字节float(n)从-1.79E+308到1.79E+308的浮动精度数字数据。参数n指示该字段保存4字节还是8字节。float(24)保存4字节,而float(53)保存8字节。n的默认值是53。4或8字节realDate类型:数据类型
datetime
描述
从-3.40E+38到3.40E+38的浮动精度数字数据。4字节存储8bytes
从1753年1月1日到9999年12月31日,精度为3.33毫
秒。
datetime2从1753年1月1日到9999年12月31日,精度为100纳
秒。
6-8bytes
smalldatetime
datetimedatetimeoffsettimestamp
从1900年1月1日到2079年6月6日,精度为1分钟。仅存储日期。从0001年1月1日到9999年12月31日。
仅存储时间。精度为100纳秒。与datetime2相同,外加时区偏移。
存储唯一的数字,每当创建或修改某行时,该数字会更新。timestamp基于内部时钟,不对应真实时间。每个表只能有一个timestamp变
量。
4bytes3bytes3-5bytes8-10bytes
其他数据类型:数据类型sql_variantuniqueidentifierxmlcursortable描述存储最多8,000字节不同数据类型的数据,除了text、ntext以及timestamp。存储全局标识符(GUID)。存储XML格式化数据。最多2GB。存储对用于数据库操作的指针的引用。存储结果集,供稍后处理。
FIRST(column)LAST(column)MAX(column)MIN(column)返回在指定的域中第一个记录的值返回在指定的域中最后一个记录的值返回某列的最高值返回某列的最低值返回某列的总和STDEV(column)STDEVP(column)SUM(column)VAR(column)VARP(column)在SQLServer中的合计函数函数AVG(column)描述返回某列的行数返回某列的行数(不包括NULL值)返回被选行数返回相异结果的数目返回在指定的域中第一个记录的值(SQLServer201*不支持)返回在指定的域中最后一个记录的值(SQLServer201*不支持)返回某列的最高值返回某列的最低值BINARY_CHECKSUMCHECKSUMCHECKSUM_AGGCOUNT(column)COUNT(*)COUNT(DISTINCTcolumn)FIRST(column)LAST(column)MAX(column)MIN(column)STDEV(column)STDEVP(column)SUM(column)返回某列的总和VAR(column)VARP(column)Scalar函数
Scalar函数的操作面向某个单一的值,并返回基于输入值的一个单一的值。MSAccess中的Scalar函数函数UCASE(c)LCASE(c)MID(c,start[,end])LEN(c)INSTR(c,char)LEFT(c,number_of_char)RIGHT(c,number_of_char)ROUND(c,decimals)MOD(x,y)NOW()FORMAT(c,format)DATEDIFF(d,date1,date2)描述将某个域转换为大写将某个域转换为小写从某个文本域提取字符返回某个文本域的长度返回在某个文本域中指定字符的数值位置返回某个被请求的文本域的左侧部分返回某个被请求的文本域的右侧部分对某个数值域进行指定小数位数的四舍五入返回除法操作的余数返回当前的系统日期改变某个域的显示方式用于执行日期计算CURDATE()CURTIME()DATE()返回当前的日期返回当前的时间提取日期或日期/时间表达式的日期部分返回日期/时间按的单独部分给日期添加指定的时间间隔从日期减去指定的时间间隔返回两个日期之间的天数用不同的格式显示日期/时间EXTRACT()DATE_ADD()DATE_SUB()DATEDIFF()DATE_FORMAT()SQLServerDate函数
下面的表格列出了SQLServer中最重要的内建日期函数:
函数GETDATE()描述返回当前日期和时间返回日期/时间的单独部分在日期中添加或减去指定的时间间隔返回两个日期之间的时间用不同的格式显示日期/时间DATEPART()DATEADD()DATEDIFF()CONVERT()SQLDate数据类型
MySQL使用下列数据类型在数据库中存储日期或日期/时间值:
DATE-格式YYYY-MM-DD
DATETIME-格式:YYYY-MM-DDHH:MM:SSTIMESTAMP-格式:YYYY-MM-DDHH:MM:SSYEAR-格式YYYY或YY
SQLServer使用下列数据类型在数据库中存储日期或日期/时间值:
DATE-格式YYYY-MM-DDDATETIME-格式:YYYY-MM-DDHH:MM:SSSMALLDATETIME-格式:YYYY-MM-DDHH:MM:SSTIMESTAMP-格式:唯一的数字
友情提示:本文中关于《SQL总结》给出的范例仅供您参考拓展思维使用,SQL总结:该篇文章建议您自主创作。
来源:网络整理 免责声明:本文仅限学习分享,如产生版权问题,请联系我们及时删除。