duanba2001 2013-09-10 13:13
浏览 55
已采纳

添加产品到数据库时添加日期/时间

I have tried to Google this so I didn't have to ask, as i'm sure this is a simple task...

I am building an E-commerce site and would like to add the date and time a product is added into the product database?

Apologies if this is simple, but i have researched everywhere else first.

Thanks

  • 写回答

2条回答 默认 最新

  • doushi4633 2013-09-10 13:23
    关注

    This can just be part of your database architecture:

    ALTER TABLE  `products` ADD  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
    

    This will automatically add a timestamp to the column created whenever a row is created. For more information, try this: Automatic Initialization and Updating for TIMESTAMP

    Obviously, in this case the table is called products and you would need to change it to whatever your table name is.

    UPDATE To update all existing records at the same time, just run:

    UPDATE `products` SET `created` = NOW()
    

    If you want to be more specific use:

    UPDATE `products` SET `created` = NOW() WHERE `created` = '0000-00-00 00:00:00'
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 如何证明高斯噪声的包络公式
  • ¥150 寻找王者荣耀开发作者,合作或者解答
  • ¥15 乳腺癌数据集 相关矩阵 特征选择
  • ¥15 我的游戏账号被盗取,请问我该怎么做
  • ¥15 通关usb3.0.push文件,导致usb频繁断连
  • ¥15 有没有能解决微信公众号,只能实时拍照,没有选择相册上传功能,我不懂任何技术,,有没有给我发个软件就能搞定的方法
  • ¥15 Pythontxt文本可视化
  • ¥15 如何基于Ryu环境下使用scapy包进行数据包构造
  • ¥15 springboot国际化
  • ¥15 搭建QEMU环境运行OP-TEE出现错误