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'