Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysqlѧϰ4

£­£­¶à±í²Ù×÷
   Ç°ÃæÎÒÃÇÊìϤÁËÊý¾Ý¿âºÍÊý¾Ý¿â±íµÄ»ù±¾²Ù×÷£¬ÏÖÔÚÎÒÃÇÔÙÀ´¿´¿´ÈçºÎ²Ù×÷¶à¸ö±í¡£
   ÔÚÒ»¸öÊý¾Ý¿âÖУ¬¿ÉÄÜ´æÔÚ¶à¸ö±í£¬ÕâЩ±í¶¼ÊÇÏ໥¹ØÁªµÄ¡£ÎÒÃǼÌÐøÊ¹ÓÃÇ°ÃæµÄÀý×Ó¡£Ç°Ã潨Á¢µÄ±íÖаüº¬ÁËÔ±¹¤µÄһЩ»ù±¾ÐÅÏ¢£¬ÈçÐÕÃû¡¢ÐԱ𡢳öÉúÈÕÆÚ¡¢³öÉúµØ¡£ÎÒÃÇÔÙ´´½¨Ò»¸ö±í£¬¸Ã±íÓÃÓÚÃèÊöÔ±¹¤Ëù·¢±íµÄÎÄÕ£¬ÄÚÈݰüÀ¨×÷ÕßÐÕÃû¡¢ÎÄÕ±êÌâ¡¢·¢±íÈÕÆÚ¡£
1¡¢²é¿´µÚÒ»¸ö±ímytableµÄÄÚÈÝ£º
mysql> select * from mytable;
+----------+------+------------+-----------+
| name    |   | birth    | birthaddr |
+----------+------+------------+-----------+
| abccs   |f    | 1977-07-07 | china    |
| mary    |f    | 1978-12-12 | usa     |
| tom    |m    | 1970-09-02 | usa     |
+----------+------+------------+-----------+
2¡¢´´½¨µÚ¶þ¸ö±ítitle£¨°üÀ¨×÷Õß¡¢ÎÄÕ±êÌâ¡¢·¢±íÈÕÆÚ£©:
mysql> create table title(writer varchar(20) not null,
   -> title varchar(40) not null,
   -> senddate date);
   Ïò¸Ã±íÖÐÌî¼Ó¼Ç¼£¬×îºó±íµÄÄÚÈÝÈçÏ£º
mysql> select * from title;
+--------+-------+------------+
| writer | title | senddate   |
+--------+-------+------------+
| abccs | a1   | 2000-01-23 |
| mary   | b1   | 1998-03-21 |
| abccs | a2   | 2000-12-04 |
| tom   | c1   | 1992-05-16 |
| tom   | c2   | 1999-12-12 |
+--------+-------+------------+
5 rows in set (0.00sec)
3¡¢¶à±í²éѯ
   ÏÖÔÚÎÒÃÇÓÐÁËÁ½¸ö±í: mytable ºÍ title¡£ÀûÓÃÕâÁ½¸ö±íÎÒÃÇ¿ÉÒÔ½øÐÐ×éºÏ²éѯ£º
ÀýÈçÎÒÃÇÒª²éѯ×÷ÕßabccsµÄÐÕÃû¡¢ÐÔ±ð¡¢ÎÄÕ£º
mysql> SELECT name,,title from mytable,title
   -> WHERE name=writer AND name='abccs';
+-------+------+-------+
| name |   | title |
+-------+------+-------+
| abccs | f   | a1   |


Ïà¹ØÎĵµ£º

mysql limit ·ÖÒ³ Rubicon

LIMIT×Ó¾ä¿ÉÒÔ±»ÓÃÀ´ÏÞÖÆSELECTÓï¾ä·µ»ØµÄÐÐÊý¡£LIMITÈ¡1¸ö»ò2¸öÊý×Ö²ÎÊý£¬Èç¹û¸ø¶¨2¸ö²ÎÊý£¬µÚÒ»¸öÖ¸¶¨Òª·µ»ØµÄµÚÒ»ÐÐµÄÆ«ÒÆÁ¿£¬µÚ¶þ¸öÖ¸¶¨·µ»ØÐеÄ×î´óÊýÄ¿¡£³õʼÐÐµÄÆ«ÒÆÁ¿ÊÇ0(²»ÊÇ1)¡£ mysql> select * from table LIMIT 5,10; # Retrieve rows 6-15 Èç¹û¸ø¶¨Ò»¸ö²ÎÊý£¬ËüÖ¸³ö·µ»ØÐеÄ×î´óÊýÄ¿¡£ mysql> select * ......

mysqlÎÊÌâ

ÖØ×°Ê±³öÏÖcould not start the service mysql error:0µÄ´íÎóʱ
ÔÚ¿ØÖÆÃæ°åÖÐÔËÐÐÌí¼Óɾ³ý³ÌÐò£¬½«mysqlÐ¶ÔØ;
Ð¶ÔØºó´ò¿ª×¢²á±í£¬²é¿´HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services ϵļüÖµ£¬Èç¹ûÓÐÏà¹Ømysql¼üÖµ(mysql¡¢mysqladmin)Ôòɾµô£¬¼´¿É;
ÖØÆô£¬½«mysqlµÄ°²×°²ÐÓàĿ¼ɾµô (²é¿´·þÎñ£¬´Ëʱ·þÎñÖÐÒÑû ......

°²×°mysql·þÎñÆ÷£¬¼°ÐÞ¸Ä1130´íÎó

°²×°·þÎñÆ÷¶Ë£ºÏÂÔØÒ»¸ömysqlµÄ°²×°³ÌÐò£¬ÎÒ°²×°µÄÊÇ5.0°æ±¾µÄ£¬°´ÕÕÌáʾһ²½²½²Ù×÷Íê³É¡£Ã»ÓÐÊ²Ã´ÌØ±ð˵Ã÷µÄ¡£
°²×°¿Í»§¶Ë£ºÏÂÔØÒ»¸ömysql-query-browser£¬ÎÒÓõÄÊÇ1.1°æ±¾µÄ£¬°²×°£¬°´ÕÕÌáʾ²Ù×÷¡£
¶¼°²×°Íê³ÉÒÔºó£¬ÔÚ±¾»úÓÃbrowser²âÊÔÒ»ÏÂÊÇ·ñÄÜÁ¬µÄÉϱ¾»úµÄ·þÎñ£¬Á¬½Ó³É¹¦£¬¶¼°²×°OK.
Èç¹ûÄãÏëÈÃÆäËûµÄ¿ª·¢ÈËÔ±Ò»Æð ......

mysql »¥ÎªÖ÷´Ó


grant replication slave on *.* to backup@192.168.188.128 identified by "123456"; 
grant replication slave on *.* to backup@192.168.188.8 identified by "123456"; 
service mysql stop
server_id = 1
log-bin = mysql-bin
log-error=mysql-error
master-host = 192.168.188.8
master-user = ba ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ