Article View: cn.bbs.comp.database
Article #259Re: ���MYSQLʱ�亯������
From: Dem����ɫ�н�����
Date: Thu, 11 Jun 2009 16:05
Date: Thu, 11 Jun 2009 16:05
18 lines
1539 bytes
1539 bytes
�Ҳ�֪��MySQL�Dz�������ô��������... SQL Server�Ļ����ܿ�����trigger��UDF֮��... �� �� newbee (��) �Ĵ������ᵽ: �� : ������create tableʱ д������������ : �� �� ZAKU �Ĵ������ᵽ: �� : : ���������: : : PERIOD_ADD(P,N) : : ��������N���µ���P���Ը�ʽYYMM��YYYYMM)���Ը�ʽYYYYMM����ֵ��ע��β���P : : ��������ֵ�� : : ����mysql> select PERIOD_ADD(9801,2); : : ����-> 199803 -- http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg [m[1;37m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.144.168][m
Technical Details
Message-ID:
<4gNA4k$bKl@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 4df683fd51,a0a8304aa5e9f69f,start X-Google-Attributes: gid4df683fd51,public,usenet X-Google-NewGroupId: yes X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: ZAKU.bbs@bbs.sjtu.edu.cn (Dem����ɫ�н�����) Newsgroups: cn.bbs.comp.database Subject: Re: ���MYSQLʱ�亯������ Date: 11 Jun 2009 16:05:02 GMT Organization: ��ˮ˼Դ Message-ID: <4gNA4k$bKl@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1244736238.A Lines: 17