´úÂë:
(1)
string query = "call SelectAllCreatureTemplate()";
int t = mysql_query(mysql, query.c_str());
MYSQL_RES* m_res = mysql_store_result(mysql);
(2)
string query = "call SelectAllCreatureTemplate";
int t = mysql_query(mysql, query.c_str());
MYSQL_RES* ......
ÎÒÓõÄÊÇMySQL Server5.0ÂÌÉ«°æµÄ£¬ÎÒ¸øËü¿ªÁË3506¶Ë¿Ú
ÔÚÓÐЩ¼ÆËã»úÉÏ£¬¹ýû¶à¾ÃËü¾Í»á×Ô¶¯¹Ø±Õ£¬µ«ÓÐЩ¼ÆËã»úÉÏÓÖ²»»á
Õâ¸öÎÊÌâ¸ÃÔõô´¦Àí°¡£¿
cmd --> F:\MySql\MySqlServer5.1\bin\mysqld --install ¼ÓÈë·þÎñ
Õâ¸ö°¡£¿
ÄÇôÉÙÐÅÏ¢±È½ÏÄÑÅжÏ
ÕâÑù°É
ÄãÈ¥¿´¿´dataµÄĿ¼ÏÂerrºó׺µÄÎļþÀï ......
jsp+JavaBeanÈçºÎÉÏ´«Í¼Æ¬µ½mysqlÊý¾Ý¿â ²¢´ÓÊý¾Ý¿âÖжÁȡͼƬÏÔʾÔÚjspÒ³ÃæÉÏ °üÀ¨ÏÞÖÆÍ¼Æ¬´óС ¸ñʽ µÈ ×îºÃ¸ø³öÍêÕûµÄ´úÂë ÈçÄÜÔËÐгɹ¦Á¢¿Ì¸ø·Ö лл´ó¼Ò
ÎļþÉÏ´«Ð´¸öservlet°É...
<input file>ÀàÐÍ
Ìá½»µ½servlet,Ö¸¶¨Ò»ÏÂtype
²»Êǰɣ¬ÄãÒªËùÓеİ¡£¿
ÄÇÄã×Ô¼º×öʲô°¡£¡
mysqlÊý¾Ý¿âºÃÏñÃ»Ó ......
ÔÚÎÒµÄcmd´°¿Úϲ»ÄÜÓÃmysqlÕâ¸öÃüÁ˵£º'mysql' ²»ÊÇÄÚ²¿»òÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò
»òÅú´¦ÀíÎļþ¡£Õâ¸öÎÊÌâÓ¦¸ÃÔõô½â¾ö£¿
CMDÏÂÄÜÓÃMYSQL??ÔÎ
ÄãÏë×öʲô
°ÑÍêÕûµÄ·¾¶¼ÓÉÏ¡£
ÄãÓ¦¸ÃÅäһϻ·¾³±äÁ¿
ÎҵĵçÄÔ -ÓÒ¼ü-¸ß¼¶-»·¾³±äÁ¿
ÉèÖÃÄãÒªÓõÄexeÎļþ·¾¶
ÄãÖ±½ÓÔÚÅä»·¾³±äÁ¿ ......
Ò»£ºÊ×ÏÈÎҵıíʽInnoDbÀàÐ͵ġ£¡£
¶þ£ºÎÒÔÚmy.initÉèÖÃÁËinit_connect='set autocommit=0'
mysql°æ±¾ 5.1.32-community MySQL Community Server
µ«ÊÇʼÖÕ²»ÐУ¬²»Ðа¡£¬£¬¸ßÊÖ°ïæ£¬£¬°ïæ°¡¡£¡£¡£
ÔÚÃüÁîÐÐÏÂset @@autocommit=0;
mysql> show variables ......
ACMAIN_CHMµÄÌû×ÓÎÒÒ²¿´¹ýÁË£¬µ«ÊÇÎÒÕâ¸ö´æ´¢¹ý³ÌÖеÄÖÐÎÄ»¹ÊdzöÏÖÂÒÂë¡£ÎÒµÄÇé¿öÈçÏ£º
ÔÚphpmyadminÀïÃæÏÔʾÕâ¸ö´æ´¢¹ý³Ì£º
SQL code:
DROP PROCEDURE `pro1`//
CREATE PROCEDURE `pro1`(IN param VARCHAR(25) charset 'gb2312')
BEGIN
DECLARE woname VARCHAR(25);
SET woname=param;
SELECT woname; ......