創(chuàng)建數(shù)據(jù)庫

create database

創(chuàng)建表

create table 

添加

 insert into tablename (column1,column2,column3,......) values (value1,value2,value3,......);
 insert into tablename values(value1,value2,....);

查詢

 select * from tablename;
 select * from tablename where 條件1 and (or) 條件2  column like '%'   column   in (列表)
                                     group by groupbycolumn
                                having
                                order by asc （desc）
                                limit 10,2

查詢幾組

            select * from tablename limit 3,5;
            table1 inner join table2 on column1=column2
    from table1,table2 where column1=column2
 
    table1 left join table2 on column1=column2
    table1 right join table2 on column1=column2
  union 
union all

刪除

            delete from tablename where id=1;

修改

            update tablename set column1=value1,colum2=value2 where id=1;
            [選修]update table1 t1,table2 t2 set t1.c1=v1,t2.c2=v2 where id=1 and t1.keyId=t2.keyId 

html+css

   form action  method get post    RequestHeader response   url地址?name1=v1&name2=v2
 
    input type
                text
                password
                radio
                checkbox    checked
                email
                date
                number
                file
                week
    select 
    option  selected
    textarea
         col row
    button
        submit
        reset
        image
        button
   i span img a label 
        header
        footer
        selection
        container
    
  >
  <
   ©
   "
 
  使用方式 三種    行內  style=""
              內嵌    <style>
             外部引用   <link rel="stylesheet" href=""/>

基本選擇器

        類：.name
        標簽: name
        id：#name

復合選擇器

        #name.name
        .name#name
        .name,.name
        .name .name
        .name>.name
        [type='v']
    :hover
    :after
    :before
  color:
 background-color:
   background-image:
   repeat

透明度

 opacity
    rgba(0,0,0,.5)
    transparent

   text-align:left right center;
   line-height
   letter-space
  
 border-top left right bottom 
   margin:10px 20px 30px 40px;
   padding:10px 20px 30px 40px;
   border-radius

   box-sizing border-box
            content-box
   box-shadow
   font-family
   font-size;
   font-style:none
   background-position
   background-size

   position relative
        fixed
        static
        absolute

    left top right bottom
    z-index
   float: left right
   clear: left right both

擴展盒子高度

        clear:both；
        :after 
        overflow:hidden;
   display:block;
        inline;
    inline-block;