anggwaponi Posted February 22, 2008 Share Posted February 22, 2008 hello .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 More sharing options...
justsomeguy Posted February 25, 2008 Share Posted February 25, 2008 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. Link to comment Share on other sites More sharing options...
anggwaponi Posted March 6, 2008 Author Share Posted March 6, 2008 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 statementhi 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.