but6565的博客

"D:\tools\MYSQL\mysql-5.1.57-win32\bin\mysql.exe" -u root -padmin --default-character-set=utf8 tmall_ssm < d:\tmall_ssm.sql

1.在D:\Application\plsql\instantclient_12_1目录下新建一个Network文件夹，在Network里面新建一个Admin文件夹，然后在Admin文件夹下放置tnsnamer.ora。2.打开plsql的客户端，点击tools，点击preferences，在OCI library中放入D:\Application\plsql\instantclient_12...

select weekofyear(to_date(from_unixtime(unix_timestamp(substr('20170603',1,8),'yyyymmdd'),'yyyy-mm-dd')));