SQL總結(jié)
SQL總結(jié)
1、英語縮寫解釋:1-2章
RDB(關(guān)系型數(shù)據(jù)庫)DBMS(數(shù)據(jù)庫管理系統(tǒng))DBA(數(shù)據(jù)庫管理員)OS(操作系統(tǒng))DDL(數(shù)據(jù)定義語言)DQL(數(shù)據(jù)查詢語言)DCL(數(shù)據(jù)控制語言)DML(數(shù)據(jù)操作語言)PK(主鍵)FK(外鍵)
1NF-3NF(第一范式至第三范式)BCNF(擴展的第三范式)B/S(瀏覽器/服務(wù)器模式)C/S(客戶/服務(wù)器模式)BDC(備份域控制器)PDC(主域控制器)2、選擇題:1-2章8章
3、連線題:1-2章8章
sp_addtype:創(chuàng)建用戶自定義數(shù)據(jù)類型sp_help:查看用戶自定義數(shù)據(jù)類型sp_rename:重命名用戶自定義數(shù)據(jù)類型sp_dorptype:刪除用戶自定義數(shù)據(jù)類型sp_who[]:查看制定登錄用戶的信息sp_changedbowner:更改數(shù)據(jù)庫所有者sp_spacecused:查看有關(guān)數(shù)據(jù)庫所占空間信息sp_dpoption:顯示或更改數(shù)據(jù)庫選項sp_bindefauit:綁定已創(chuàng)建的默認值sp_unbindefault:解除綁定
sp_grantbaccess/hlepuser/revokedbaccss/:創(chuàng)建/查看/刪除數(shù)據(jù)庫用戶constraint約束index索引
databases數(shù)據(jù)庫簡寫db4、程序題三章八章建立數(shù)據(jù)庫CreatedatabasejwglOn
Primary(name=數(shù)據(jù)文件名,filename=‘儲存地址.mdf’,Size=儲存大小,Maxsize=最大大小,
Filegrowth=%)主要文件
(name=數(shù)據(jù)文件名,filename=‘儲存地址.mdf’,Size=儲存大小,Maxsize=最大大小,F(xiàn)ilegrowth=%)輔助文件Logon
(name=日志文件名,filename=‘儲存地址.ldf’,Size=儲存大小,Maxsize=最大大小,F(xiàn)ilegrowth=%)Go
Drop刪除
Database數(shù)據(jù)庫Table表創(chuàng)建表UsejwglGo
Createtable表名(列名類型是否空……………………)
管理約束Createtabletable_name
Default缺省約束default缺省值for列名Check檢查約束check(布爾)
Primarykey主鍵約束primarykeyclurtered(列名)Clurtered聚簇索引nonclurtered非聚簇索引Unique唯一約束
插入數(shù)據(jù)
Insertinto表名(插入的數(shù)據(jù)列名)Values
(插入數(shù)據(jù)信息)
更新數(shù)據(jù)Update表名Set新信息Where條件
刪除數(shù)據(jù)Deletefrom表名Where刪除條件信息
8-13到8-25SelectFromWhereGroupbyHavingOrderby5、簡答題
(1)、使用select語言時應注意以下幾點:
答:a、必須按照正確的順序指定select語句中的子句;b、對數(shù)據(jù)庫對象的每個引用必須具有唯一性;c、在執(zhí)行select語句時,對象所駐留的數(shù)據(jù)庫不一定總是當前數(shù)據(jù)庫。若要確?倳r使用正確的對象,則不論是當前數(shù)據(jù)庫是如何設(shè)置的,均在使用數(shù)據(jù)庫和所有者來限制對象名稱;d、在from子句中所有指定的表或試圖可能有相同的列名,外鍵很可能和相關(guān)的主鍵同名。加上對象名稱來限定列名可解決重復列名稱的問題。(2)、主鍵約束與唯一約束的區(qū)別
答:主鍵約束保證某一列或組列值的組合相對于表中的每一行都是唯一的,這些列就是表的主鍵。主鍵不允許有重復值。也不允許有空值。唯一約束限制中指定列上所有的非空值必須唯一,即表中任意兩行在指定列上都不允許有相同的值。
區(qū)別:1)唯一約束與主鍵約束都為指定的列建立唯一索引,既不允許唯一索引的列上有相同的值。主鍵約束限制更嚴格,不但不允許有重復值,而且也不允許有空值;2)唯一約束與主鍵約束產(chǎn)生的索引可以是聚簇索引,也可以是非聚簇索引,但是在缺省情況下,唯一約束產(chǎn)生非聚簇索引,主鍵約束產(chǎn)生聚簇索引。6.5.1數(shù)據(jù)的完整概念
擴展閱讀:SQL總結(jié)
3.6SQLAlias(別名)3.7SQLJOIN
用于根據(jù)兩個或多個表中的列之間的關(guān)系,從這些表中查詢數(shù)據(jù)。
語法
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)包含指向其他文件的鏈接,包括網(wǎng)頁。允許你創(chuàng)建一個可從下列列表中進行選擇的選項列表。最多1GB4字節(jié)MySQL數(shù)據(jù)類型
在MySQL中,有三種主要的類型:文本、數(shù)字和日期/時間類型。Text類型:數(shù)據(jù)類型CHAR(size)描述保存固定長度的字符串(可包含字母、數(shù)字以及特殊字符)。在括號中指定字符串的長度。最多255個字符。VARCHAR(size)保存可變長度的字符串(可包含字母、數(shù)字以及特殊字符)。在括號中指定字符串的最大長度。最多255個字符。注釋:如果值的長度大于255,則被轉(zhuǎn)換為TEXT類型。TINYTEXTTEXTBLOBMEDIUMTEXTMEDIUMBLOBLONGTEXTLONGBLOBENUM(x,y,z,etc.)存放最大長度為255個字符的字符串。存放最大長度為65,535個字符的字符串。用于BLOBs(BinaryLargeOBjects)。存放最多65,535字節(jié)的數(shù)據(jù)。存放最大長度為16,777,215個字符的字符串。用于BLOBs(BinaryLargeOBjects)。存放最多16,777,215字節(jié)的數(shù)據(jù)。存放最大長度為4,294,967,295個字符的字符串。用于BLOBs(BinaryLargeOBjects)。存放最多4,294,967,295字節(jié)的數(shù)據(jù)。允許你輸入可能值的列表?梢栽贓NUM列表中列出最大65535個值。如果列表中不存在插入的值,則插入空值。注釋:這些值是按照你輸入的順序存儲的?梢园凑沾烁袷捷斎肟赡艿闹担篍NUM("X","Y","Z")SET與ENUM類似,SET最多只能包含64個列表項,不過SET可存儲一個以上的值。Number類型:數(shù)據(jù)類型TINYINT(size)SMALLINT(size)MEDIUMINT(size)INT(size)描述-128到127常規(guī)。0到255無符號*。在括號中規(guī)定最大位數(shù)。-32768到32767常規(guī)。0到65535無符號*。在括號中規(guī)定最大位數(shù)。-8388608到8388607普通。0to16777215無符號*。在括號中規(guī)定最大位數(shù)。-2147483648到2147483647常規(guī)。0到4294967295無符號*。在括號中規(guī)定最大位數(shù)。BIGINT(size)-9223372036854775808到9223372036854775807常規(guī)。0到18446744073709551615無符號*。在括號中規(guī)定最大位數(shù)。FLOAT(size,d)帶有浮動小數(shù)點的小數(shù)字。在括號中規(guī)定最大位數(shù)。在d參數(shù)中規(guī)定小數(shù)點右側(cè)的最大位數(shù)。DOUBLE(size,d)帶有浮動小數(shù)點的大數(shù)字。在括號中規(guī)定最大位數(shù)。在d參數(shù)中規(guī)定小數(shù)點右側(cè)的最大位數(shù)。DECIMAL(size,d)作為字符串存儲的DOUBLE類型,允許固定的小數(shù)點。*這些整數(shù)類型擁有額外的選項UNSIGNED。通常,整數(shù)可以是負數(shù)或正數(shù)。如果添加UNSIGNED屬性,那么范圍將從0開始,而不是某個負數(shù)。Date類型:數(shù)據(jù)類型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自動把自身設(shè)置為當前的日期和時間。TIMESTAMP也接受不同的格式,比如YYYYMMDDHHMMSS、YYMMDDHHMMSS、YYYYMMDD或YYMMDD。
SQLServer數(shù)據(jù)類型
Character字符串:數(shù)據(jù)類型char(n)varchar(n)varchar(max)textUnicode字符串:數(shù)據(jù)類型nchar(n)nvarchar(n)nvarchar(max)ntextBinary類型:數(shù)據(jù)類型bit描述允許0、1或NULL存儲描述固定長度的Unicode數(shù)據(jù)。最多4,000個字符?勺冮L度的Unicode數(shù)據(jù)。最多4,000個字符?勺冮L度的Unicode數(shù)據(jù)。最多536,870,912個字符。可變長度的Unicode數(shù)據(jù)。最多2GB字符數(shù)據(jù)。存儲描述固定長度的字符串。最多8,000個字符?勺冮L度的字符串。最多8,000個字符?勺冮L度的字符串。最多1,073,741,824個字符。可變長度的字符串。最多2GB字符數(shù)據(jù)。存儲nbinary(n)varbinary(n)varbinary(max)imageNumber類型:數(shù)據(jù)類型
tinyintsmallintintbigint
描述
固定長度的二進制數(shù)據(jù)。最多8,000字節(jié)?勺冮L度的二進制數(shù)據(jù)。最多8,000字節(jié)。可變長度的二進制數(shù)據(jù)。最多2GB字節(jié)?勺冮L度的二進制數(shù)據(jù)。最多2GB。存儲
允許從0到255的所有數(shù)字。允許從-32,768到32,767的所有數(shù)字。
1字節(jié)2字節(jié)4字節(jié)8字節(jié)
允許從-2,147,483,648到2,147,483,647的所有數(shù)字。
允許介于-9,223,372,036,854,775,808和9,223,372,036,854,775,807之間的所有數(shù)字。
decimal(p,s)
固定精度和比例的數(shù)字。允許從-10^38+1到10^38-1之間的數(shù)
字。
p參數(shù)指示可以存儲的最大位數(shù)(小數(shù)點左側(cè)和右側(cè))。p必須是1
到38之間的值。默認是18。
s參數(shù)指示小數(shù)點右側(cè)存儲的最大位數(shù)。s必須是0到p之間的
值。默認是0。
5-17字節(jié)
numeric(p,s)
固定精度和比例的數(shù)字。允許從-10^38+1到10^38-1之間的數(shù)
字。
p參數(shù)指示可以存儲的最大位數(shù)(小數(shù)點左側(cè)和右側(cè))。p必須是1
到38之間的值。默認是18。
s參數(shù)指示小數(shù)點右側(cè)存儲的最大位數(shù)。s必須是0到p之間的
值。默認是0。
5-17字節(jié)
smallmoneymoney
介于-214,748.3648和214,748.3647之間的貨幣數(shù)據(jù)。介于-922,337,203,685,477.5808和922,337,203,685,477.5807
之間的貨幣數(shù)據(jù)。
4字節(jié)8字節(jié)float(n)從-1.79E+308到1.79E+308的浮動精度數(shù)字數(shù)據(jù)。參數(shù)n指示該字段保存4字節(jié)還是8字節(jié)。float(24)保存4字節(jié),而float(53)保存8字節(jié)。n的默認值是53。4或8字節(jié)realDate類型:數(shù)據(jù)類型
datetime
描述
從-3.40E+38到3.40E+38的浮動精度數(shù)字數(shù)據(jù)。4字節(jié)存儲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相同,外加時區(qū)偏移。
存儲唯一的數(shù)字,每當創(chuàng)建或修改某行時,該數(shù)字會更新。timestamp基于內(nèi)部時鐘,不對應真實時間。每個表只能有一個timestamp變
量。
4bytes3bytes3-5bytes8-10bytes
其他數(shù)據(jù)類型:數(shù)據(jù)類型sql_variantuniqueidentifierxmlcursortable描述存儲最多8,000字節(jié)不同數(shù)據(jù)類型的數(shù)據(jù),除了text、ntext以及timestamp。存儲全局標識符(GUID)。存儲XML格式化數(shù)據(jù)。最多2GB。存儲對用于數(shù)據(jù)庫操作的指針的引用。存儲結(jié)果集,供稍后處理。
FIRST(column)LAST(column)MAX(column)MIN(column)返回在指定的域中第一個記錄的值返回在指定的域中最后一個記錄的值返回某列的最高值返回某列的最低值返回某列的總和STDEV(column)STDEVP(column)SUM(column)VAR(column)VARP(column)在SQLServer中的合計函數(shù)函數(shù)AVG(column)描述返回某列的行數(shù)返回某列的行數(shù)(不包括NULL值)返回被選行數(shù)返回相異結(jié)果的數(shù)目返回在指定的域中第一個記錄的值(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函數(shù)
Scalar函數(shù)的操作面向某個單一的值,并返回基于輸入值的一個單一的值。MSAccess中的Scalar函數(shù)函數(shù)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)描述將某個域轉(zhuǎn)換為大寫將某個域轉(zhuǎn)換為小寫從某個文本域提取字符返回某個文本域的長度返回在某個文本域中指定字符的數(shù)值位置返回某個被請求的文本域的左側(cè)部分返回某個被請求的文本域的右側(cè)部分對某個數(shù)值域進行指定小數(shù)位數(shù)的四舍五入返回除法操作的余數(shù)返回當前的系統(tǒng)日期改變某個域的顯示方式用于執(zhí)行日期計算CURDATE()CURTIME()DATE()返回當前的日期返回當前的時間提取日期或日期/時間表達式的日期部分返回日期/時間按的單獨部分給日期添加指定的時間間隔從日期減去指定的時間間隔返回兩個日期之間的天數(shù)用不同的格式顯示日期/時間EXTRACT()DATE_ADD()DATE_SUB()DATEDIFF()DATE_FORMAT()SQLServerDate函數(shù)
下面的表格列出了SQLServer中最重要的內(nèi)建日期函數(shù):
函數(shù)GETDATE()描述返回當前日期和時間返回日期/時間的單獨部分在日期中添加或減去指定的時間間隔返回兩個日期之間的時間用不同的格式顯示日期/時間DATEPART()DATEADD()DATEDIFF()CONVERT()SQLDate數(shù)據(jù)類型
MySQL使用下列數(shù)據(jù)類型在數(shù)據(jù)庫中存儲日期或日期/時間值:
DATE-格式Y(jié)YYY-MM-DD
DATETIME-格式:YYYY-MM-DDHH:MM:SSTIMESTAMP-格式:YYYY-MM-DDHH:MM:SSYEAR-格式Y(jié)YYY或YY
SQLServer使用下列數(shù)據(jù)類型在數(shù)據(jù)庫中存儲日期或日期/時間值:
DATE-格式Y(jié)YYY-MM-DDDATETIME-格式:YYYY-MM-DDHH:MM:SSSMALLDATETIME-格式:YYYY-MM-DDHH:MM:SSTIMESTAMP-格式:唯一的數(shù)字
友情提示:本文中關(guān)于《SQL總結(jié)》給出的范例僅供您參考拓展思維使用,SQL總結(jié):該篇文章建議您自主創(chuàng)作。
來源:網(wǎng)絡(luò)整理 免責聲明:本文僅限學習分享,如產(chǎn)生版權(quán)問題,請聯(lián)系我們及時刪除。