mysqlÔÚÔÙ´ÎÐ¶ÔØºó֨װ³öÏÖStart services²»ÄÜÆô¶¯
×î½ü×öÒ»¸öСÏîÄ¿£¬¸ÕºÃÓöµ½Õâ¸öÎÊÌ⣬ûʲôʱ¼äÈ¥½â¾öÕâ¸öÎÊÌ⣬´ó¸ÅÔÚÍøÉÏÕÒÁËһϣ¬Ëµ¸ÄʵÀýÃû£¬¸Ä×¢²á±í£¬ÏȲ»ÊǺܸҸģ¬±Ï¾¹¶Ô×¢²á±íÒ»Ö±¾õµÃÊǸö´óÉñ£¬²»¸ÒËæ±ã¶¯£¬½ñ¶ùÊÇ»í³öÈ¥ÁË£¬¾ÍÔÚ×¢²á±íÖвéÕÒËùÓдúmysql×ÖÑùµÄÐÅϢȫ²¿É¾³ý£¬×îºó¾¹È»³ÉÁË£¬µ±È»Ð¶Ôغóɾ³ý֮ǰËùÓеÄÏà¹ØÐÅÏ¢£¬°²×°ÎļþĿ¼ºÍÏà¹ØÐÅÏ¢¡£
Ïà¹ØÎĵµ£º
½â¾ö·½·¨£º
1¡¢¹Ø±ÕÊý¾Ý¿âÁ¬½Ó;
2¡¢ÓÒ»÷Êý¾Ý¿âÑ¡Ôñ“Á¬½ÓÊôÐÔ”£»
3¡¢Ñ¡Ôñ“¸ß¼¶”ÊôÐÔÒ³£¬½«“ʹÓÃMySQL×Ö·û¼¯”µÄ¹´È¥µô£¬²¢Ñ¡Ôñ“±àÂë”Ϊ“936 (ANSI/OEM - Simplified Chinese GBK)”
4¡¢¹Ø±Õ±£´æ£¬ÖØÐÂÁ¬½Ó¡£ ......
1.ͨ¹ýÐÞ¸ÄMYSQLÊý¾Ý¿âÖÐMYSQL¿âµÄUSER±í
¾ÍÓÃÆÕͨµÄUPDATE¡¢INSERTÓï¾ä¾Í¿ÉÒÔ
use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;
£¨Õâ¸öÇ××ÔʵÑé¹ý£¬¿ÉÒÔÖ´ÐУ¡£©
2.ÔÚÃüÁîÐÐÖÐʹÓÃÈçÏÂÃüÁî
&nbs ......
²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´Åжϣ¬Ö»Á ......
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......