LinuxÏ php5 MySQL5 Apache2 °²×°ÓëÅäÖÃ
mkdir /downloads
chown -R root:root /downloads
chmod -R 774 /downloads
Ò»¡¢°²×°Apache2
ÏÂÔØµØÖ·£ºhttp://www.apache.org/ --> HTTP Server --> from a mirror
1. »ñÈ¡mysqlÔ´Âë
shell> cd /downloads
shell> wget http://apache.etoak.com/httpd/httpd-2.2.11.tar.gz
2. Ïë½âѹËõ°ü£¬½øÈë¸ÃĿ¼
shell> tar zxvf httpd-2.2.11.tar.gz
shell> cd httpd-2.2.11/
3. ±àÒë°²×°£¬×Ô¶¨Ò尲װĿ¼¡£
shell> ./configure --prefix=/usr/local/apache --enable-so --enable-rewrite ##×¢£ºapache 1.3.* Óëapache 2.*.* ²»Í¬ ¿ÉÒÔÓÃ./configure --help²é¿´
shell> make && make install
4. Æô¶¯Apache2¡£
shell> /usr/local/apache/bin/apachectl start
¶þ¡¢°²×°MySQL5
ÏÂÔØµØÖ·£ºhttp://www.mysql.com/ --> downloads --> MySQL Community Server
1. Ìí¼ÓmysqlÓû§ºÍÓû§×飺
shell> groupadd mysql
shell> useradd -g mysql mysql
2. »ñÈ¡mysqlÔ´Âë
shell> cd /downloads
shell> wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.36.tar.gz/from/http://mysql.stu.edu.tw/
3. Ïë½âѹËõ°ü£¬½øÈë¸ÃĿ¼
shell> tar zxvf mysql-5.1.36.tar.gz
shell> cd mysql-5.1.36/
4. ±àÒë°²×°£¬×Ô¶¨Ò尲װĿ¼¡£
shell> ./configure --prefix=/usr/local/mysql ##–with-charset=utf8 –with-collation=utf8_general_ci –with-extra-charsets=utf8
&nbs
Ïà¹ØÎĵµ£º
1. ¶¨Òå
/*
Plugin system variables.
*/
static long sysvar_one_value;
static char *sysvar_two_value;
static MYSQL_SYSVAR_LONG(simple_sysvar_one, sysvar_one_value,
PLUGIN_VAR_RQCMDARG,
"Simple fulltext parser example system variab ......
MySql ×Ö·û´®º¯Êý
[ 2006-04-22 19:24:44 | Author: Ychon ]
Font Size: Large | Medium | Small
¶ÔÓÚÕë¶Ô×Ö·û´®Î»ÖõIJÙ×÷£¬µÚÒ»¸öλÖñ»±ê¼ÇΪ1¡£
ASCII(str)
·µ»Ø×Ö·û´®strµÄ×î×óÃæ×Ö·ûµÄASCII´úÂëÖµ¡£Èç¹ûstrÊÇ¿Õ×Ö·û´®£¬·µ»Ø0¡£Èç¹ûstrÊÇNULL£¬·µ»ØNULL¡£
mysql> select ASCII('2');
-> 50
mysql ......
ÒýÓÃhttp://bbs.yahunet.com/thread-9946-1-1.html
´Ó»ù±¾Çé¿ö¡¢³É±¾¡¢ÓÅȱµãºÍÓ¦Óó¡ºÏµÈ·½Ãæ¶Ô5ÖÖMySQLµÄ¿É¿¿ÐÔ·½°¸
½øÐÐÁË·ÖÎö
ºÍ±È½Ï£¬¶ÔMySQLµÄ¿ª·¢ºÍ¹ÜÀí
ÓÐÒ»¶¨µÄ½è¼ø×÷Óá£
1£®MySQL Clustering(ndb-cluster stogare)
¼ò½é£º
MySQL¹«Ë¾ÒÔ´æ´¢ÒýÇæ·½Ê½ÌṩµÄ¸ß¿É¿¿ÐÔ·½°¸£¬ÊÇÊÂÎñ°²È«µÄ£¬ÊµÊ±¸´ÖÆÊý¾Ý
£¬¿ÉÓ ......
Æô¶¯£ºnet start mySql;
½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
ÁгöÊý¾Ý¿â£ºshow databases;
Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
Áгö±í¸ñ£ºshow tables£»
ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
½¨Á¢Êý¾Ý¿â£ºsource fileNam ......