Peekingin5.0alphaEnterpriseFunctional<Function&Procedure>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

PeekinginMySQL5.0EnterpriseFunctional

©byDennisDLL(丹舟)2004.01


     MySQL5.0Alpha發佈,我們期待已久的CreateFunction和CreateProcedure的功能終於有了.詳細的資訊請參考MySQLAB的官方網站的新聞.早就想要的功能,出來了還不趕快試試....

    本文以WindowsXPPROos為例&lt; :)我可不是有意來替M$宣傳,只是我用的是Windows,沒有辦法啦>來說明,其它OS類同,先下載MySQL5.0,為了免除安裝,我們直接下載Withoutinstaller(unzipinC:/)的版本,到http://www.mysql.com/downloads/mysql-5.0.html 下載.

1.直接unzip後把其放到C:/下,並把rootDirectory改為mysql(不改也可,那在my.ini中要把其中的mysql改為你的實際名稱)

2.下面是my.ini的配置文件,如果你對配置不熟的話,你可以直接 Copy過去存為my.ini後放到C:/windows下即可(我電腦的RAM=256)
========================================================================================================
#Examplemysqlconfigfile.
#Copythisfiletoc:/my.cnftosetglobaloptions
#
#Onecanusealllongoptionsthattheprogramsupports.
#Runtheprogramwith--helptogetalistofavailableoptions

#Thiswillbepassedtoallmysqlclients
[client]
#password=my_password
port=3306
#socket=MySQL

#Hereisentriesforsomespecificprograms
#Thefollowingvaluesassumeyouhaveatleast32Mram

#TheMySQLserver
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable =key_buffer=16M
set-variable =max_allowed_packet=1M
set-variable =table_cache=64
set-variable =sort_buffer=512K
set-variable =net_buffer_length=8K
set-variable =myisam_sort_buffer_size=8M
server-id =1

#Uncommentthefollowingifyouwanttologupdates
#log-bin

#UncommentthefollowingrowsifyoumovetheMySQLdistributiontoanother
#location
#basedir=d:/mysql/
#datadir=d:/mysql/data/


#UncommentthefollowingifyouareNOTusingBDBtables
#skip-bdb

#UncommentthefollowingifyouareusingBDBtables
#set-variable =bdb_cache_size=4M
#set-variable =bdb_max_lock=10000

#UncommentthefollowingifyouareusingInnobasetables
innodb_data_file_path=ibdata1:400M
innodb_data_home_dir=C:/mysql/InnoDB/ibdata          #InnoDB及ibdata的資料夾你要自己動手
innodb_log_group_home_dir=C:/mysql/InnoDB/iblogs  #iblogs的資料夾同樣你要自己動手
innodb_log_arch_dir=C:/mysql/innodb/iblogs
set-variable=innodb_mirrored_log_groups=1
set-variable=innodb_log_files_in_group=3
set-variable=innodb_log_file_size=5M
set-variable=innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable=innodb_buffer_pool_size=16M
set-variable=innodb_additional_mem_pool_size=2M
set-variable=innodb_file_io_threads=4
set-variable=innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable =max_allowed_packet=16M

[mysql]
no-auto-rehash1<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>