网站建设札记

网站建设笔记

select content_id,'''' || txt || '''' as txt,'''' || txt1 || '''' as txt1,'''' || txt2 || '''' as txt2,'''' || txt3 || '''' as txt3 from jc_content_txt;

<Context path="" docBase="E:\suntak\Web"        debug="0" privileged="true" reloadable="true">     </Context>

D:\MySQL\Data\my.ini[mysqld]skip-grant-tablessource d:\1.sqlset names utf8show variables like 'character%'

public static void main(String[] args) {String d = "D:/MySQL";File f = new File(d);File[] files = f.listFiles();for (File file : files) {if (file.isFile() && file.getName().endsWith(".sql")) {System.out.println("source " + file.getName());System.out.println(file.getName().substring(0, file.getName().lastIndexOf(".sql")));}}}

to_date\('\w{2}-\w{2}-\w{4}\s\w{2}:\w{2}:\w{2}',\s'dd-mm-yyyy hh24:mi:ss'\)匹配'2011-01-03 21:37:38'