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

MySQLÊý¾Ý¿âÏê½â

´Ó±¾Æª²©ÎÄ¿ªÊ¼£¬ÎÒÃǾÍÒªÉîÈëµ½PHPµÄÓ¦Óõ±ÖÐÈ¥ÁË¡£PHPµÄÊý¾Ý¿âÓ¦ÓÃÊÇÖØÖÐÖ®ÖØ£¬±ØÐëÕÆÎÕ¡£Ñ¡ÔñʲôÑùµÄÊý¾Ý¿âÄØ£¬µ±È»ÊÇÎÒÃǵÄMySQLÀ²£¬Ã»ÓÐÈË»áȥʹÓÃÄÇЩÅÓ´ó¡¢µÍЧ¶øÓÖ°º¹óµÄÉÌÒµÊý¾Ý¿âÀ´¹¹½¨PHPÓ¦Óðɡ£
1 MySQLÊý¾Ý¿âµÄ°²×°
¹ýÈ¥£¬°²×°Ò»¸öMySQLÊý¾Ý¿â²¢ÇÒÒªÆô¶¯ÆðÀ´ºÜ·ÑÊ£¬ÌرðÊÇÔÚLinuxÕâÑùµÄ¿ª·¢»·¾³Ï£¬ÐèÒª¸üкܶàÀà¿â»òÕ߯äËû¶«¶«¡£²»¹ý£¬ÏÖÔÚÓÐÁËLAMP¼Ü¹¹£¬Ò»Çо¡ÔÚÕÆÎÕ£¡
Çë´Ó Apache Friends Web Õ¾µãÉÏÏÂÔØ×îеĶþ½øÖÆÎļþ²¢½øÐнâ°ü£º
xampp-linux-1.7.3.tar.gz¡£
http://sourceforge.net/projects/xampp/files/XAMPP%20Linux/1.7.3/xampp-linux-1.7.3.tar.gz/download
ʹÓÃÏÂÃæµÄÃüÁÆä½â¿ªµ½ /opt Ŀ¼ÖУº
tar xvfz xampp-linux-1.7.2.tar.gz
½âѹºó³öÏÖlamppÎļþ¼Ð£¬Ò»¶¨Òª½«lampp·Åµ½/opt ÏÂÃæ£¨·ñÔò²»ÄÜÆô¶¯£©¡£ÏÖÔÚËùÓеÄÈí¼þ¶¼ÒѾ­°²×°ºÃÁË£¬ÈÃÎÒÃÇÆô¶¯ÐµÄÊØ»¤½ø³Ì¡£½«µ±Ç°µÄ¹¤×÷Ŀ¼Çл»µ½ /opt/lampp £¨ cd /opt/lampp£©²¢ÊäÈëÏÂÃæµÄÃüÁ
./lampp start
Æô¶¯ÆðÀ´ºó£¬ÎÒÃǾͿÉÒÔʹÓÃÆäÖеÄMySQLÄ£¿éÁË£º
# cd /opt/lampp/bin
# ./mysql
mysql>
2 ÐÞ¸ÄmysqlÃÜÂë
# ./mysqladmin -u root password 'new-password'
¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
Àý1£º¸øroot¼Ó¸öÃÜÂë123456¡£
¡¡¡¡¼üÈëÒÔÏÂÃüÁî £º
¡¡¡¡ /opt/lampp/bin/mysqladmin -u root password 123456
¡¡¡¡×¢£ºÒòΪ¿ªÊ¼Ê±rootûÓÐÃÜÂ룬ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¾Í¿ÉÒÔÊ¡ÂÔÁË¡£²âÊÔÊÇ·ñÐ޸ijɹ¦£º
1£©²»ÓÃÃÜÂëµÇ¼
# ./mysql
2£©ÓÃÐ޸ĺóµÄÃÜÂëµÇ¼
# ./mysql -u root -p
¡¡¡¡Enter password: (ÊäÈëÐ޸ĺóµÄÃÜÂë123456)
¡¡¡¡Welcome to the MySQL monitor.¡¡Commands end with ; or \g.
¡¡¡¡Your MySQL connection id is 4 to server version: 4.0.16-standard
¡¡¡¡Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
¡¡¡¡mysql>
¡¡¡¡³É¹¦£¡
3)Í˳ömysqlÃüÁexit£¨»Ø³µ£©
3 Êý¾Ý¿âºÍ±íµÄ²Ù×÷
mysql> show databases;
  ÏÔʾÈçÏÂÐÅÏ¢£º
+---------------------+
| Database            |
+---------------------+
| information_schema  |
| cluster_replication |
| mysql               |
| test    &nbs


Ïà¹ØÎĵµ£º

Mysql³£ÓÃÃüÁîÐдóÈ«

µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......

Mysql·þÎñ°²×°ºÍÐ¶ÔØÃüÁî

ÆäʵÈç¹ûÄã·þÎñÆ÷ÖØÐ°²×°ÁË,Ò²²»±ØÖØÐ°²×°mysql ¼¸¸öСÃüÁî¾Í¸ã¶¨ÁË
Ê×ÏÈÊǰ²×°mysql·þÎñ:
mysql-nt –install
net start  mysql
µ±È»Ó´ÔÚbinĿ¼ÔËÐÐÕâ¸öÃüÁîÁË
Ð¶ÔØµÄÃüÁîÊÇ:
net stop "MySQL"
mysqld-nt.exe –remove "MySQL"
ΪʲôÓеÄÅóÓÑÐ¶ÔØ²»ÁËÄØ,ÒòΪËûÒѾ­°ÑÔ´Îļþ¶¼É¾³ýÁË »òÕßÔËÐÐÐ ......

MySQLÊý¾Ýµ¼Èëµ¼³öcsvÎļþÃüÁî

MySqlÊý¾Ý¿âµ¼³öcsvÎļþÃüÁ
mysql> select first_name,last_name,email from account into outfile 'e:\\output1.csv' fields terminated by ','optionally enclosed by ''lines terminated by '\n';
csvÎļþЧ¹û£º



sunny
Grigoryan
lovechoosesun@gmail.com
Jon
Siegal
sun@riliantech.net
Joe
S ......

ÈçºÎÐÞ¸Ämysql rootÃÜÂ룿

1¡¢±à¼­MySQLÅäÖÃÎļþ£º
 windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼­¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖÐ ......

mysql ³£Óú¯Êý

Ò»¡¢³£ÓÃ×Ö·û´®º¯Êý
1.CONCAT(str1,str2,...)
mysql> ? concat;
mysql> SELECT CONCAT('My', 'S', 'QL');
+-------------------------+
| CONCAT('My', 'S', 'QL') |
+-------------------------+
| MySQL        ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ