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
Ïà¹ØÎĵµ£º
ÔÚ³ÌÐò¿ª·¢ÖУ¬ÓÐʱ»á±»×Ö·ûÂÒÂëµÄÎÊÌâËùÀ§ÈÅ¡£¶Ô´Ë£¬±ØÐëÀí½â MySQL µÄ×Ö·û¼¯±àÂëÉèÖõÄÔÀí£ºÔÚMySQLÖУ¬Ä¬ÈÏʹÓõÄÊÇlartin1£¬Ò²¾ÍÊÇISO8859-1×Ö·û¼¯±àÂë¡£ÕâÊÇÒ»ÖÖ8λµÄ±àÂ룬ÊÊÓÃÓÚËùÓÐÎ÷Å·×Ö·û¡£¶ø¶ÔÓÚºº×ÖµÈÊDz»ºÏÊʵġ£×îºÃ¡¢×îͨÓõıàÂë¸ñʽÊÇutf-8£¬UTF-8£¨8 λԪ Universal Cha ......
TIMESTAMPÁÐÀàÐÍÌṩһÖÖÀàÐÍ£¬Äã¿ÉÒÔʹÓÃËü×Ô¶¯µØÓõ±Ç°µÄÈÕÆÚºÍʱ¼ä±ê¼ÇINSERT»òUPDATEµÄ²Ù×÷¡£Èç¹ûÄãÓжà¸öTIMESTAMPÁУ¬Ö»ÓеÚÒ»¸ö×Ô¶¯¸üС£
×Ô¶¯¸üеÚÒ»¸öTIMESTAMPÁÐÔÚÏÂÁÐÈκÎÌõ¼þÏ·¢Éú£º
ÁÐûÓÐÃ÷È·µØÔÚÒ»¸öINSERT»òLOAD DATA INFILEÓï¾äÖÐÖ¸¶¨¡£
ÁÐûÓÐÃ÷È·µØÔÚÒ ......
MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö² ......