Sign in to follow this  
MrPoopypants

[web] mysql

Recommended Posts

Hello, I just got mysql and have been fooling around with it for a while trying to figure it out. I couldn't figure out how modify the columns themselves (for example, how do you delete a table, remove/add a data-column, etc... ?). I couldn't find any information pertaining to this in the reference manual.. Any help would be great... thanks

Share this post


Link to post
Share on other sites
What you're looking for, is the ALTER TABLE and DROP TABLE statements.

ALTER TABLE can perform almost any modification to a table's structure. DROP TABLE, gets rid of the table entirely.

For reasons lost in the mists of time, removing an object in SQL is always referred to as dropping it.

So there is DROP TABLE, DROP DATABASE, DROP INDEX etc

Mark

Share this post


Link to post
Share on other sites
thanks,

I also have another question though.


For those of you who use ColdFusion:
How do i add a myaql datasource in the coldfusion administrator? What is the difference between the database name and the datasource name? I assume i just put my IP address in the "server" textbox (since i'm running it through localhost). Thanks

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this