荟聚奇文、博采众长、见贤思齐
当前位置:公文素材库 > 计划总结 > 工作总结 > SQL总结

SQL总结

网站:公文素材库 | 时间:2019-05-29 22:29:03 | 移动端:SQL总结

SQL总结

基础增删查改

INSERTINTOtablename(c1,c2,c3…)VALUES(v1,v2,v3…);DELETEFROMtablenameWHEREc1=xxx;SELECTTOP10(PERTENT)*FROMtablenameWHEREc1=xxxGROUPBYc2ORDERBYc3;(选出前10条或者前10%数据,WGO原则)UPDATEtablenameSETc1=v1,c2=v2,c3=v3…;高级查询

(1)查询中含有计算列

SELECTc1,c2,c1*c2ASc3FROMtablename;(2)选出并列数据(不仅选出前10条,并列的c1数据也会显示)SELECTTOP10WITHTIES*FROMtablenameORDERBYc1;(3)选出不重复的数据

SELECTDISTINCTc1FROMtablename;(4)内联查询(将多个表联合查询的方式,显示符合条件的所有数据,左右叠加)SELECTc1,c2,c3FROMtablename1INNERJOIN

tablename2ONtablename1.c4=tablename2.c5INNERJOIN

tablename3ONtablename1.c6=tablename3.c7;(5)左外联(显示左边表中所有记录)

SELECTc1,c2,c3FROMtablename1LEFTOUTERJOINtablename2ONtablename1.c4=tablename2.c5;(6)右外联(显示右边表中所有记录)

SELECTc1,c2,c3FROMtablename1RIGHTOUTERJOINtablename2ONtablename1.c4=tablename2.c5;(7)全联查(显示所有数据)

SELECTc1,c2,c3FROMtablename1FULLOUTERJOINtablename2ONtablename1.c4=tablename2.c5;(8)穿插联接(一表中的记录依次与二表中记录配对显示)SELECT*FROMtablename1CROSSJOINtablename2;(9)判断空值

SELECT*FROMtablenameWHEREc1ISNULL;(10)IN关键字(选出符合c1等于v1,v2,v3…的所有数据)SELECT*FROMtablenameWHEREc1IN(v1,v2,v3….);(11)模糊查询

SELECT*FROMtablenameWHEREc1like‘%v1%’;(%表示N个字符,_表示1个字符)

(12)EXISTS关键字

SELECT*FROMtablename1WHEREEXISTS(

SELECT*FROMtablename2WHEREc1=v1ANDtablename1.c2=tablename2.c3;);

(13)ALL,ANY和SOME关键字(与子查询连用,ANY和SOME相同都是指在进行比较运算符时只要子查询有一行能使结果为真则结果为真;而ALL表示子查询结果必须都为真,结果才为真)

SELECT*FROMtablename1WHEREtablename1.c1=ANY(

SELECTc1FROMtablename2WHEREc2=v2ORc3=v3;);

(14)WITHCUBE关键字(对GROUPBY的分组对象进行数量汇总统计)WITHROLLUP关键字(对查询结果中第一项进行进行数量汇总统计)SELECTc1,c2,c3FROMtablenameWHEREc4>v1GROUPBYc1,c2WITHCUBE(WITHROLLUP);

(15)HAVING关键字(与GROUPBY连用(不连用的话同WHERE,与WHERE的唯一区别是HAVING后可以使用汇总函数).HAVING后写汇总函数)SELECTc1,count(c2)FROMtablenameGROUPBYc1HAVINGcount(c2)>v1;(16)COMPUTE关键字(对汇总函数进行归类,没有by的话进行整体汇总,有by的话进行分类汇总)

SELECTc1,c2,c3FROMtablenameWHEREc1=v1COMPUTESUM(c2)byc3(17)UNION关键字(合并多个查询结果,上下叠加)SELECTc1,c2,c3FROMtablename1UOION

SELECTc1,c2,c3FROMtablename2;UOION

SELECTc1,c2,c3FROMtablename3;ORDERBYc1数据表操作创建表:

CREATETABLEtablename(

c1namec1typeIDENTITY(1,1)PRIMARYKEY,(自增主键)c2namec2typeNOTNULL,(非空)

c3namec3typeDEFAULTvalue,(默认值为value)c4namec4typeUNIQUE,(唯一));

修改表:

ALTERTABLEtablename;ALTER(ADD、DROP)COLUMNc1namec1type;(一可修改表名,二可修改、添加或删除字段)删除表

DROPTABLEtablename;删除表中所有记录

TRUNCATETABLEtablename;T-SQL常用

(1)CASEWHEN关键字

SELECTc1,CASE

WHENc2=60ANDc2

AS

执行T-SQL语句

DLL触发器(修改表时使用,如Create,Alter或Drop)createTriggertrigger1onALLSERVER(DATABASE)FOR数据库表名AS

T-SQL语句

索引

游标

事务和锁

扩展阅读:SQL总结

3.6SQLAlias(别名)3.7SQLJOIN

用于根据两个或多个表中的列之间的关系,从这些表中查询数据。

语法

INNERJOIN:如果表中有至少一个匹配,则返回行

JOIN:如果表中有至少一个匹配,则返回行(与INNERJOIN相同)LEFTJOIN:即使右表中没有匹配,也从左表返回所有的行RIGHTJOIN:即使左表中没有匹配,也从右表返回所有的行FULLJOIN:只要其中一个表中存在匹配,就返回行

实例

"Persons"表:Id_P123"Orders"表:Id_O12345OrderNo7789544678224562456234764Id_P331165LastNameAdamsBushCarterFirstNameJohnGeorgeThomasAddressOxfordStreetFifthAvenueChanganStreetCityLondonNewYorkBeijing

(JOIN)实例

SELECTPersons.LastName,Persons.FirstName,Orders.OrderNo3.15SQLFOREIGNKEY约束

一个表中的FOREIGNKEY指向另一个表中的PRIMARYKEY。FOREIGNKEY约束用于预防破坏表之间连接的动作。

FOREIGNKEY约束也能防止非法数据插入外键列,因为它必须是它指向的那个表中的值之一。

语法

在"Orders"表创建时为"Id_P"列创建FOREIGNKEY:

MySQL:","p":{"h":17.566,"w":53.973,"x":135.036,"y":399.568,"z":31},"ps":{"_enter":1},"s":{"letter-spacing":"-0.064"},"t":"word","r":[11]},{"c":{"ix":0,"iy":0,"iw":663,"ih":36},"p":{"h":36,"w":663,"x":115,"y":431,"z":32},"ps":{"_drop":1},"s":null,"t":"pic"},{"c":{"ix":0,"iy":41,"iw":893,"ih":833},"p":{"h":833,"opacity":1,"w":892.979,"x":0,"y":429,"z":33},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_33.png"},"t":"pic"},{"c":{"ix":0,"iy":879,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":34},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_34.png"},"t":"pic"},{"c":{"ix":0,"iy":886,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":35},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_35.png"},"t":"pic"},{"c":{"ix":0,"iy":893,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":36},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_36.png"},"t":"pic"},{"c":{"ix":0,"iy":900,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":37},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_37.png"},"t":"pic"},{"c":{"ix":0,"iy":907,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":38},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_38.png"},"t":"pic"},{"c":{"ix":0,"iy":914,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":39},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_39.png"},"t":"pic"},{"c":{"ix":0,"iy":921,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":40},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_40.png"},"t":"pic"},{"c":{"ix":0,"iy":928,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":41},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_41.png"},"t":"pic"},{"c":{"ix":0,"iy":935,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":42},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_42.png"},"t":"pic"},{"c":{"ix":0,"iy":942,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":43},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_43.png"},"t":"pic"},{"c":{"ix":0,"iy":949,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":44},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_44.png"},"t":"pic"},{"c":{"ix":0,"iy":956,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":45},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_45.png"},"t":"pic"},{"c":{"ix":0,"iy":963,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":46},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_46.png"},"t":"pic"},{"c":{"ix":0,"iy":970,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":47},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_47.png"},"t":"pic"},{"c":{"ix":0,"iy":977,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":48},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_48.png"},"t":"pic"},{"c":{"ix":0,"iy":984,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":49},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_49.png"},"t":"pic"},{"c":{"ix":0,"iy":991,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":50},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_50.png"},"t":"pic"},{"c":{"ix":0,"iy":998,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":51},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_51.png"},"t":"pic"},{"c":{"ix":0,"iy":1005,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":52},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_52.png"},"t":"pic"},{"c":{"ix":0,"iy":1012,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":53},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_53.png"},"t":"pic"},{"c":{"ix":0,"iy":1019,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":54},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_54.png"},"t":"pic"},{"c":{"ix":0,"iy":1026,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":55},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_55.png"},"t":"pic"},{"c":{"ix":0,"iy":1033,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":56},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_56.png"},"t":"pic"},{"c":{"ix":0,"iy":1040,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":57},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_57.png"},"t":"pic"},{"c":{"ix":0,"iy":1047,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":58},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_58.png"},"t":"pic"},{"c":{"ix":0,"iy":1054,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":59},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_59.png"},"t":"pic"},{"c":{"ix":0,"iy":1061,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":60},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_60.png"},"t":"pic"},{"c":{"ix":0,"iy":1068,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":61},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_61.png"},"t":"pic"},{"c":{"ix":0,"iy":1075,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":62},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_62.png"},"t":"pic"},{"c":{"ix":0,"iy":1082,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":63},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_63.png"},"t":"pic"},{"c":{"ix":0,"iy":1089,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":64},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_64.png"},"t":"pic"},{"c":{"ix":0,"iy":1096,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":65},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_65.png"},"t":"pic"},{"c":{"ix":0,"iy":1103,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":66},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_66.png"},"t":"pic"},{"c":{"ix":0,"iy":1110,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":67},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_67.png"},"t":"pic"},{"c":{"ix":0,"iy":1117,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":68},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_68.png"},"t":"pic"},{"c":{"ix":0,"iy":1124,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":69},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_69.png"},"t":"pic"},{"c":{"ix":0,"iy":1131,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":70},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_70.png"},"t":"pic"},{"c":{"ix":0,"iy":1138,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":71},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_71.png"},"t":"pic"},{"c":{"ix":0,"iy":1145,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":72},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_72.png"},"t":"pic"},{"c":{"ix":0,"iy":1152,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":73},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_73.png"},"t":"pic"},{"c":{"ix":0,"iy":1159,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":74},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_74.png"},"t":"pic"},{"c":{"ix":0,"iy":1166,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":75},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_75.png"},"t":"pic"},{"c":{"ix":0,"iy":1173,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":76},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_76.png"},"t":"pic"},{"c":{"ix":0,"iy":1180,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":77},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_77.png"},"t":"pic"},{"c":{"ix":0,"iy":1187,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":78},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_78.png"},"t":"pic"},{"c":{"ix":0,"iy":1194,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":79},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_79.png"},"t":"pic"},{"c":{"ix":0,"iy":1201,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":80},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_80.png"},"t":"pic"},{"c":{"ix":0,"iy":1208,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":81},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_81.png"},"t":"pic"},{"c":{"ix":0,"iy":1215,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":82},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_82.png"},"t":"pic"},{"c":{"ix":0,"iy":1222,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":83},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_83.png"},"t":"pic"},{"c":{"ix":0,"iy":1229,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":84},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_84.png"},"t":"pic"},{"c":{"ix":0,"iy":1236,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":85},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_85.png"},"t":"pic"},{"c":{"ix":0,"iy":1243,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":86},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_86.png"},"t":"pic"},{"c":{"ix":0,"iy":1250,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":87},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_87.png"},"t":"pic"},{"c":{"ix":0,"iy":1257,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":88},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_88.png"},"t":"pic"},{"c":{"ix":0,"iy":1264,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":89},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_89.png"},"t":"pic"},{"c":{"ix":0,"iy":1271,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":90},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_90.png"},"t":"pic"},{"c":{"ix":0,"iy":1278,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":91},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_91.png"},"t":"pic"},{"c":{"ix":0,"iy":1285,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":92},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_92.png"},"t":"pic"},{"c":{"ix":0,"iy":1292,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":93},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_93.png"},"t":"pic"},{"c":{"ix":0,"iy":1299,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":94},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_94.png"},"t":"pic"},{"c":{"ix":0,"iy":1306,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":95},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_95.png"},"t":"pic"},{"c":{"ix":0,"iy":1313,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":96},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_96.png"},"t":"pic"},{"c":{"ix":0,"iy":1320,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":97},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_97.png"},"t":"pic"},{"c":{"ix":0,"iy":1327,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":98},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_98.png"},"t":"pic"},{"c":{"ix":0,"iy":1334,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":99},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_99.png"},"t":"pic"},{"c":{"ix":0,"iy":1341,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":100},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_100.png"},"t":"pic"},{"c":{"ix":0,"iy":1348,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":101},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_101.png"},"t":"pic"},{"c":{"ix":0,"iy":1355,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":102},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_102.png"},"t":"pic"},{"c":{"ix":0,"iy":1362,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":103},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_103.png"},"t":"pic"},{"c":{"ix":0,"iy":1369,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":104},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_104.png"},"t":"pic"},{"c":{"ix":0,"iy":1376,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":105},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_105.png"},"t":"pic"},{"c":{"ix":0,"iy":1383,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":106},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_106.png"},"t":"pic"},{"c":{"ix":0,"iy":1390,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":107},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_107.png"},"t":"pic"},{"c":{"ix":0,"iy":1397,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":108},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_108.png"},"t":"pic"},{"c":{"ix":0,"iy":1404,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":109},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_109.png"},"t":"pic"},{"c":{"ix":0,"iy":1411,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":110},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_110.png"},"t":"pic"},{"c":{"ix":0,"iy":1418,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":111},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_111.png"},"t":"pic"},{"c":{"ix":0,"iy":1425,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":112},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_112.png"},"t":"pic"},{"c":{"ix":0,"iy":1432,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":113},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_113.png"},"t":"pic"},{"c":{"ix":0,"iy":1439,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":114},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_114.png"},"t":"pic"},{"c":{"ix":0,"iy":1446,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":115},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_115.png"},"t":"pic"},{"c":{"ix":0,"iy":1453,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":116},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_116.png"},"t":"pic"},{"c":{"ix":0,"iy":1460,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":117},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_117.png"},"t":"pic"},{"c":{"ix":0,"iy":1467,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":118},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_118.png"},"t":"pic"},{"c":{"ix":0,"iy":1474,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":119},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_119.png"},"t":"pic"},{"c":{"ix":0,"iy":1481,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":120},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_120.png"},"t":"pic"},{"c":{"ix":0,"iy":1488,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":121},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_121.png"},"t":"pic"},{"c":{"ix":0,"iy":1495,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":122},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_122.png"},"t":"pic"},{"c":{"ix":0,"iy":1502,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":123},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_123.png"},"t":"pic"},{"c":{"ix":0,"iy":1509,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":124},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_124.png"},"t":"pic"},{"c":{"ix":0,"iy":1516,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":125},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_125.png"},"t":"pic"},{"c":{"ix":0,"iy":1523,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":126},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_126.png"},"t":"pic"},{"c":{"ix":0,"iy":1530,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":127},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_127.png"},"t":"pic"},{"c":{"ix":0,"iy":1537,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":128},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_128.png"},"t":"pic"},{"c":{"ix":0,"iy":1544,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":129},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_129.png"},"t":"pic"},{"c":{"ix":0,"iy":1551,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":130},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_130.png"},"t":"pic"},{"c":{"ix":0,"iy":1558,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":131},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_131.png"},"t":"pic"},{"c":{"ix":0,"iy":1565,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":132},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_132.png"},"t":"pic"},{"c":{"ix":0,"iy":1572,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":133},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_133.png"},"t":"pic"},{"c":{"ix":0,"iy":1579,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":134},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_134.png"},"t":"pic"},{"c":{"ix":0,"iy":1586,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":135},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_135.png"},"t":"pic"},{"c":{"ix":0,"iy":1593,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":136},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_136.png"},"t":"pic"},{"c":{"ix":0,"iy":1600,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":137},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_137.png"},"t":"pic"},{"c":{"ix":0,"iy":1607,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":138},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_138.png"},"t":"pic"},{"c":{"ix":0,"iy":1614,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":139},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_139.png"},"t":"pic"},{"c":{"ix":0,"iy":1621,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":140},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_140.png"},"t":"pic"},{"c":{"ix":0,"iy":1628,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":141},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_141.png"},"t":"pic"},{"c":{"ix":0,"iy":1635,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":142},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_142.png"},"t":"pic"},{"c":{"ix":0,"iy":1642,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":143},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_143.png"},"t":"pic"},{"c":{"ix":0,"iy":1649,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":144},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_144.png"},"t":"pic"},{"c":{"ix":0,"iy":1656,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":145},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_145.png"},"t":"pic"},{"c":{"ix":0,"iy":1663,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":146},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_146.png"},"t":"pic"},{"c":{"ix":0,"iy":1670,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":147},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_147.png"},"t":"pic"},{"c":{"ix":0,"iy":1677,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":148},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_148.png"},"t":"pic"},{"c":{"ix":0,"iy":1684,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":149},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_149.png"},"t":"pic"},{"c":{"ix":0,"iy":1691,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":150},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_150.png"},"t":"pic"},{"c":{"ix":0,"iy":1698,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":151},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_151.png"},"t":"pic"},{"c":{"ix":0,"iy":1705,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":152},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_152.png"},"t":"pic"},{"c":{"ix":0,"iy":1712,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":153},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_153.png"},"t":"pic"},{"c":{"ix":0,"iy":1719,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":154},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_154.png"},"t":"pic"},{"c":{"ix":0,"iy":1726,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":155},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_155.png"},"t":"pic"},{"c":{"ix":0,"iy":1733,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":156},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_156.png"},"t":"pic"},{"c":{"ix":0,"iy":1740,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":157},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_157.png"},"t":"pic"},{"c":{"ix":0,"iy":1747,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":158},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_158.png"},"t":"pic"},{"c":{"ix":0,"iy":1754,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":159},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_159.png"},"t":"pic"},{"c":{"ix":0,"iy":1761,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":160},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_160.png"},"t":"pic"},{"c":{"ix":0,"iy":1768,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":161},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_161.png"},"t":"pic"},{"c":{"ix":0,"iy":1775,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":162},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_162.png"},"t":"pic"},{"c":{"ix":0,"iy":1782,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":163},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_163.png"},"t":"pic"},{"c":{"ix":0,"iy":1789,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":164},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_164.png"},"t":"pic"},{"c":{"ix":0,"iy":1796,"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":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":165},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_165.png"},"t":"pic"},{"c":{"ix":0,"iy":1803,"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如需撤销CHECK约束,请使用下面的SQL:

SQLServer/Oracle/MSAccess:","p":{"h":17.566,"w":216.378,"x":135.036,"y":146.623,"z":9},"ps":{"_enter":1},"s":{"letter-spacing":"-0.041"},"t":"word","r":[8]},{"c":{"ix":0,"iy":0,"iw":663,"ih":36},"p":{"h":36,"w":663,"x":115,"y":178,"z":10},"ps":{"_drop":1},"s":null,"t":"pic"},{"c":{"ix":0,"iy":41,"iw":893,"ih":1086},"p":{"h":1086,"opacity":1,"w":892.979,"x":0,"y":176,"z":11},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_11.png"},"t":"pic"},{"c":{"ix":0,"iy":1132,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":12},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_12.png"},"t":"pic"},{"c":{"ix":0,"iy":1139,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":13},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_13.png"},"t":"pic"},{"c":{"ix":0,"iy":1146,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":14},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_14.png"},"t":"pic"},{"c":{"ix":0,"iy":1153,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":15},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_15.png"},"t":"pic"},{"c":{"ix":0,"iy":1160,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":16},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_16.png"},"t":"pic"},{"c":{"ix":0,"iy":1167,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":17},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_17.png"},"t":"pic"},{"c":{"ix":0,"iy":1174,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":18},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_18.png"},"t":"pic"},{"c":{"ix":0,"iy":1181,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":19},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_19.png"},"t":"pic"},{"c":{"ix":0,"iy":1188,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":20},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_20.png"},"t":"pic"},{"c":{"ix":0,"iy":1195,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":21},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_21.png"},"t":"pic"},{"c":{"ix":0,"iy":1202,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":22},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_22.png"},"t":"pic"},{"c":{"ix":0,"iy":1209,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":23},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_23.png"},"t":"pic"},{"c":{"ix":0,"iy":1216,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":24},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_24.png"},"t":"pic"},{"c":{"ix":0,"iy":1223,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":25},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_25.png"},"t":"pic"},{"c":{"ix":0,"iy":1230,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":26},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_26.png"},"t":"pic"},{"c":{"ix":0,"iy":1237,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":27},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_27.png"},"t":"pic"},{"c":{"ix":0,"iy":1244,"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":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":28},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_28.png"},"t":"pic"},{"c":{"ix":0,"iy":1251,"iw":4,"ih":2},"p":{"h":2,"opacity":Yes/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"到","p":{"h":13.5,"w":13.5,"x":575.61,"y":936.793,"注释:支持的范围是从"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总结:该篇文章建议您自主创作。

来源:网络整理 免责声明:本文仅限学习分享,如产生版权问题,请联系我们及时删除。


SQL总结》由互联网用户整理提供,转载分享请保留原作者信息,谢谢!
链接地址:http://www.bsmz.net/gongwen/747412.html