學習簡單資料庫表操作（Mysql）2

標籤：分享   bsp   操作   change   not   asc   birt   ble   lte   

 以orcl執行個體下，person表為例：

1.登入mysql：

mysql安裝路徑下，bin目錄，開啟命令視窗，輸入mysql -u使用者名稱 -p密碼;

2.顯示所有執行個體，show databases;

3.進入orcl執行個體，use orcl;

 

4.顯示person表欄位資訊，desc person;

5.修改欄位描述，alter table person change pid PID int(11) not null;

6.修改表名，alter table person rename to people;

 

7.查，select *from person;

8.增，insert into person(name,age,birthday,salary) values(‘Ming‘,11,‘1999-01-01‘,1000);

9.改，update person set name = ‘XiaoLi‘ where pid = 11;

10.刪，delete from person where pid = 10;

 

11.數，select count(1), age from person group by age;

12.排序，select name,salary from person order by salary asc;

 

select name,salary from person order by salary desc;

 

學習簡單資料庫表操作（Mysql）2