MYSQL´¥·¢Æ÷µÄÎÊÌ⣬Çë¸ßÊÖ½â´ð
fetchpaper±íÖÐÓÐnum×ֶΣ¬Ìí¼Ó´¥·¢Æ÷µÄÄ¿µÄ¾ÍÊÇÈÃnum×Ô¶¯ÌîÈëµ½Êý¾Ý¿âÖУ¬ÀûÓô¥·¢Æ÷×Ô¶¯Ôö¼Ó²¢ÇÒ²»ÄÜÖØ¸´£¬ÕâÊÇÎÒ¸ù¾ÝoracleÊý¾Ý¿â´¥·¢Æ÷дµÄ£¬´óÏÀÃÇ¿´¿´´íÔÙÄÄÀ
CREATE TRIGGER TIB_FETCHPAPER BEFORE
INSERT ON FETCHPAPER FOR EACH ROW
declare @row_count int(10),
declare @max_num char(100),
declare @zero_today char(100),
begin
case
when inserting then
@zero_today =select CONCAT('0391',DATE_FORMAT(curdate(),'%Y%m%d'),RPAD('0',4,'0'))
select @row_count=count(*) from fetchpaper
if @row_count = 0 then
@max_num=@zero_today
else
select @max_num=max(num)from fetchpaper
end if
if @max_num <@zero_today then
@max_num=@zero_today
end if
if NEW.num is null then
NEW.num=select rpad((@max_num)+1),14,'0')
end if
when updating('num') then
if NEW.num!=OLD.num then
NEW.num=OLD.num
end if
end case
end;
create table FETCHPAPER
(
ID int not null auto_increment comment 'ʵÃûÖÆÁìÁϵ¥ID',
WAREHOUSEID int
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
±íÁÐ×Ö¶ÎÔÚÎÞÖµµÄÇé¿öÏÂ
ĬÈÏֵΪnullºÃ,»¹Êǿհ×ÖµºÃÄØ?
1)¶ÔÊý¾Ý²åÈë/²éѯ/µÄÓ°ÏìÈçºÎ?
2)¶Ô¸ÃÁнøÐÐË÷Òý,»áÓв»Í¬µÄЧÓÃô?
´ó¼ÒÒ»°ã¶Ô±êÌâ×ֶεÄλÊýÉèΪ¶àÉÙ?256
ÕýÎÄ×ֶεÄ?text?
¼¸Ç§ÍòÌõµÄÊý¾Ý´æ´¢,Òª ......