网站建设笔记

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-tables

source d:\1.sql
set names utf8
show 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'