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

ÔÚMySQLÖе¼Èëµ¼³öÎļþ

Ç°Ì᣺MySQLÖдæÔÚÒ»¸öÓû§×Ô¼º½¨Á¢µÄÊý¾Ý¿â£¬¼ÙÉèΪmydb£¬mydbÖÐÓÐÒ»ÕÅÓû§×Ô¼º½¨Á¢µÄ±í¸ñ£¬¼ÙÉèÃû³ÆΪmytable
ÎÒµÄÇ°Ì᣺MySQLÖдæÔÚÁ½¸öÊý¾Ý¿â£¬yldbºÍyldb2£¬ÆäÖÐyldbÊý¾Ý¿âÖÐÓÐÒ»ÕÅ±í£¬ÃûΪpet
Ò».MYSQLµÄÃüÁîÐÐģʽµÄÉèÖãº
×ÀÃæ->ÎҵĵçÄÔ->ÊôÐÔ->»·¾³±äÁ¿->н¨->
PATH=“£»path\mysql\bin;”ÆäÖÐpathΪMYSQLµÄ°²×°Â·¾¶¡£
ÔÚConfigure the MySQL Server 5.1 server instance¹ý³ÌÖÐÓÐÒ»ÏîÊÇÒªÌáʾÊÇ·ñ"Include Bin Directory in Windows PATH"£¬Ñ¡ÔñÁËÕâ¸öÑ¡ÏÏ൱ÓÚ°ÑMySQLµÄ¿ÉÖ´ÐÐÎļþ·¾¶£¨binµÄ·¾¶£©¼ÓÈëµ½ÁËWINDOWSϵͳµÄ»·¾³±äÁ¿ÖУ¬ÕâÑùMySQL¿ÉÒÔ´ÓwindowsµÄÃüÁîÐÐÆô¶¯ÁË¡£ 
 
¶þ.¼òµ¥µÄ½éÉÜÒ»ÏÂÃüÁîÐнøÈëMYSQLµÄ·½·¨£º
1.C:\>mysql -h hostname -u username -p
°´ENTER¼ü£¬µÈ´ýÈ»ºóÊäÈëÃÜÂë¡£ÕâÀïhostnameΪ·þÎñÆ÷µÄÃû³Æ£¬Èçlocalhost£¬usernameΪMYSQLµÄÓû§Ãû£¬Èçroot¡£
½øÈëÃüÁîÐкó¿ÉÒÔÖ±½Ó²Ù×÷MYSQLÁË¡£
2.¼òµ¥½éÉÜÒ»ÏÂMYSQLÃüÁ
   mysql->CREATE DATABASE dbname;//´´½¨Êý¾Ý¿â
   mysql->CREATE TABLE tablename;//´´½¨±í
   mysql->SHOW DATABASES;//ÏÔʾÊý¾Ý¿âÐÅÏ¢£¬ÓÐÄÇЩ¿ÉÓõÄÊý¾Ý¿â¡£
  mysql->USE dbname;//Ñ¡ÔñÊý¾Ý¿â
   mysql->SHOW TABLES;//ÏÔʾ±íÐÅÏ¢£¬ÓÐÄÇЩ¿ÉÓõıí
   mysql->DESCRIBE tablename;//ÏÔʾ´´½¨µÄ±íµÄÐÅÏ¢
 
Èý.´ÓÊý¾Ý¿âµ¼³öÊý¾Ý¿âÎļþ£º
1.½«Êý¾Ý¿âmydbµ¼³öµ½e:\mysql\mydb.sqlÎļþÖУº
´ò¿ª¿ªÊ¼->ÔËÐÐ->ÊäÈëcmd    ½øÈëÃüÁîÐÐģʽ
c:\>mysqldump -h localhost -u root -p mydb >e:\mysql\mydb.sql
È»ºóÊäÈëÃÜÂ룬µÈ´ýÒ»»áµ¼³ö¾Í³É¹¦ÁË£¬¿ÉÒÔµ½Ä¿±êÎļþÖмì²éÊÇ·ñ³É¹¦¡£
ÎÒÊäÈëµÄÊÇ
C:\Documents and Settings\yangliu>mysqldump -h localhost -u root -p -C -v yldb >
 e:\mysql\yldb.sql
 Enter password: *******
-- Connecting to localhost...
-- Retrieving table structure for table pet...
-- Sending SELECT query...
-- Retrieving rows...
-- Disconnecting from localhost...
¼ÓÈëÁË-C -v ¾Í¶à³öÁËÏÂÃæµÄÎåÐУ¬ÏÔʾÁ˾ßÌåµ¼³öµÄ¹ý³Ì¡£ÕâÑù¾Íµ¼³öÁËyldb.sqlÎļþµ½ÁËE:\mysql\ ÖÐ
2.
½«Êý¾Ý¿âmydbÖеÄmytableµ¼³öµ½e:\mysql\mytable.sqlÎļþÖУº
c:\>mysqldump -h lo


Ïà¹ØÎĵµ£º

MySQL¸ßЧÔËÐбر¸£º¼òµ¥µÄ֪ʶ½ÌÄã¸ßЧÔËÓÃË÷Òý

ÔÚÊý¾Ý¿â±íÖУ¬¶Ô×ֶν¨Á¢Ë÷Òý¿ÉÒÔ´ó´óÌá¸ß²éѯËٶȡ£¼ÙÈçÎÒÃÇ´´½¨ÁËÒ»¸ö mytable±í£º
CREATE TABLE mytable(
ID INT NOT NULL,
username VARCHAR(16) NOT NULL
);
ÎÒÃÇËæ»úÏòÀïÃæ²åÈëÁË10000Ìõ¼Ç¼£¬ÆäÖÐÓÐÒ»Ìõ£º5555, admin¡£
ÔÚ²éÕÒusername="admin"µÄ¼Ç¼ SELECT * from mytable WHERE username='admin';ʱ£¬Èç¹ ......

mysqlʹÓÃrandËæ»ú²éѯ¼Ç¼ЧÂʲâÊÔ

Ò»Ö±ÒÔΪmysqlËæ»ú²éѯ¼¸ÌõÊý¾Ý£¬¾ÍÓÃ
SELECT * from `table` ORDER BY RAND() LIMIT 5
¾Í¿ÉÒÔÁË¡£
µ«ÊÇÕæÕý²âÊÔһϲŷ¢ÏÖÕâÑùЧÂʷdz£µÍ¡£Ò»¸ö15ÍòÓàÌõµÄ¿â£¬²éѯ5ÌõÊý¾Ý£¬¾ÓȻҪ8ÃëÒÔÉÏ
²é¿´¹Ù·½ÊֲᣬҲ˵rand()·ÅÔÚORDER BY ×Ó¾äÖлᱻִÐжà´Î£¬×ÔȻЧÂʼ°ºÜµÍ¡£
You cannot use a column with RAND() values i ......

Ubuntu 8.04 vsftpd mysql pamµÄftp·þÎñÆ÷¶ËÎÞ´íÅäÖÃ

ÅäÖû·¾³:UUbuntu 8.04
1.°²×°vsftpd
sudo apt-get install vsftpd
2.´´½¨guestÓû§
vsftpd°²×°µÄʱºò»á×Ô¶¯°²×ªÒ»¸öftpÓû§£¬ÔÚpasswdÖÐɾ³ý
sudo useradd virtual
ÉèÖÃvirtualµÄÃÜÂëΪwebftp
sudo passwd virtual
±à¼­virtualÓû§µÄÖ÷Ŀ¼²¢ÉèÖÃshell
sudo vim /etc/passwd
ÎÒÉèÖõÄÊÇvirtual:x:1001: ......

MySQLÖг£ÓõÄÐ޸ıíµÄÃüÁî

MySQLÖг£ÓõÄÐ޸ıíµÄÃüÁî
¹Ø¼ü×Ö: mysql, Ð޸ıí, ÃüÁî
    ÔÚÊý¾Ý¿â²Ù×÷ÖÐ,¸öÈ˾õµÃʹÓõÃ×î¶àµÄ¾ÍÊDzéѯ,È»ºó¾ÍÊǶԱíµÄÐ޸IJÙ×÷ÁË,ÓÈÆäÊǵ±Êý¾Ý¿âµÄÉè¼Æ¹¤×÷ûÓÐ×öºÃʱ.ÏÂÃæ¾ÍMySQLÖÐһЩ³£ÓõÄÐ޸ıíµÄ²Ù×÷½øÐÐ×ܽá:
    ΪÁË·½±ãºóÃæµÄ˵Ã÷,ÏÈ´´½¨Ò»¸ö±í,´´½¨Óï¾äÈçÏÂ:
Create ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ