Jump to content

(my)sql 101


anggwaponi

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...