ÇëÎÊÒ»¸ömysqlɾ³ýÓû§µÄÎÊÌâ
ÓиöÂÛ̳£¬ÏÖÔÚÏëÓÃsqlÓï¾äɾ³ý·¢ÌûÊýΪ0µÄÓû§
ÓÐ3¸ö±íÊǸúÓû§Ïà¹ØµÄ£¬A¡¢B¡¢C
·¢ÌûÊýµÄ×Ö¶ÎÔÚC±íÀΪpostnum
ABCÈý¸ö±íÀï¶¼ÓÐÓû§µÄid×Ö¶Îuid
Èç¹ûÏëɾ³ý·¢ÌûÊýΪ0µÄÓû§£¬ÒÔ¼°´ËÓû§ÔÚÈý¸ö±íÀïµÄËùÓÐÊý¾Ý
ÇëÎÊÓï¾ä¸ÃÔõôд
лл£¡{{
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......
ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......
SQL code:
create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
EXECUTE SqlCMD1;
EXE ......