dongmelon的博客

SET NAMES UTF8; #这个在脚本最上面就要有DROP DATABASE IF EXISTS CD;CREATE DATABASE CD CHARSET=UTF8;USE CD;CREATE TABLE student(sid INT PRIMARY KEY AUTO_INCREMENT,stuName varchar(20),score FLOAT(4,1) #例如999...

SELECT now();    //执行mysql函数用selectselect DATE_ADD(FROM_UNIXTIME(create_time/1000,'%Y-%m-%d %h:%i:%s'),INTERVAL 0 HOUR),`hash`,order_no  from tb_transaction where create_time>=UNIX_TIMESTAMP('201...