hye! i faced some problem regarding to set default value for password column in table student.
i already tried many ways including this one :
ALTER TABLE Student MODIFY Password varchar(50) Default '123456'
But, it gave me incorrect syntax near 'MODIFY' and '50'.
So can you help me fix this syntax?
Thanks in advance. :)
Cannot alter table column default valueelyn October 20, 2011 at 2:42 AM
hye! i faced some problem regarding to set default value for password column in table student. i already tried many ways including this one : ALTER TABLE Student MODIFY Password varchar(50) Default '123456' But, it gave me incorrect syntax near 'MODIFY' and '50'. So can you help me fix this syntax? Thanks in advance. :)
Post your Comment