mysql °²×°ÎÊÌ⣨³õѧzhe) - MS-SQL Server / »ù´¡Àà
°²×°Æ½Ì¨£ºwin7(32bit)
mysql°æ±¾5.1.43
ÎÊÌâ1£ºµ±ÎÒÌí¼ÓinnoDB(ÒýÇæ£©µÄʱºò£¬service ͨ²»¹ý£¿£¨ÎÒÌí¼ÓÔÚÎÒµÄDÅ̸ùĿ¼ÉÏ£©
ÎÊÌâ2£º¼ÈȻͨ²»¹ýÒ²¾ÍËãÁË£¬ÎÒ²»ÓÃinnoDBÁË£¬ÎÒÅäÖÃstandard configuration,ÅäÖóɹ¦¡£
È»ºóÎÒ...................:\mysqld
mysql test
Ìáʾ£ºcon't connect to mysql server on 'localhost'
ÎÒµÄ ±¾µØIPÊÇ10.145.18.56£¬ÎÒtelnet 10.145.18.56 3306 Ò²ÎÞ·¨´ò¿ª¡£·À»ðǽÒѹرա£
ÎÒÔõô½â¾ö°¡£¿
лл2Â¥£¬ÅäÖÃinnoDBÒѾ³É¹¦£¡
²»¹ý»¹ÊÇÓÐÎÊÌ⣬Æô¶¯·þÎñÆ÷£ºd:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld --console
³ö´í¡£
MYSQL²»¶®..
ûÓÐÈËÖªµÀ£¿£¿£¿£¿
Ïà¹ØÎÊ´ð£º
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä
Id value state dattime
101 32.3 0 ......