1. 테이블에 새로운 컬럼 추가
alter table tablename add column [추가할 컬럼명] [추가할 컬럼 데이타형]
2. 테이블에 컬럼타입 변경하기
alter table tablename modify column [변경할 컬럼명] [변경할 컬럼 타입]
3. 테이블에 컬럼이름 변경하기
alter table tablename change column [기존 컬럼명] [변경할 컬럼명] [변경할 컬럼타입]
4. 테이블에 컬럼 삭제하기
alter table tablename drop column [삭제할 컬럼명]
5. 테이블컬럼에 인덱스 주기
alter table tablename add index 인덱스명(인덱스를 줄 컬럼1 , 인덱스를 줄 컬럼2, ... )
6. 테이블컬럼에 인덱스 삭제하기
alter table tablename drop index 인덱스명;
7. 테이블에 Primary Key 만들기
alter table tablename add primary key (키를 줄 컬럼명1 , 키를 줄 컬럼명2, ...)
8. 테이블에 Primary Key 삭제하기
alter table tablename drop primary key;
9. 테이블명 바꾸기
alter table 기존테이블명 rename 새로운테이블명
10. 인덱스 생성
CREATE [UNIQUE] INDEX index_name ON tbl_name (col_name[(length]),... )
11. 인덱스 삭제
DROP INDEX index_name
Wonderful blog! I truly love how it? s easy on my eyes as well as the data are well written. I am wondering how I can be notified whenever a new post has been made. I have subscribed to your rss feed which need to do the trick! Have a nice day!
I love the expression. Everyone needs to express there own opinion and feel free to hear others. Keep it up :)
Hey how are you doing? I just wanted to stop by and say that it's been a pleasure reading your blog. I have bookmarked your website so that I can come back & read more in the future as well. plz do keep up the quality writing
good,i like it
good,i like it
Resources such as the one you mentioned here will be incredibly helpful to myself! I will publish a hyperlink to this page on my personal blog. I am sure my site visitors will find that quite beneficial.
what's up, noble blog on oleagino us loss. aforesaid helped.
well done!nice job!
I commonly don’t reply on sites nevertheless you boast a few superior comprehensible article.
That makes sense to me but does this?
Unix is user friendly – it’s just picky about it’s friends.
Took me moment to think about all of the comments, however I in truth loved the piece of writing. It proved being in truth ready to lend a hand to me plus I am constructive to every the commenters here! It’s in the main pleasant when you can not just be informed, but in addition entertained! I am optimistic you had satisfying writing this write-up.
Can I just speak what a release toward locate a name who in fact understands what theyre discussion regarding on top of the world wide web. You certainly make out how to bring an issue to light plus create it significant. Additional public must to study this and recognize this side of the story. I cant believe youre not more fashionable since you absolutely have the gift.
I am joyful to discover so various constructive information here inside the article, we need extend extra techniques inside this regard, thanks for sharing
I am not truly sure if greatest practices have emerged about stuff similar to that, other than I am confident that your large job is obviously recognized. I was thinking if you offer one subscription to your RSS feeds since I would be extremely interested.
I like this data shown and it has given me some sort of desire to have success for some reason, so thank you.
I typically don’t reply lying on websites except you boast some high-quality readable material.
Hey, i think you visited my website so i came to "return the favour".I am looking for ways to add things to my website!I suppose its ok to use some of your ideas!!
You made a number of nice points there. I did a search on the subject and found a good number of persons will agree with your blog. Hot kaieteur news. Thank's for you recommend.
You completed certain fine points there. I did a search on the topic and found the majority of folks will have the same opinion with your blog.
Hello buddy, your blog’s design and style is easy and clean and i like it. Your blog page posts are outstanding. Please maintain them coming. Greets!!!
You actually make it seem so easy with your presentation but I find this topic to be actually something which I think I would never understand. It seems too complicated and very broad for me. I'm looking forward for your next post, I’ll try to get the hang of it!
Jeez, it's unusual to find such a great posting
hey there, I haven't so much spoke to you on the msn in a while, but I guessed I might message you from my cutting edge Netbook!! No fun, I work for a hot company now in the revision dept. Do not tell anybody but we discovered this site that is entirely glitching and providing out totally free Android !! to everybody that signs up. I presume you would probably have to confirm your e-mail, Sincerely sexcam live
Oh gosh, I disagree, but, nonetheless, it's an interesting experience, RRS subscribed!
I personally suggest Hostgator for webhosting. They are truly professional, support staff is perfect and uptime nice. Go to hostgator_dot_com and use "onecentcoupons" voucher code. You get first month just free which is great.
OMG! It is like you understand my mind! You seem to know a lot about this, like you wrote the book in it or something. I think that you could do with some pictures to drive the message home a bit, but other than that, this is good blog post. A wonderful read. I'll definitely return again.
Jeez, it's unusual to find such a great posting
Nice blog here! Also your web site loads up very fast! What host are you using? Can I get your affiliate link to your host? I wish my website loaded up as quickly as yours lol
Excellent blog here! Also your web site loads up very fast! What web host are you using? Can I get your affiliate link to your host? I wish my website loaded up as fast as yours lol
We're a group of volunteers and starting a new scheme in our community. Your web site offered us with valuable info to work on. You have done a formidable job and our whole community will be thankful to you.
Very good article! This is very interesting! Thanks for this blog! You can find more informations on Lingerie de charme. There's everything you need at the best price!
This really answered my drawback, thanks!
Hi, i think that i saw you visited my web site so i came to “return the favor”.I'm attempting to find things to enhance my website!I suppose its ok to use a few of your ideas!!
I have recently started a website, the information you offer on this site has helped me greatly. Thank you for all of your time & work.
Wonderful goods from you, man. I've understand your stuff previous to and you are just too fantastic. I really like what you've acquired here, really like what you are saying and the way in which you say it. You make it enjoyable and you still take care of to keep it smart. I can't wait to read much more from you. This is really a terrific web site.
I'm really impressed with your writing skills and also with the layout on your weblog. Is this a paid theme or did you modify it yourself? Either way keep up the excellent quality writing, it is rare to see a nice blog like this one these days..
I kinda like this blog. For a while, I've been trying to create one one thing like this as well, however I am not computer gifted on easy methods to do it.I kinda like this blog. For some time, I have been trying to create one something like this as effectively, nevertheless I'm not computer gifted on find out how to do it.
Nice weblog and I love what you have to say and I think I will tweet this out to my pals so they can test it out as well. I like what it's important to say. great put up and I utterly agree with you on all points and I am fascinated by including a hyperlink on my blog to your blog publish as a result of its that good.
We've read several blogs on the web site given that yesterday, and I genuinely much like your design of blogging. My partner and i saved the idea for you to my favorite features site checklist and will also be examining back shortly. Kindly visit my web site in addition and also make me aware the viewpoint.
that the World Economic Forum's first report on Global Information Technology came out, Friedman
redicted by looking at the data about the rapid pace of technological development in the region.
WONDERFUL Post.thanks for share..more wait .. …
We are a group of volunteers and starting a new scheme in our community. Your site provided us with valuable info to work on. You've done an impressive job and our whole community will be thankful to you.
I just learned about your internet site a few days ago and I have been checking it out regularly. You have a wide range of good informative stuff on the site and i also really like the kind of your website at the same time. Keep up the great work!
Hi! I found your blog on AOL.It’s really comprehensive and it helped me a lot. Continue the good work!
Howdy there, are you having problems with the web hosting? I had to refresh the page about million times to be able to get the web page to load
Just to tell you, I do think there is a trouble with your RSS, it isn’t showing right in my Feed viewer. It just began occurring a few days ago, did you alter some thing on the blog?
We are a group of volunteers and starting a new scheme in our community. Your site provided us with valuable information to work on.You have done an impressive job!
Hello I ran beyond this abounding website while analytic abounding altered techniques abbreviation weight, I’ve got to acquaint you your internet website is actual advantageous and i accede the design. We wont acquire a actual baiter amount of activity in adjustment to appraise your absolute blogposts about Concerning book apparent it too seeing that autonomous in for the Rss or atom rss feeds. I shall be aback a few months. acclaim for any accomplished web page.
I want to thankx for the efforts you have made in writing this blog. I am hoping the same high-grade blog post from you in the upcoming as well. In fact your creative writing skill has inspired me to get my own blog now. Really the blogging is spreading its wings rapidly. Your write up is a good example of it.