mysql ѧϰÊÖ¼Ç(1)

1.ÉèÖñäÁ¿
    set @x = 2;
    »ò:
    select @x := max(fields) as max from table;
2.Éú³Éhtml»òxml
    mysql -H -uroot -p databaseName        Éú³ÉhtmlÎļþ
    mysql -x -uroot -p databaseName        Éú³ÉxmlÎļþ
3.mysql»á»°ÖеļǼ¹¦ÄÜ
    msyql -ee=/usr/log -uroot -p
    ÔÚ mysql> ÖпÉÒÔÓà \t À´È¡Ïû£¬Óà \T À´ÉèÖô˹¦ÄÜ
4.show status like '%connections%' À´²é¿´×î´óÁ¬½ÓÊý
  show status like '%Uptime%' ²é¿´½ø³Ì
  show processlist ²é¿´µ±Ç°Ö´ÐеÄsqlÓï¾ä
  sqlµÄÂý²éѯÈÕÖ¾µÄ¿ÉÒÔ¿´³öÀ´ÊÇÄÄÒ»¸öÒ³Ãæ³öÁËÎÊÌâ
5.show character set    ²é¿´×Ö·ûÉèÖÃ
  show colllation like '%utf8%'    ²é¿´collation(УÑé)£¬ci,cs,bin·Ö±ð´ú±íºöÂÔ´óСд£¬²»ºöÂÔ´óСд£¬¶þ½øÖÆ
6.create table t1 select * from t2    ÒÔt2Ϊ±ê×¼´´½¨Ð±ít1£¬²¢½«ËùÓÐÊý¾ÝתÒƹýÈ¥
7.alter table t1 engine = myisam     ¸ü¸Ä engine Ϊ myisam