Seven的博客

mysql中已经有了datetime，date，timestamp等时间格式，为什么要选择用int来表示时间呢？ 1.用int来表示时间更快 2.用int就是timestamp（时间戳）格式 之间可以进行转化 DATETIME -> Timestamp: UNIX_TIMESTAMP(…) Timestamp -> DATETIME: FROM_UNIXTIME(…) 使用php和mys

1.首先安装mysqlsudo apt-get install mysql-server mysql-client2.安装apache2sudo apt-get install apache23.安装php7sudo apt-get install php74 安装apache2 php7 modulesudo apt-get install libapache2-mo

SELECT * FROM ( SELECT borrower_idcard idcard, substring(borrower_idcard,7,8) birth, year(now())- year(substring(borrower_idcard,7,8)) age, borrower_name NAME FROM jr_finance_business_info