MYSQL  备忘录
	
    
    
	MySQL client programs: 
mysql 
The command-line tool for interactively entering SQL statements or executing them from a file in batch mode. See Section 4.5.1, “mysql — The MySQL Command-Line Tool”. 
mysqladmin 
A client that performs administrative operations, such as creating or dropping databases, reloading the grant tables, flushing tables to disk, and reopening log files. mysqladmin can also be used to retrieve version, process, and status information from the server. See Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”. 
mysqlcheck 
A table-maintenance client that checks, repairs, analyzes, and optimizes tables. See Section 4.5.3, “mysqlcheck — A Table Maintenance and Repair Program”. 
mysqldump 
A client that dumps a MySQL database into a file as SQL, text, or XML. See Section 4.5.4, “mysqldump — A Database Backup Program”. 
mysqlimport 
A client that imports text files into their respective tables using LOAD DATA INFILE. See Section 4.5.5, “mysqlimport — A Data Import Program”. 
mysqlshow 
A client that displays information about databases, tables, columns, and indexes. See Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”. 
mysqlslap 
A client that is designed to emulate client load for a MySQL server and report the timing of each stage. It works as if multiple clients are accessing the server. See Section 4.5.7, “mysqlslap — Load Emulation Client”. 
    
     
	
	
    
    
	相关文档:
        
    
    Transact_SQL小手册 
*******************Transact_SQL********************
--语 句                                功 能
--数据操作
SELECT & ......
	
    
        
    
    今天到mysql网站看看发现没有了sun LOGO,也找不到mysql downloads下载链接
要手工打入http://dev.mysql.com才行,不禁闪过一丝凉意,以前坚持使用mysql现在还要坚持吗,
以前心里一直在想一直会使用mysql的,但是现在感觉到很失望,挫折,焦虑,不知以后会怎么样
自己几年来一直使用LAMP组合,知识都是是围绕着这个组合 ......
	
    
        
    
    最近了解了一下MYSQL注入,也实际操作了一下,确实发现了他的威力。
一个注入漏洞可以让人直接拿到服务器权限。
总结一下:
1,目录的权限不能太高,不然别人能往里写文件,以前用0777真是太愚蠢了。
2,严格过滤数据,整形一律转int或用mysql_escape_string
3,设置合理的数据库权限,不要用ROOT,不然会死得很惨。
4 ......
	
    
        
    
    http://www.3d308.cn/article.asp?id=37
shell> mysql -u root mysql
mysql> Update user SET Password=PASSWORD('new_password')
           Where user='root';
mysql> FLUSH PRIVILEGES;
 ......
	
    
        
    
    项目从mysql迁移到ORACLE中遇到移植问题,mysql中支持limit 而ORACLE say no .
解决方法 利用ORACLE的伪列 rownum来控制。。
Mysql : select * from table limit 10
equl
ORACLE: select * from table where rownum <= 10
ORACLE 伪列介绍:
随数据字典一起自动创建的一个表,属于sys模式,任何用户都可以访问,&nbs ......