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 表格處理 | 豬窩
Hello there! I could have sworn I've been to your blog before but after looking at
some of the posts I realized it's new to me. Anyhow, I'm certainly
happy I came across it and I'll be book-marking it and
checking back often!
alter table Sql 表格處理 | 豬窩
When I originally commented I clicked the "Notify me when new comments are added" checkbox and now
each time a comment is added I get three emails with the same comment.
Is there any way you can remove people from that service?
Thanks a lot!
alter table Sql 表格處理 | 豬窩
Pretty component to content. I just stumbled upon your weblog and
in accession capital to assert that I acquire actually loved account
your blog posts. Any way I will be subscribing on your
feeds or even I success you access consistently quickly.
alter table Sql 表格處理 | 豬窩
Cbd oil that works 2020
Oh my goodness! Impressive article dude! Thank you so much, However I am going
through difficulties with your RSS. I don't know the reason why I am unable to subscribe to it.
Is there anybody having the same RSS problems? Anybody who knows the
solution will you kindly respond? Thanx!! best rated cbd
oil http://t.co/4kPhN7Ek0L cbd oil that works 2020 http://t.co/4kPhN7Ek0L
alter table Sql 表格處理 | 豬窩
What's up i am kavin, its my first occasion to commenting anywhere, when i read this post i thought i could also
create comment due to this good piece of writing.