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 表格處理 | 豬窩
I would like to thank you for the efforts you have put in writing this blog.
I'm hoping to view the same high-grade content from you in the future as well.
In fact, your creative writing abilities has encouraged me to get
my very own blog now ;)
alter table Sql 表格處理 | 豬窩
hi!,I love your writing so a lot! share we keep in touch extra
about your post on AOL? I need a specialist in this area
to solve my problem. May be that is you! Having a look
forward to peer you.
alter table Sql 表格處理 | 豬窩
I think that is one of the so much significant information for me.
And i'm glad studying your article. But wanna commentary on few normal
issues, The website style is wonderful, the articles is really great : D.
Excellent task, cheers
alter table Sql 表格處理 | 豬窩
I think this is among the most significant information for me.
And i'm glad reading your article. But should
remark on few general things, The site style is perfect, the
articles is really great : D. Good job, cheers
alter table Sql 表格處理 | 豬窩
My brother recommended I might like this web site.
He used to be entirely right. This publish actually made my
day. You cann't believe just how much time I had spent for this information! Thank you!