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²»¶®..
ûÓÐÈËÖªµÀ£¿£¿£¿£¿
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......