MYSQL命令列常用操作

顯示資料庫                                       mysql->show databases;
建立資料庫                                       mysql->create database db;
刪除資料庫                                       mysql->drop database db;
選擇資料庫                                       mysql->use db
建立表                                              mysql->create table mytable(name varchar(20),sex(char(1),birth date);
刪除表                                              mysql->drop table mytable;
顯示表的內容                                   mysql->show tables;
顯示表的結構                                   mysql->describe mytable;
在一個表中增加一條欄位                mysql->alter table yourtable add id int not null auto_increment, add primary key (id);
刪除一個欄位                                   mysql->alter table yourtable drop name ;
建立mysql帳戶                                mysql> grant all privileges on *.* to '123123'@'localhost'  -> identified by '123123';
                                                          mysql> GRANT SELECT,UPDATE ON *.* TO 'monty'@'%' (可以網路訪問的賬戶) ->   IDENTIFIED BY '123123';
更改已有帳戶的密碼                        mysql> grant all privileges on *.* to '123123'@'localhost'  -> identified by '123123';  mysql> flush privileges;