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

mysqlÂÒÂëÎÊÌâ

´´½¨µÄһЩ±í»á³öÏÖÕâÑùµÄÎÊÌ⣺ӢÎIJåÈëµ½±íÖÐûÓÐÈκÎÎÊÌâ¡£µ«ÊDzåÈëÖÐÎĵÄʱºò¾Í³öÏÖ Data truncation: Data too long for column 'name' at row 1 ÀàËÆµÄÎÊÌâ¡£
mysqlÄܰÑÓ¢ÎÄ×ֶβåÈçÊý¾Ý¿âÁË¡¡µ±ÎÒÊäÈëÖÐÎÄʱËû¾Í³öÏÖ×Ö¶ÎData truncation: Data too long for column 'name' at row 1
ÎÒʹÓÃÅóÓѵÄÕâ¸ö·½·¨£º(1)ÐÞ¸Ä $mysql_path$\my.ini(MySQL Server Instance Configuration Îļþ)
ÉèÖÃdefault-character-set=gbk(×¢Ò⣬ÓÐ2´¦)
(2)ÐÞ¸ÄdataĿ¼ÖÐÏàÓ¦Êý¾Ý¿âĿ¼ÏµÄdb.optÅäÖÃÎļþ
default-character-set=gbk
default-collation=gbk_chinese_ci
ÖØÆðmysql,¾ÍokÁË.
(×¢£ºÈç¹û±íÊÇÔÚûÓиÄ֮ǰµÄ£¬Ò»¶¨ÒªÖØÐ´´½¨£¬·ñÔò±í»¹ÊÇÒÔǰµÄ±àÂ룬»¹ÊDz»ÄܲåÈë
ÖÐÎÄÊý¾Ý£©


Ïà¹ØÎĵµ£º

mysqlÓï¾ä

delimiter // ¸Ä±ä½ç¶¨·û Ϊ//
 
ÁгöËùÓÐÊý¾Ý¿â show databases;
ÁгöËùÓÐÊý¾Ý±í show tables;
¸Ä±äÁ¬½ÓÊý¾Ý¿â use databaes
 
 
²åÈë¼Ç¼ insert into users(UserName,Password) values('ivwshjj','123456');
ɾ³ý¼Ç¼ delete from users  ......

pbÁ¬½ÓmySqlÊý¾Ý¿â

PBÁ¬½ÓMySQLÊý¾Ý¿â
 
È¥mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØodbc connector(http://dev.mysql.com/downloads/connector/odbc/)
ÏÂÔØµÄÊÇmysql-connector-odbc-noinstall-5.1.6-win32.zip
½âѹºóÖ±½ÓÔËÐÐÎļþ¼ÐÖÐµÄ Install.bat Åú´¦ÀíÎļþ
mysql-connectorÓкü¸ÖÖ£¬Ñ¡ÔñÒ»¸ö×Ô¼ºÏ²»¶µÄ¼´¿É¡£
ÔÚxpÖдò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖ ......

mysql gui tools ʹÓÃ

¸Õ¿ªÊ¼²Ù×÷Êý¾Ý¿âʱÎÒÒ»°ãÊDz»Ê¹ÓÃʲôgui¹¤¾ßµÄ£¬ÎÒÊÇÖ±½ÓʹÓÃcmdϲÙ×÷µÄ£¬¸Ð¾õÓÃÆðÀ´Ò²Í¦²»´íµÄ¡£
×î½ü¿´µ½ÓÐgui¹¤¾ßÄÇÒ²²»´í°¡£¬¾ÍÏÂÀ´Ê¹ÓÃһϣ¬ÎÒϲ»¶ÏµÄÊÇѹËõ°üÃâ°²×°µÄ£¬ÕâÑù¸Ð¾õ±È½ÏÊæ·þ°¡
´ò¿ª²éѯ¹¤¾ßÊǾ¹È»³ö´íÁË£¬²»¹ýÄÜÕý³£Ê¹Óõ쬵±Ê±Ò²Ã»ÓÐ×¢Ò⣬½ñÌìÌØÒâµÄ¿´ÁËÒ»ÏÂ
Ó¦¸ÃÊÇmysqlqb_functions.xml¼ÓÔØ ......

¡¾Ô­´´¡¿MySQLÊý¾Ý¿â´æ´¢ÒýÇæºÍ·ÖÖ§ÏÖ×´

 
[Ô­´´] MySQLÊý¾Ý¿â´æ´¢ÒýÇæºÍ·ÖÖ§ÏÖ×´
ÔÚMySQL¾­ÀúÁË2008ÄêSunµÄÊÕ¹ººÍ2009ÄêOracleÊÕ¹ºSunµÄ¹ý³ÌÖУ¬»ù±¾´¦ÓÚÍ£ÖÍ·¢Õ¹µÄÇé¿ö£¬ÔÚ¿ÉÒÔÔ¤¼ûµÄδÀ´£¬MySQLÊǿ϶¨»á±»Oracle¸éÖò¢ÇÒÖð²½Ñ©²ØÏûÃðµôµÄ¡£MySQLËæ×ÅÏàÓ¦µÄ¸÷Ö÷´´ºÍÄÚ²¿¿ª·¢ÈËÔ±µÄÀëÈ¥£¬µÞÔìÁ˸÷¸ö²»Í¬µÄÒýÇæºÍ·ÖÖ§£¬ÈÃMySQLÓÐÏ£Íû¼ÌÐø·¢Ñï¹â´óÆðÀ´¡£
±¾ ......

Mysql Error #2002: Can't connect to local

ÔÚSentOS 5ÖУº
>>yum install mysql
°²×°Íê±Ïºó£¬
>>mysql
error:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)";
½ñÌì·þÎñÆ÷Óöµ½ÁËÒ»¸öºÜÊìϤµÄÎÊÌâ
ÊäÈë
#mysql -u root -p
 
ERROR 2002 (HY000):Can't connect to local MySQL server
 
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ