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 表格處理 | 豬窩
Thanks for sharing your thoughts. I really appreciate your efforts and I am waiting for your further write ups thank you once again.
alter table Sql 表格處理 | 豬窩
Thanks for the auspicious writeup. It actually was a amusement account it.
Look complex to more introduced agreeable from you! By the
way, how can we be in contact?
alter table Sql 表格處理 | 豬窩
Hey there this is kind of of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually
code with HTML. I'm starting a blog soon but have no coding expertise so I wanted to get guidance from someone with
experience. Any help would be enormously appreciated!
alter table Sql 表格處理 | 豬窩
Why users still make use of to read news papers when in this technological globe all is
presented on net?
alter table Sql 表格處理 | 豬窩
Excellent post. Keep writing such kind of information on your blog.
Im really impressed by your site.
Hi there, You have done a fantastic job. I'll certainly digg it and personally suggest to my friends.
I am sure they will be benefited from this site.