| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mysql >> MySQL shu ju ku zhong she lie de mo ren zhi wei Now() de jie shao

MySQL shu ju ku zhong she lie de mo ren zhi wei Now() de jie shao

2008-08-15 06:29:26 编辑來源:互联网 评论
 
 
 
本文为【MySQL数据库中设列的默认值为Now()的介绍】的拼音翻译版
  MySQL mu qian bu zhi chi lie de Default wei han shu de xing shi ,
  ru da dao ni mou lie de mo ren zhi wei dang qian geng xin ri qi yu shi jian de gong neng ,
  ni ke yi shi yong TIMESTAMP lie lei xing
  xia mian jiu xiang xi shuo ming TIMESTAMP lie lei xing :
  TIMESTAMP lie lei xing
  TIMESTAMP zhi ke yi cong 1970 de mou shi de kai shi yi zhi dao 2037 nian , jing du wei yi miao , qi zhi zuo wei shu zi xian shi 。
  TIMESTAMP zhi xian shi chi cun de ge shi ru xia biao suo shi :
  +---------------+----------------+
  | lie lei xing | xian shi ge shi |
  | TIMESTAMP(14) | YYYYMMDDHHMMSS |
  | TIMESTAMP(12) | YYMMDDHHMMSS |
  | TIMESTAMP(10) | YYMMDDHHMM |
  | TIMESTAMP(8)| YYYYMMDD |
  | TIMESTAMP(6)| YYMMDD |
  | TIMESTAMP(4)| YYMM |
  | TIMESTAMP(2)| YY |
  +---------------+----------------+
  “ wan zheng ”TIMESTAMP ge shi shi 14 wei , dan TIMESTAMP lie ye ke yi yong geng duan de xian shi chi cun chuang zao
  zui chang jian de xian shi chi cun shi 6、8、12、 he 14。
  ni ke yi zai chuang jian biao shi zhi ding yi ge ren yi de xian shi chi cun , dan shi ding yi lie chang wei 0 huo bi 14 da yun hui bei qiang zhi ding yi wei lie chang 14。
  lie chang zai cong 1~13 fan wei de qi shu zhi chi cun yun bei qiang zhi wei xia yi ge geng da de ou shu 。
  ding yi zi duan chang du qiang zhi zi duan chang du
  TIMESTAMP(0) ->TIMESTAMP(14)
  TIMESTAMP(15)->TIMESTAMP(14)
  TIMESTAMP(1) ->TIMESTAMP(2)
  TIMESTAMP(5) ->TIMESTAMP(6)
  suo you de TIMESTAMP lie dou you tong yang de cun chu da xiao ,
  shi yong bei zhi ding de shi qi shi jian zhi de wan zheng jing du (14 wei ) cun chu he fa de zhi bu kao lv xian shi chi cun 。
  bu he fa de ri qi , jiang hui bei qiang zhi wei 0 cun chu
  zhe you ji ge han yi :
  1、 sui ran ni jian biao shi ding yi le lie TIMESTAMP(8), dan zai ni jin xing shu ju cha ru yu geng xin shi TIMESTAMP lie shi ji shang bao cun le 14 wei de shu ju ( bao kuo nian yue ri shi fen miao ), zhi bu guo zai ni jin xing cha xun shi MySQL fan hui gei ni de shi 8 wei de nian yue ri shu ju 。 ru guo ni shi yong ALTER TABLE tuo kuan yi ge xia zhai de TIMESTAMP lie , yi qian bei “ yin bi ” de xin xi jiang bei xian shi 。
  2、 tong yang , suo xiao yi ge TIMESTAMP lie bu hui dao zhi xin xi shi qu , chu le gan jiao shang zhi zai xian shi shi , jiao shao de xin xi bei xian shi chu 。
  3、 jin guan TIMESTAMP zhi bei cun chu wei wan zheng jing du , zhi jie cao zuo cun chu zhi de wei yi han shu shi UNIX_TIMESTAMP(); you yu MySQL fan hui TIMESTAMP lie de lie zhi shi jin guo ge shi hua hou de jian suo de zhi , zhe yi wei zhe ni ke neng bu neng shi yong mou xie han shu lai cao zuo TIMESTAMP lie ( li ru HOUR() huo SECOND()), chu fei TIMESTAMP zhi de xiang guan bu fen bei bao han zai ge shi hua de zhi zhong 。 li ru , yi ge TIMESTAMP lie zhi you bei ding yi wei TIMESTAMP(10) yi shang shi ,TIMESTAMP lie de HH bu fen cai hui bei xian shi , yin ci zai geng duan de TIMESTAMP zhi shang shi yong HOUR() hui chan sheng yi ge bu ke yu zhi de jie guo 。
  4、 bu he fa TIMESTAMP zhi bei bian huan dao shi dang lei xing de “ ling ” zhi (00000000000000)。(DATETIME,DATE yi ran ) ni ke yi shi yong xia lie yu ju lai yan zheng :
  CREATE TABLE test ('id' INT (3) UNSIGNED AUTO_INCREMENT, 'date1' TIMESTAMP (8) PRIMARY KEY('id'));
  INSERT INTO test SET id = 1;
  SELECT * FROM test;
  +----+----------------+
  | id | date1|
  +----+----------------+
  |1 | 20021114 |
  +----+----------------+
  ALTER TABLE test CHANGE 'date1' 'date1' TIMESTAMP(14);
  SELECT * FROM test;
  +----+----------------+
  | id | date1|
  +----+----------------+
  |1 | 20021114093723 |
  +----+----------------+
  ni ke yi shi yong TIMESTAMP lie lei xing zi dong di yong dang qian de ri qi he shi jian biao ji INSERT huo UPDATE de cao zuo 。
  ru guo ni you duo ge TIMESTAMP lie , zhi you di yi ge zi dong geng xin 。
  zi dong geng xin di yi ge TIMESTAMP lie zai xia lie ren he tiao jian xia fa sheng :
  1、 lie zhi mei you ming que di zai yi ge INSERT huo LOAD DATA INFILE yu ju zhong zhi ding 。
  2、 lie zhi mei you ming que di zai yi ge UPDATE yu ju zhong zhi ding qie ling wai yi xie de lie gai bian zhi 。( zhu yi yi ge UPDATE she zhi yi ge lie wei ta yi jing you de zhi , zhe jiang bu yin qi TIMESTAMP lie bei geng xin , yin wei ru guo ni she zhi yi ge lie wei ta dang qian de zhi ,MySQL wei le xiao lv er hu lue geng gai 。)
  3、 ni ming que di she ding TIMESTAMP lie wei NULL.
  4、 chu di yi ge yi wai de TIMESTAMP lie ye ke yi she zhi dao dang qian de ri qi he shi jian , zhi yao jiang lie she wei NULL, huo NOW()。
  CREATE TABLE test (
  'id' INT (3) UNSIGNED AUTO_INCREMENT,
  'date1' TIMESTAMP (14),
  'date2' TIMESTAMP (14),
  PRIMARY KEY('id')
  );
  INSERT INTO test (id, date1, date2) VALUES (1, NULL, NULL);
  INSERT INTO test SET id= 2;
  +----+----------------+----------------+
  | id | date1| date2|
  +----+----------------+----------------+
  |1 | 20021114093723 | 20021114093723 |
  |2 | 20021114093724 | 00000000000000 |
  +----+----------------+----------------+
  
  -> di yi tiao zhi ling yin she date1、date2 wei NULL, suo yi date1、date2 zhi yun wei dang qian shi jian
  di er tiao zhi ling yin mei you she date1、date2 lie zhi , di yi ge TIMESTAMP lie date1 wei geng xin wei dang qian shi jian ,
  er er ge TIMESTAMP lie date2 yin ri qi bu he fa er bian wei “00000000000000”
  UPDATE test SET id= 3 WHERE id=1;
  +----+----------------+----------------+
  | id | date1| date2|
  +----+----------------+----------------+
  |3 | 20021114094009 | 20021114093723 |
  |2 | 20021114093724 | 00000000000000 |
  +----+----------------+----------------+
  -> zhe tiao zhi ling mei you ming que di she ding date2 de lie zhi , suo yi di yi ge TIMESTAMP lie date1 jiang bei geng xin wei dang qian shi jian
  UPDATE test SET id= 1,date1=date1,date2=NOW() WHERE id=3;
  +----+----------------+----------------+
  | id | date1| date2|
  +----+----------------+----------------+
  |1 | 20021114094009 | 20021114094320 |
  |2 | 20021114093724 | 00000000000000 |
  +----+----------------+----------------+
  -> zhe tiao zhi ling yin she ding date1=date1, suo yi zai geng xin shu ju shi date1 lie zhi bing bu hui fa sheng gai bian
  er yin she ding date2=NOW(), suo yi zai geng xin shu ju shi date2 lie zhi hui bei geng xin wei dang qian shi jian
  ci zhi ling deng xiao wei UPDATE test SET id= 1,date1=date1,date2=NULL WHERE id=3;
  yin MySQL fan hui de TIMESTAMP lie wei shu zi xian shi xing shi ,
  ni ke yi yong DATE_FROMAT() han shu lai ge shi hua TIMESTAMP lie
  SELECT id,DATE_FORMAT(date1,'%Y-%m-%d %H:%i:%s') As date1,
  DATE_FORMAT(date2,'%Y-%m-%d %H:%i:%s') As date2 FROM test;
  +----+---------------------+---------------------+
  | id | date1 | date2 |
  +----+---------------------+---------------------+
  |1 | 2002-11-14 09:40:09 | 2002-11-14 09:43:20 |
  |2 | 2002-11-14 09:37:24 | 0000-00-00 00:00:00 |
  +----+---------------------+---------------------+
  SELECT id,DATE_FORMAT(date1,'%Y-%m-%d') As date1,
  DATE_FORMAT(date2,'%Y-%m-%d') As date2 FROM test;
  +----+-------------+-------------+
  | id | date1 | date2 |
  +----+-------------+-------------+
  |1 | 2002-11-14| 2002-11-14|
  |2 | 2002-11-14| 0000-00-00|
  +----+-------------+-------------+
  zai mou zhong cheng du shang , ni ke yi ba yi zhong ri qi lei xing de zhi fu gei yi ge bu tong de ri qi lei xing de dui xiang 。
  er you qi zhu yi de shi : zhi you ke neng fa sheng yi xie gai bian huo xin xi de sun shi :
  1、 ru guo ni jiang yi ge DATE zhi fu gei yi ge DATETIME huo TIMESTAMP dui xiang , jie guo zhi de shi jian bu fen bei she zhi wei '00:00:00', yin wei DATE zhi zhong bu bao han you shi jian xin xi 。
  2、 ru guo ni jiang yi ge DATETIME huo TIMESTAMP zhi fu gei yi ge DATE dui xiang , jie guo zhi de shi jian bu fen bei shan chu , yin wei DATE lei xing bu cun chu shi jian xin xi 。
  3、 jin guan DATETIME, DATE he TIMESTAMP zhi quan dou ke yi yong tong yang de ge shi ji lai zhi ding ,
  dan suo you lei xing bu dou you tong yang de zhi fan wei 。
  li ru ,TIMESTAMP zhi bu neng bi 1970 zao , ye bu neng bi 2037 wan ,
  zhe yi wei zhe , yi ge ri qi li ru '1968-01-01', dang zuo wei yi ge DATETIME huo DATE zhi shi ta shi he fa de ,
  dan ta bu shi yi ge zheng que TIMESTAMP zhi ! bing qie ru guo jiang zhe yang de yi ge dui xiang fu zhi gei TIMESTAMP lie , ta jiang bei bian huan wei 0。 dang zhi ding ri qi zhi shi , dang xin mou xie que xian :
  1、 yuan xu zuo wei zi fu chuan zhi ding zhi de kuan song ge shi neng bei qi pian 。 li ru ,, yin wei “:” fen ge fu de shi yong , zhi '10:11:12' ke neng kan qi lai xiang shi jian zhi , dan shi ru guo zai yi ge ri qi zhong shi yong , shang xia wen jiang zuo wei nian fen bei jie shi cheng '2010-11-12'。 zhi '10:45:15' jiang bei bian huan dao '0000-00-00', yin wei '45' bu shi yi ge he fa de yue fen 。
  2、 yi 2 wei shu zi zhi ding de nian zhi shi mo hu de , yin wei shi ji shi wei zhi de 。MySQL shi yong xia lie gui ze jie shi 2 wei nian zhi : zai 00-69 fan wei de nian zhi bei bian huan dao 2000-2069。 zai fan wei 70-99 de nian zhi bei bian huan dao 1970-1999。【原文】【汉音对照
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
MySQL mu qian bu zhi chi lie de Default wei han shu de xing shi , ru da dao ni mou lie de mo ren zhi wei dang qian geng xin ri qi yu shi jian de gong neng , ni ke yi shi yong TIMESTAMP lie lei xing xia mian jiu xiang xi shuo ming TIMESTAMP lie lei xing :   TIMESTAMP lie lei xing TIMESTAMP zhi ke yi cong 1970 de mou shi de kai shi yi zhi dao 2037 nian , jing du wei yi miao , qi zhi zuo wei shu zi xian shi 。 TIMESTAMP zhi xian shi chi cun de ge shi ru xia biao suo shi : +---------------+----------------+ | lie lei xing     | xian shi ge shi     | | TIMESTAMP(14) | YYYYMMDDHHMMSS |  | TIMESTAMP(12) | YYMMDDHHMMSS  | | TIMESTAMP(10) | YYMMDDHHMM   | | TIMESTAMP(8) | YYYYMMDD    | | TIMESTAMP(6) | YYMMDD     | | TIMESTAMP(4) | YYMM      | | TIMESTAMP(2) | YY       | +---------------+----------------+ “ wan zheng ”TIMESTAMP ge shi shi 14 wei , dan TIMESTAMP lie ye ke yi yong geng duan de xian shi chi cun chuang zao zui chang jian de xian shi chi cun shi 6、8、12、 he 14。 ni ke yi zai chuang jian biao shi zhi ding yi ge ren yi de xian shi chi cun , dan shi ding yi lie chang wei 0 huo bi 14 da yun hui bei qiang zhi ding yi wei lie chang 14。 lie chang zai cong 1~13 fan wei de qi shu zhi chi cun yun bei qiang zhi wei xia yi ge geng da de ou shu 。   ding yi zi duan chang du    qiang zhi zi duan chang du TIMESTAMP(0) -> TIMESTAMP(14) TIMESTAMP(15)-> TIMESTAMP(14) TIMESTAMP(1) -> TIMESTAMP(2) TIMESTAMP(5) -> TIMESTAMP(6)   suo you de TIMESTAMP lie dou you tong yang de cun chu da xiao , shi yong bei zhi ding de shi qi shi jian zhi de wan zheng jing du (14 wei ) cun chu he fa de zhi bu kao lv xian shi chi cun 。 bu he fa de ri qi , jiang hui bei qiang zhi wei 0 cun chu    zhe you ji ge han yi : 1、 sui ran ni jian biao shi ding yi le lie TIMESTAMP(8), dan zai ni jin xing shu ju cha ru yu geng xin shi TIMESTAMP lie shi ji shang bao cun le 14 wei de shu ju ( bao kuo nian yue ri shi fen miao ), zhi bu guo zai ni jin xing cha xun shi MySQL fan hui gei ni de shi 8 wei de nian yue ri shu ju 。 ru guo ni shi yong ALTER TABLE tuo kuan yi ge xia zhai de TIMESTAMP lie , yi qian bei “ yin bi ” de xin xi jiang bei xian shi 。 2、 tong yang , suo xiao yi ge TIMESTAMP lie bu hui dao zhi xin xi shi qu , chu le gan jiao shang zhi zai xian shi shi , jiao shao de xin xi bei xian shi chu 。 3、 jin guan TIMESTAMP zhi bei cun chu wei wan zheng jing du , zhi jie cao zuo cun chu zhi de wei yi han shu shi UNIX_TIMESTAMP(); you yu MySQL fan hui TIMESTAMP lie de lie zhi shi jin guo ge shi hua hou de jian suo de zhi , zhe yi wei zhe ni ke neng bu neng shi yong mou xie han shu lai cao zuo TIMESTAMP lie ( li ru HOUR() huo SECOND()), chu fei TIMESTAMP zhi de xiang guan bu fen bei bao han zai ge shi hua de zhi zhong 。 li ru , yi ge TIMESTAMP lie zhi you bei ding yi wei TIMESTAMP(10) yi shang shi ,TIMESTAMP lie de HH bu fen cai hui bei xian shi , yin ci zai geng duan de TIMESTAMP zhi shang shi yong HOUR() hui chan sheng yi ge bu ke yu zhi de jie guo 。 4、 bu he fa TIMESTAMP zhi bei bian huan dao shi dang lei xing de “ ling ” zhi (00000000000000)。(DATETIME,DATE yi ran )   ni ke yi shi yong xia lie yu ju lai yan zheng : CREATE TABLE test ('id' INT (3) UNSIGNED AUTO_INCREMENT, 'date1' TIMESTAMP (8) PRIMARY KEY('id')); INSERT INTO test SET id = 1; SELECT * FROM test; +----+----------------+ | id | date1     | +----+----------------+ | 1 | 20021114    | +----+----------------+ ALTER TABLE test CHANGE 'date1' 'date1' TIMESTAMP(14); SELECT * FROM test; +----+----------------+ | id | date1     | +----+----------------+ | 1 | 20021114093723 | +----+----------------+ ni ke yi shi yong TIMESTAMP lie lei xing zi dong di yong dang qian de ri qi he shi jian biao ji INSERT huo UPDATE de cao zuo 。 ru guo ni you duo ge TIMESTAMP lie , zhi you di yi ge zi dong geng xin 。 zi dong geng xin di yi ge TIMESTAMP lie zai xia lie ren he tiao jian xia fa sheng :   1、 lie zhi mei you ming que di zai yi ge INSERT huo LOAD DATA INFILE yu ju zhong zhi ding 。 2、 lie zhi mei you ming que di zai yi ge UPDATE yu ju zhong zhi ding qie ling wai yi xie de lie gai bian zhi 。( zhu yi yi ge UPDATE she zhi yi ge lie wei ta yi jing you de zhi , zhe jiang bu yin qi TIMESTAMP lie bei geng xin , yin wei ru guo ni she zhi yi ge lie wei ta dang qian de zhi ,MySQL wei le xiao lv er hu lue geng gai 。) 3、 ni ming que di she ding TIMESTAMP lie wei NULL. 4、 chu di yi ge yi wai de TIMESTAMP lie ye ke yi she zhi dao dang qian de ri qi he shi jian , zhi yao jiang lie she wei NULL, huo NOW()。   CREATE TABLE test ( 'id' INT (3) UNSIGNED AUTO_INCREMENT, 'date1' TIMESTAMP (14), 'date2' TIMESTAMP (14), PRIMARY KEY('id') );   INSERT INTO test (id, date1, date2) VALUES (1, NULL, NULL); INSERT INTO test SET id= 2; +----+----------------+----------------+ | id | date1     | date2     | +----+----------------+----------------+ | 1 | 20021114093723 | 20021114093723 | | 2 | 20021114093724 | 00000000000000 | +----+----------------+----------------+ -> di yi tiao zhi ling yin she date1、date2 wei NULL, suo yi date1、date2 zhi yun wei dang qian shi jian di er tiao zhi ling yin mei you she date1、date2 lie zhi , di yi ge TIMESTAMP lie date1 wei geng xin wei dang qian shi jian , er er ge TIMESTAMP lie date2 yin ri qi bu he fa er bian wei “00000000000000”   UPDATE test SET id= 3 WHERE id=1; +----+----------------+----------------+ | id | date1     | date2     | +----+----------------+----------------+ | 3 | 20021114094009 | 20021114093723 | | 2 | 20021114093724 | 00000000000000 | +----+----------------+----------------+ -> zhe tiao zhi ling mei you ming que di she ding date2 de lie zhi , suo yi di yi ge TIMESTAMP lie date1 jiang bei geng xin wei dang qian shi jian    UPDATE test SET id= 1,date1=date1,date2=NOW() WHERE id=3; +----+----------------+----------------+ | id | date1     | date2     | +----+----------------+----------------+ | 1 | 20021114094009 | 20021114094320 | | 2 | 20021114093724 | 00000000000000 | +----+----------------+----------------+ -> zhe tiao zhi ling yin she ding date1=date1, suo yi zai geng xin shu ju shi date1 lie zhi bing bu hui fa sheng gai bian er yin she ding date2=NOW(), suo yi zai geng xin shu ju shi date2 lie zhi hui bei geng xin wei dang qian shi jian ci zhi ling deng xiao wei UPDATE test SET id= 1,date1=date1,date2=NULL WHERE id=3;    yin MySQL fan hui de TIMESTAMP lie wei shu zi xian shi xing shi , ni ke yi yong DATE_FROMAT() han shu lai ge shi hua TIMESTAMP lie SELECT id,DATE_FORMAT(date1,'%Y-%m-%d %H:%i:%s') As date1, DATE_FORMAT(date2,'%Y-%m-%d %H:%i:%s') As date2 FROM test; +----+---------------------+---------------------+ | id | date1        | date2        | +----+---------------------+---------------------+ | 1 | 2002-11-14 09:40:09 | 2002-11-14 09:43:20 | | 2 | 2002-11-14 09:37:24 | 0000-00-00 00:00:00 | +----+---------------------+---------------------+ SELECT id,DATE_FORMAT(date1,'%Y-%m-%d') As date1, DATE_FORMAT(date2,'%Y-%m-%d') As date2 FROM test; +----+-------------+-------------+ | id | date1    | date2    | +----+-------------+-------------+ | 1 | 2002-11-14 | 2002-11-14 | | 2 | 2002-11-14 | 0000-00-00 | +----+-------------+-------------+   zai mou zhong cheng du shang , ni ke yi ba yi zhong ri qi lei xing de zhi fu gei yi ge bu tong de ri qi lei xing de dui xiang 。 er you qi zhu yi de shi : zhi you ke neng fa sheng yi xie gai bian huo xin xi de sun shi :   1、 ru guo ni jiang yi ge DATE zhi fu gei yi ge DATETIME huo TIMESTAMP dui xiang , jie guo zhi de shi jian bu fen bei she zhi wei '00:00:00', yin wei DATE zhi zhong bu bao han you shi jian xin xi 。   2、 ru guo ni jiang yi ge DATETIME huo TIMESTAMP zhi fu gei yi ge DATE dui xiang , jie guo zhi de shi jian bu fen bei shan chu , yin wei DATE lei xing bu cun chu shi jian xin xi 。 3、 jin guan DATETIME, DATE he TIMESTAMP zhi quan dou ke yi yong tong yang de ge shi ji lai zhi ding , dan suo you lei xing bu dou you tong yang de zhi fan wei 。 li ru ,TIMESTAMP zhi bu neng bi 1970 zao , ye bu neng bi 2037 wan , zhe yi wei zhe , yi ge ri qi li ru '1968-01-01', dang zuo wei yi ge DATETIME huo DATE zhi shi ta shi he fa de , dan ta bu shi yi ge zheng que TIMESTAMP zhi ! bing qie ru guo jiang zhe yang de yi ge dui xiang fu zhi gei TIMESTAMP lie , ta jiang bei bian huan wei 0。 dang zhi ding ri qi zhi shi , dang xin mou xie que xian :   1、 yuan xu zuo wei zi fu chuan zhi ding zhi de kuan song ge shi neng bei qi pian 。 li ru ,, yin wei “:” fen ge fu de shi yong , zhi '10:11:12' ke neng kan qi lai xiang shi jian zhi , dan shi ru guo zai yi ge ri qi zhong shi yong , shang xia wen jiang zuo wei nian fen bei jie shi cheng '2010-11-12'。 zhi '10:45:15' jiang bei bian huan dao '0000-00-00', yin wei '45' bu shi yi ge he fa de yue fen 。      2、 yi 2 wei shu zi zhi ding de nian zhi shi mo hu de , yin wei shi ji shi wei zhi de 。MySQL shi yong xia lie gui ze jie shi 2 wei nian zhi : zai 00-69 fan wei de nian zhi bei bian huan dao 2000-2069。 zai fan wei 70-99 de nian zhi bei bian huan dao 1970-1999。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
时尚秀气模特裴裴(8)
时尚秀气模特裴裴(7)
时尚秀气模特裴裴(6)
时尚秀气模特裴裴(5)
白墙黑瓦
广州东郊[原创]
八美至丹巴的东谷天然盆景
不一样的
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
 
©2005- 王朝网络 版权所有