alter table Sql 表格處理
第一,我們要加入一個叫做 "Gender" 的欄位。這可以用以下的指令達成:
ALTER TABLE Customer ADD Gender char(1);
接下來,我們要把 "Address" 欄位改名為 "Addr"。這可以用以下的指令達成:
ALTER TABLE Customer CHANGE Address Addr char(50);
再來,我們要將 "Addr" 欄位的資料種類改為 char(30)。這可以用以下的指令達成:
ALTER TABLE Customer MODIFY Addr char(30);
最後,我們要刪除 "Gender" 欄位。這可以用以下的指令達成:
ALTER TABLE Customer DROP Gender;
來自:https://www.1keydata.com/tw/sql/sql-alter-table.html
迴響
alter table Sql 表格處理 | 豬窩
My partner and I stumbled over here different web page and
thought I might check things out. I like what I see so i am just following
you. Look forward to looking at your web page for a second
time.
alter table Sql 表格處理 | 豬窩
Yesterday, while I was at work, my sister stole my iPad and tested to
see if it can survive a 40 foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views.
I know this is completely off topic but I had to share it with
someone!
alter table Sql 表格處理 | 豬窩
Excellent blog you've got here.. It's difficult
to find excellent writing like yours these days. I honestly appreciate people like you!
Take care!!
alter table Sql 表格處理 | 豬窩
Good web site you've got here.. It's hard to find excellent writing like yours nowadays.
I really appreciate individuals like you!
Take care!! adreamoftrains web hosting company
alter table Sql 表格處理 | 豬窩
I was wondering if you ever thought of changing the structure of your site?
Its very well written; I love what youve got to say.
But maybe you could a little more in the way of content
so people could connect with it better. Youve got an awful lot of text for
only having one or 2 images. Maybe you could space it out better?