Mysql常用SQL语句

1、MySQL查看表结构

    desc 表名;  
    show columns from 表名;  
    describe 表名;  
    show create table 表名;  
    use information_schema  
    select * from columns where table_name='表名';  

顺便记下查看数据库：

show databases; 

使用某个数据库

use 数据库名;

查看该数据库的数据表

show tables; 

查看存储过程；

show procedure status; 

顺便提下oracle

select * from v$database;  
select * from all_users;  
select * from user_tables;  

2.MySQL插入多条记录

insert into parameters_tbl(created_at, updated_at, deleted_at,deleted, `key`, value, type, `range`, is_public, mutable, description, dynamic) select created_at, updated_at, deleted_at,deleted, `key`, value, type, `range`, is_public, mutable, description, dynamic from parameters_tbl;

3.重命名表

rename table parameters_tbl to parameters_old_tbl;

4. 更新表记录，使用where between子句

update parameters_tbl set flavor = 'RDS::C1_M2' where id between 29 and 50;

转 http://database.51cto.com/art/201005/199576.htm