½âѹ°æ/Ãâ°²×°°æMySQLÅäÖÃÈ«½â
Ò» ÏÂÔØMySQL
http://dev.mysql.com/downloads/mysql/5.0.html
½âѹMySQL£¨F:\Program Files\MySQL\£©MySQL°²×°Ä¿Â¼
¶þ н¨my.ini
ÔÚF:\Program Files\MySQL\Ͻ¨Á¢my.iniÎļþ£¬ÄÚÈÝΪ
my.ini
[mysqld]
# ÉèÖÃmysqlµÄ°²×°Ä¿Â¼
basedir=F:\\Program Files\\MySQL
# ÉèÖÃmysqlÊý¾Ý¿âµÄÊý¾ÝµÄ´æ·ÅĿ¼£¬±ØÐëÊÇdata£¬»òÕßÊÇ\\xxx-data
datadir=F:\\Program Files\\MySQL\\data
# ÉèÖÃmysql·þÎñÆ÷µÄ×Ö·û¼¯ £¬Ä¬ÈϱàÂë
default-character-set=latin1
[client]
# ÉèÖÃmysql¿Í»§¶ËµÄ×Ö·û¼¯
default-character-set=latin1
[WinMySQLAdmin]
# Ö¸¶¨mysql·þÎñÆô¶¯Æô¶¯µÄÎļþ
Server=F:\\Program Files\\MySQL\\bin\\mysqld.exe
Èý ×¢²áMySQL·þÎñ£¬Ê¹MySQL¿ÉÒÔÔÚ·þÎñÏîÄ¿ÖÐÆô¶¯»ò¹Ø±Õ
1£©½øÈ밲װĿ¼\bin£¬Ö´ÐУº
F:\Program Files\MySQL\bin>mysqld -install
ÏÔʾ£ºService successfully installed. Ôò×¢²á·þÎñ³É¹¦¡£
Èç¹ûҪɾ³ý·þÎñ£º
F:\Program Files\MySQL\bin>mysqld -remove
2£©ÐÞ¸Ä×¢²á±í£º
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MySQL\ImagePath
ÐÞ¸ÄΪ£º
"F:\Program Files\MySQL\bin\mysqld" --defaults-file=
"F:\Program Files\MySQL\my.ini" MySQL
ÕâÑùÅäÖþͿÉÒÔʹÓÃnet start mysqlÃüÁîÕý³£Æô¶¯MySQL¡£
ËÄ ÐÞ¸ÄrootÃÜÂë
MySQLÅäÖÃºÃºó£¬Æô¶¯³É¹¦£¬Ä¬ÈÏÃÜÂëÊǿգ¬µ«ÊÇΪÁ˰²È«£¬ÉèÖÃÃÜÂ루һ°ãÓû§ÃûΪroot£¬ÃÜÂëΪroot£©¡£
1£©µÇ¼MySQL rootÓû§£º
½øÈëMySQL°²×°Ä¿Â¼\bin£¬Ö´ÐУº
F:\Program Files\MySQL\MySQL-6.0.7\bin>mysql -u root;
2£© ÐÞ¸ÄrootÃÜÂ룺
mysql> update mysql.user set password=PASSWORD('new password') where User='root';
mysql> flush privileges;
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/oswin_jiang/archive/2009/08/11/4433481.aspx
Ïà¹ØÎĵµ£º
MysqlµÄ×Ö·û¼¯ÊDZȽÏÂé·³µÄ,ĬÈϵĶÔÎÒÃÇÀ´Ëµ¸ù±¾¾ÍûʲôÓÃ,ÎÒÃÇÊÇÒªÓõ½ÖÐÎĵÄ,ËùÒÔÒ»¶¨µÃ¸Ä×Ö·û¼¯,Èç¹û×Ö·û¼¯²»¶Ô»áÓкܶàµÄÎÊÌâ,ÓÐÂÒÂ뻹ÓоÍÊÇÎÒÃÇÔÚ³ÌÐòÀï²åÈëÖÐÎÄʱ»á¸øÄã˵mysql Data truncation: Data too long for column,ÄãǧÍò±ðÒÔΪÊÇÄãµÄ×Ö¶ÎÉèµÃ²»¹»³¤,ÄãÉèµÃÔÙ³¤Ëû¶¼»á±¨´í,ËùÒÔ¸Ä×Ö·û¼¯°É
ÎÒÃÇÒ»°ã×°ºÃÊý ......
²âÊÔ»·¾³£ºmysql 5.0.45 ¡¾×¢£º¿ÉÒÔÔÚmysqlÖÐͨ¹ýmysql> SELECT VERSION();À´²é¿´Êý¾Ý¿â°æ±¾¡¿ÕûÀí£ºWebjx.Com Ò»¡¢Á¬½ÓMYSQL¡£¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë 1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓпոñ ......
ÍÆ¹ãµØµã±ípromotion_addr×ֶΣºname£¬id
µç»°±¨¿¢±íunicom_record×ֶΣºdate, sheet_id£¨¹ØÁªsheet±íid£©
±¨µ¥±ísheet×ֶΣºid,promotion_addr_id£¨¹ØÁªpromotion_addr±íid£©
ÒªÇóͳ¼ÆÄ³¸öÔÂÒѱ¨¿¢¸÷ÍÆ¹ãµØµãµÄÍÆ¹ã¸öÊý£»
SELECT
p.name, count(*)
from
unicom_record AS ur
Left Join sheet AS s ON ur.sheet_id ......
ÆÕͨË÷Òý¡¢Î¨Ò»Ë÷ÒýºÍÖ÷Ë÷Òý
1. ÆÕͨË÷Òý
ÆÕͨË÷Òý(Óɹؼü×ÖKEY»òINDEX¶¨ÒåµÄË÷Òý)µÄΨһÈÎÎñÊǼӿì¶ÔÊý¾ÝµÄ·ÃÎÊËÙ¶È¡£Òò´Ë£¬Ó¦¸ÃֻΪÄÇЩ×î¾³£³öÏÖÔÚ²éѯÌõ¼þ(WHERE column = …)»òÅÅÐòÌõ¼þ(ORDER BY column)ÖеÄÊý¾ÝÁд´½¨Ë÷Òý¡£Ö»ÒªÓпÉÄÜ£¬¾ÍÓ¦¸ÃÑ¡ÔñÒ»¸öÊý¾Ý×îÕûÆë¡¢×î½ô´ÕµÄÊý¾ÝÁÐ(ÈçÒ»¸öÕûÊýÀàÐ͵ÄÊý¾ÝÁÐ)À ......