substring()函数用来截取出生年月日
year(now())- year(substring(borrower_idcard,7,8)) age, 用来计算年龄
SELECT * FROM ( SELECT DATE_FORMAT(substring(t.id_card, 7, 8),"%Y-%m-%d") birthday, YEAR (now()) - YEAR (substring(t.id_card, 7, 8)) age FROM teacher t ) temp
时间戳转字符串：select from_unixtime(time)，time单位是秒。或者select from_unixtime(time,format)，time单位是秒。select ...
1、修改my.cnf（linux）/my.ini（Windows）文件，在[mysqld]下面加上skip-grant-tables配置选项；2、重启mysql服务；linux一般为：service...
欣达CMS在安装过程中，出现以下错误提示：SQLSTATE[42000]: Syntax error or access violation:&nbs...
打开MySQL配置文件，Win下面默认是my.ini，Linux下面默认是my.conf[mysqld]下面加入（如果有则修改）：default-storage-engine = ...
