Jump to content

(my)sql 101


anggwaponi
 Share

Recommended Posts

sql1.jpgsql-1.jpghello :) .filename of these documents is my_sql_data_files.i'm starting to learn basic (my)sql programs. i would like to ask a help or assistance regarding my lesson(s).please advise what sort of command(s) or syntax if ever i'm going to add the column location?i'm trying to used the following syntax or command but i got this error or message. what is probably is missing or wrong in the way i manipulated it? alter table my_sql_data_files add (location, null);i appreciate very much if anyone can help me.thanks.
Link to comment
Share on other sites

  • 2 weeks later...
What error message did you get? You'll need to give the new column a data type, you're not doing that (or, null is not a valid data type). Check the documentation for the ALTER TABLE statement
hi again justsomeguy :) .i have fixed or make some updates about these inquiry of mine. on the other hand, i posted another problem. hoping u or anyone can again assist me.cheers!
Link to comment
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
 Share

×
×
  • Create New...