MyEclipse6.6 Á¬½ÓMySQLµÄÊý¾Ý¿âÅäÖÃ
1¡¢´ò¿ªMyEclipse6.6
2¡¢Ñ¡Ôñ²Ëµ¥£ºWindow/Open Perspective/MyEclipse Database Explorer£¬µã»÷OK£¬ÔÚ×ó±ß´ò¿ªDB Brower´°¿Ú¡£
3¡¢ÔÚDB Brower´°¿ÚÄÚÈÎÒâ¿Õ°×´¦»÷ÓÒ¼ü£¬Ñ¡ÔñNewÃüÁµ¯³öDatabase Driver´°¿Ú
4¡¢±¾´°¿Ú¸÷Ïî˵Ã÷£º
Driver template: MySQL Connector/J Ñ¡ÔñÇý¶¯Ä£°å
Driver name: mybook ÈκÎÆð¸öÃû×Ö
Connection URL:jdbc:mysql://127.0.0.1:3306/book (bookÒª¸Ä³ÉÄãÒªÁ¬Êý¾Ý¿âµÄÃû×Ö)
User name:root (ÄãÊý¾Ý¿âµÄÓû§Ãû)
Password:root (ÄãÊý¾Ý¿âµÄ¿ÚÁî)
Driver JARs:µã»÷Add JARsÑ¡ÔñÄãµÄÇý¶¯°üËùÔÚ·¾¶ £¨°üÀ¨°üÃû£©
Driver classname:com.mysql.jdbc.Driver
5¡¢µã»÷Finish£¬½¨Á¢Íê³É¡£
6¡¢½øÐÐÁ¬½Ó£¬ÔÚDB Brower´°¿ÚÑ¡ÖÐÄã¸Õ½¨µÄmybook£¬µã»÷DB Brower´°¿Ú±êÌâÀ¸ÓÒ²àµÄÈý½ÇÐÎͼ±ê£¬¹â±êÒƶ¯µ½ÆäÉÏʱ£¬»áÏÔʾ“Open Connection”Ìáʾ¡£
7¡¢¸ù¾ÝÌáʾÊäÈëÃÜÂë:root (Ñ¡ÖÐsave passwordºóÏ´ξͲ»ÓÃÊäÈëÃÜÂëÁË)£¬µã»÷OK
8¡¢ÕâʱDB Brower´°¿ÚÖеÄmybook¾Í¿ÉÕ¹¿ªÁË£¬Ò»Ö±µ½±í¡£
9¡¢TABLEÏÂÃæÊÇ±í£¬ÓÒ»÷Ò»¸ö±í£¬Ñ¡ÔñGenerate/Select Statement£¬ÔÚÓұߴò¿ªsql²Ù×÷´°¿Ú
10¡¢´ò¿ªµÄsql²Ù×÷´°¿ÚÀï×Ô¶¯²úÉú²éѯÓï¾ä£¬µã»÷ÉÏÃæµÄºìÉ«Èý½ÇÐμ´¿ÉÖ´ÐÐsql¡£
Ïà¹ØÎĵµ£º
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1.×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ´¦Àí
MYSQLÓÐ ......
Ò» ÏÂÔØMySQL
http://dev.mysql.com/downloads/mysql/5.0.html
½âѹMySQL£¨F:\Program Files\MySQL\£©MySQL°²×°Ä¿Â¼
¶þ н¨my.ini
ÔÚF:\Program Files\MySQL\Ͻ¨Á¢my.iniÎļþ£¬ÄÚÈÝΪ
my.ini
[mysqld]
# ÉèÖÃmysqlµÄ°²×°Ä¿Â¼
basedir=F:\\Program Files\\MySQL
# ÉèÖÃmysqlÊý¾Ý¿âµÄÊý¾ÝµÄ´æ·ÅĿ¼£¬±ØÐ ......
MySql³£ÓÃÃüÁî
¡¾MySqlÃüÁî´°¿ÚÆô¶¯£ºÇëÖ´ÐÐ\bin\mysql.exe¡¿
1:ʹÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
mysql> SHOW DATABASES;
2:´´½¨Ò»¸öÊý¾Ý¿âMYSQLDATA
mysql> CREATE DATABASE MYSQLDATA;
3:Ñ¡ÔñÄãËù´´½¨µÄÊý¾Ý¿â
mysql> USE MYSQLDATA; (°´»Ø³µ¼ü³öÏÖDatabase changed Ê±Ë ......
ÏÂÊÖ´¦£ºµÇ½mysql´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G ²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊǼà¿ØMYSQL¸´ÖÆij¸ö´Ó·þÎñÆ÷µÄÊä³ö£º
mysql> show slave status\G
*************************** 1. row ***************************
&nbs ......
MySQL °æ±¾£º5.0.45 phpMyAdmin°æ±¾£º2.11.3
Ê×ÏÈ¿´MySQL 5.0²Î¿¼ÊÖ²áÖйØÓÚ´´½¨´æ´¢¹ý³ÌµÄÓ﷨˵Ã÷£º
CREATE
[DEFINER = { user | CURRENT_USER }]
PROCEDURE sp_name ([proc_parameter[,...]])
[characteristic ...] r ......