--SQLï¼
CREATE TABLE test(
i_a int NOT NULL DEFAULT 1,
ts_b timestamp NOT NULL DEFAULT NOW(),
c_c char(2) NOT NULL DEFAULT '1'
);
--以ä¸SQLä¸åæ³
--time_d time NOT NULL DEFAULT CURTIME(),
--date_e date NOT NULL DEFAULT CURDATE(),
--datetime_f datetime NOT NULL DEFAULT NOW(),
æ»ç»
intç±»åï¼é»è®¤å¼ä¹å¾æ¯æ´åï¼å¹¶ä¸defaultåè¾¹ä¸è¦()æ¬å·ã
charç±»åï¼é»è®¤å¼ä½¿ç¨åå¼å·ã
DATETIMEç±»åï¼NOW()å½æ°ä»¥'YYYY-MM-DD
HH:MM:SS'è¿åå½åçæ¥ææ¶é´ï¼å¯ä»¥ç´æ¥åå°DATETIMEå段ä¸ãä¸æ¯æ使ç¨ç³»ç»é»è®¤å¼ã
DATEç±»åï¼CURDATE()以'YYYY-MM-DD'çæ ¼å¼è¿åä»å¤©çæ¥æï¼å¯ä»¥ç´æ¥åå°DATEå段ä¸ãä¸æ¯æ使ç¨ç³»ç»é»è®¤å¼ã
TIMEç±»åï¼CURTIME()以'HH:MM:SS'çæ ¼å¼è¿åå½åçæ¶é´ï¼å¯ä»¥ç´æ¥åå°TIMEå段ä¸ãä¸æ¯æ使ç¨ç³»ç»é»è®¤å¼ã
åèèµæ
mysql表å段é»è®¤å¼
ç¨sqlè¯å¥å建表æ¶ï¼ç»è¡¨å段é»è®¤å¼åºéã
æ¯å¦ï¼mssqlä¸
CREATE TABLE dnt_forums(
aa int NOT NULL DEFAULT (''),
bb date NOT NULL DEFAULT (getdate()),
cc char(50) NOT NULL DEFAULT (null)
}
请é®ä¸è¿°çsqlè¯å¥è¦å¦ä½ä¿®æ¹å¨mysqlä¸æè½ä½¿ç¨
aa æ¯ int ç±»åï¼é»è®¤å¼ä¹å¾æ¯æ´åï¼å¹¶ä¸defaultåè¾¹ä¸è¦ï¼ï¼æ¬å·
bb dateç±»åä¸æ¯æ使ç¨ç³»ç»é»è®¤å¼ï¼æ¹ætimestampï¼è½è¿now()åç³»ç»æ¶é´
cc å·²ç»ä¸å
许为空ï¼not nullï¼æ以ä¸è½é»è®¤ä¸º null ï¼å¯ä»¥æ¹æ空å符串
CREATE TABLE dnt_forums(
aa int NOT NULL DEFAULT 2,
bb timestamp NOT NULL DEFAULT now(),
cc char(50) NOT NULL DEFAULT ''
);
温馨提示:答案为网友推荐,仅供参考