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

MysqlÊý¾ÝÌáÈ¡Æ÷

        ¼¸¸öÔÂÇ°£¬ÊÜһλÀÏʦµÄίÍУ¬Òª°ïËû×öÒ»¸ö¹ØϵÊý¾Ý¿âģʽÐÅÏ¢ÌáÈ¡µÄСÏîÄ¿£¬Ö÷ÒªµÄ¹¦ÄÜʵÏÖ¾ÍÊǽ«¹ØϵÊý¾Ý¿âµÄ±í½á¹¹ºÍ×ֶεÄÐÅϢͨ¹ý±í¸ñµÄÐÎʽչʾ³öÀ´¡£ÎÒͨ¹ý´ÓÍøÉÏËѼ¯×ÊÁÏÒÔ¼°·­Êé²éÕÒ£¬ÏÈʵÏÖÁËÒ»¸ömysqlµÄÊý¾ÝÌáÈ¡Æ÷¡£Ïȸø´ó¼Ò·ÖÏíһϡ£ÉÔºóµÄ¼¸ÌìÄÚ»á°ÑÁíÒ»¸ömysql¹ØϵģʽÌáÈ¡Æ÷¸ø´ó¼Ò·ÖÏí¡£
Ò»£®¹¦ÄܽéÉÜ£º
±¾³ÌÐòÖ÷ÒªÓÃÀ´ÊµÏÖ¶ÔmysqlÊý¾Ý¿âÀïµÄ±íÊý¾ÝÐÅÏ¢½øÐÐÌáÈ¡£¬¿ÉÒÔ·½Ãæ¿ì½ÝµØ²é¿´¸÷¸öÊý¾Ý¿âºÍ²»Í¬µÄģʽºÍ±íÖ®¼äµÄÊý¾ÝÐÅÏ¢¡£
¶þ£®ÊµÏÖ¹ý³Ì£º
       1..²ÉÓÃNative Protocol Pure-javaÇý¶¯³ÌÐò, ¿ÉÒÔͨ¹ýʹÓÃÌض¨ÓÚ¹©Ó¦É̵ÄÍøÂçЭÒéÀ´Ö±½ÓÓëÊý¾Ý¿â½øÐн»»¥,µ¼ÈëÒ»¸öÌṩ´ËÇý¶¯³ÌÐòµÄjar°ü£¬²¢ÔÚÖ÷º¯ÊýÖÐ×¢²á´ËÇý¶¯¡£Ö÷Òª´úÂëÈçÏ£º
   2.ÔËÐгÌÐò£¬ÏÔʾÈçϵǼҳÃ棬ÔÚuseridÀ¸ÖÐÊäÈëmysqlÊý¾Ý¿âµÄÓû§Ãûroot£¬ÔÚpasswordÀ¸ÀïÊäÈëmysqlÊý¾Ý¿âÃÜÂë123456£¬ÔÚurlÀ¸ÖÐÊäÈëÁ¬½ÓmysqlÊý¾Ý¿âµÄurl£¬ÀýÈ磺jdbc:mysql://127.0.0.1:3306/test¡£Ö®ºó£¬Èç¹ûµã»÷È¡Ïû°´Å¥£¬ÔòÍ˳öϵͳ£»µã»÷µÇ¼ϵͳ£¬Ôò½øÐÐÅжϣ¬ÔÚÊäÈëµÄÓû§Ãû£¬ÃÜÂë»òURLÓдíÎóµÄʱºò£¬µ¯³ö´íÎóÏûÏ¢Ìáʾ¿ò½øÐÐÌáʾ£¬Ö»ÓÐÕýÈ·ÊäÈëºó²ÅÄܽøÈëÊý¾ÝÏÔʾҳÃæ¡£
µã»÷È·¶¨°´Å¥ºó£¬Çå¿ÕÒÔÇ°´íÎóÐÅÏ¢£¬¹â±ê¶¨Î»ÔÚuseridÁС£Ö÷Òª´úÂëÈçÏ£º
        3.³É¹¦µÇ¼ºó£¬ÐÅÏ¢³õʼ»¯Ò³ÃæÊÇĬÈÏÑ¡ÔñµÇ¼µÄÊý¾Ý¿âÃû³Æ£¬¼ÙÈçURLÖÐÓõ½µÄÊÇTestÊý¾Ý¿âµÇ¼£¬ÔòĬÈÏÑ¡ÔñtestÊý¾Ý¿â£¬SchemaºÍTable¶¼ÊÇ´Ë¿âÖеĵÚÒ»ÌõÊý¾Ý¡£Èç¹ûΪ¿Õ£¬ÏÂÀ­¿ò¿Ø¼þÏÔʾΪ²»¿ÉÓÃ״̬¡£
Èç¹ûURLÎı¾¿òÖиÄΪjdbc:mysql://127.0.0.1:3306/onlinexam£¬Ôòµã»÷µÇ¼ºóµ¯³öµÄÖ÷Ò³ÃæΪ
Õû¸öÒ³ÃæÓÉÈý²¿·Ö×é³É£¬²ÉÓÃBorderLayout²¼¾Ö¹ÜÀíÆ÷£¬±±ÃæÊDzéѯµÄPanel£¬ÖмäÊÇÊý¾Ý¿â±íÐÅÏ¢µÄÏÔʾPanel£¬ÄÏÃæÊÇÍ˳öÃæ°åµÄPanel¡£
    ÔÚ²éѯPanelÖУ¬Í¨¹ýcatalogÏÂÀ­¿òÑ¡Ôñ²»Í¬µÄÊý¾Ý¿â£¬×Ô¶¯³õʼ»¯schemaÓû§ºÍtable±í£¬Èç¹ûΪ¿Õ£¬Ôò²»ÏÔʾÊý¾Ý£¬ÇÒÏÂÀ­¿ò²»¿ÉÓá£CatalogÏÂÀ­¿ò£¬SchemaÏÂÀ­¿ò£¬TableÏÂÀ­¿ò¼àÌýʼþ³ÌÐòΪ£º
    ·Ö±ðÓÃÈý¸öº¯ÊýÀ´ÊµÏÖ¶ÔÈý¸öÏÂÀ­¿òÐÅÏ¢µÄ×°ÔØ£¬È»ºóÓÃÒ»¸öº¯ÊýÀ´ÊµÏÖ¶ÔÖмäPanelµÄ±íÊý¾ÝÐÅÏ¢µÄ²éѯ£º
ÏÂÃæչʾʵÏÖµÄÇé¿ö.
        ¶ø×îºó£¬ÓÃÒ»¸öÄÚ²¿ÀàÀ´ÊµÏÖ¶Ô±í¸ñµÄ¶¯Ì¬Ìî³ä£¬Í¨¹ý¼Ì³ÐAbs


Ïà¹ØÎĵµ£º

mysql 5.0×ܽá͵µÃ


mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ý³ÌûÓвÎÊý´«µÝ
Èý.ɾ³ý´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
drop procedure sp_name// ......

´´½¨mysqlʵÀý

1. ÔÚ/etc/my.cnfÖмÓÈëÒ»ÏÂÄÚÈÝ [mysqld_dev]
socket=/tmp/mysql.sock
port=3307
pid-file=/var/run/mysqld/mysqld_dev.pid
datadir=/var/lib/mysql_dev
log=/var/log/mysqld_dev.log
log-error=/var/log/mysqld_dev.err.log
user=mysql 2. ¸ù¾ÝÒÔÉÏÄÚÈÝ´´½¨Ä¿Â¼ºÍÎļþ mkdir /var/lib/mysqld_dev chown mys ......

MySQLÖеÄÒ»¸öÄÑÌâ

×òÌ죬ÎÒͻȻÏë°ÑÒ»¸öÊý¾Ý¿âÀïµÄÿ¸ö±í£¬ÒÔ¼°Ã¿¸ö±íµÄ·Ç¿Õ×ܼͼÊý´æÔÚÁíÒ»¸ö±íÀïÃæ¡£
Ê×ÏÈ£¬´´½¨ÁËÒ»¸ö´æ·ÅÊý¾ÝµÄ±í£º
create table tables
(
name varchar(50),
number int
);
insert into tables select table_name from information_schema.tables where table_shema = 'test';
µ«ÊDz»ÖªµÀÓÐûÓз½·¨£¬½«·Ç¿ÕµÄ ......

FC7ÏÂmysql°²×°ÓëÆô¶¯

Ò»:°²×°
    ÎÞÂÛÄãϲ»¶µÄÊÇÄÄÖÖLINUXÌ×¼þ£¬Ëü¶¼ÓпÉÄÜ´øÓÐMySQL¡£Slackware,Ret Hat,SusEºÍDebianÖж¼ÔÚËüÃǵĵ±Ç°°æ±¾Öаüº¬ÁËËü£¬Õ⽫ÌṩһÖÖ×î¼òµ¥µÄ·½Ê½À´¿ìËÙ°²×°ºÍÔËÐÐMySQL¡£Èç¹ûÄãµÄ·¢Ðа汾ÖÐûÓÐÌṩMySQLÈí¼þ°ü£¬»òÕßÄãÏëµÃµ½×îеİ汾£¬Äã¿ÉÒÔ´ÓMySQLµÄÍøÕ¾:www.mysql.comÉÏÏÂÔضþ½øÖÆ°ü»òÔ ......

Javaµ÷Óô洢¹ý³Ì(MySqlÊý¾Ý¿â)

Ò»¡¢½¨±í
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(16) NOT NULL default '',
  `REMARK` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ