Re: ��MYSQLʱ�亯��

Article View: cn.bbs.comp.database

Article #258

Back to cn.bbs.comp.database Previous Next

#258

From: Dem��ɫ�н��
Date: Thu, 11 Jun 2009 15:50

24 lines
1663 bytes

���������:
PERIOD_ADD(P,N)  
��������N���µ��׶�P���Ը�ʽYYMM��YYYYMM)���Ը�ʽYYYYMM����ֵ��ע��׶β���P
��������ֵ��  
����mysql> select PERIOD_ADD(9801,2);  
����-> 199803  

�� �� newbee (��) �Ĵ������ᵽ: ��
: ������һ��ͼ��黹�ı�
: ��ﵽ����һ��Ч��
: �û�insert valueʱ ֻ��Ҫ�ѽ���ʱ��borrowtimeд��
: mysql�Զ���� ����ʱ��returntime�����Ϊһ����
: �Ҹ���ô������лл
: Create table borrow
:  (
: bno char(3),
: sno char(9),
: borrowtime date not null,
: .................������ʡ�ԣ�

--
http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg

[m[1;34m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.144.168][m

Technical Details

Message-ID: <4gN9Zd$b4b@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show 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!news1.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 15:50:25 GMT
Organization: ��ˮ˼Դ
Message-ID: <4gN9Zd$b4b@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1244735415.A
Lines: 23

Article View: cn.bbs.comp.database

Re: ���MYSQLʱ�亯������

Re: ��MYSQLʱ�亯��