MySQLÃüÁîÐÐÎÞ·¨Æô¶¯
Çë½Ì£ºÎÒµÄmysql²»ÖªµÀÔõô»ØÊ£¬MySql Command LineÊäÈëÃÜÂëÖ®ºó"µÎ"Ò»Éù¾Í×Ô¶¯¹Ø±ÕÁË¡£ÔõôŪѽ£¿ µ«ÊÇÎÒʹÓÃnavicat¿ÉÒÔ·ÃÎʺͲÙ×÷Êý¾Ý¿â.
ÏÈÓÃWINDOWSµÄDOSÃüÁîµ½ÃüÁî´°¿ÚÏ£¬È»ºóÔÙ
H:\> "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql" -uroot -p
ÊÔÒ»ÏÂ
ÏÔʾʲô£¿
ÎÒÒÔǰÓöµ½¹ý£¬ÊÇÅäÖÃÎļþ³öÁËÎÊÌâ¡£
ÎÒÒѾŪºÃÁË¡£ ÊÇÒòΪÎÒ½«Óû§ÃûrootϵÄÁ¬½ÓµØÖ·¸Ä³ÉÁËÎÒµÄipÁË£¬¾Í²»Ö§³ÖlocalhostÓû§¡£ÎÒÓÖд´½¨ÁËÒ»¸ölocalhostµÄÁ¬½ÓµØÖ·µÄÓû§£¬¾Í¿ÉÒÔ¡£ лл´ó¼Ò£¡
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
¡¡´úÂ룿
ÒýÓÃ
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
½¨ÒéÌùÍêÕûinsert´úÂë¼°´íÎó´úÂ룬ÒÔ±ã·ÖÎö
ÇëÂ¥Ö÷ÌùÍêÕûµÄsql´ú ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......