随笔分类 - SQL

mysql数据导入导出语句

摘要：导出:SELECT * from ebook INTO OUTFILE "bookdev.txt" FIELDS ENCLOSED by '"' TERMINATED by "," LINES TERMINATED BY "\n"导入:LOAD DATA INFILE "bookdev.txt"... 阅读全文

posted @ 2005-04-14 15:49 似水流年阅读(966) 评论(0) 推荐(0)

用MYSQL中的加密函数来加密：PASSWORD（）

摘要：加密： insert into user values("","${param.userName}",password("${param.userPwd}"),"${param.userLevel}") 解密： select * from user where userName='${param.userName}' and userPwd=password('${param.us... 阅读全文

posted @ 2005-03-16 10:16 似水流年阅读(639) 评论(0) 推荐(0)