HomeTable Creation and Data Manipulation Commands Modify table Empl, add another column called Grade of VARCHAR type, size 1 into it. 10 Comments Facebook Twitter Q. Modify table Empl, add another column called Grade of VARCHAR type, size 1 into it. Table -- Answer = Alter table Empl add column grade varchar(1) ;
Shouldn't it be varchar type?
ReplyDeleteYeah,it should be
ReplyDeleteYes.
Deletechar(1) as mention in que i.e. Grade of VARCHAR type, size 1 into it.
ReplyDeleteChar() and Varchar() are different.
DeleteALTER table empl ADD(grade VARCHAR(1));
ReplyDeleteIS THIS WRONG?
When I am trying to do the same, it displays an error for me
Deleteyou missed the term column after 'add' hope this helps!
ReplyDeleteYes.
DeleteIt should not use 'column '
ReplyDeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )