> 아. varchar[50]을
>
> varchar[70]
>
> 으로 바꾸려 합니다.
>
> alter table board1 title varchar[70];
>
> 이라고 치니. 에러가나염..
>
> alter table board1 modify title varchar[70];
>
> 이거 아닌가염?
제목 그대롭니다. 그정도는 직접 찾아볼수 있는것 아닌가요?
7.8 ALTER TABLE syntax
ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]
alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
or ADD [COLUMN] (create_definition, create_definition,...)
or ADD INDEX [index_name] (index_col_name,...)
or ADD PRIMARY KEY (index_col_name,...)
or ADD UNIQUE [index_name] (index_col_name,...)
or ADD FULLTEXT [index_name] (index_col_name,...)
or ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
or CHANGE [COLUMN] old_col_name create_definition
or MODIFY [COLUMN] create_definition
or DROP [COLUMN] col_name
or DROP PRIMARY KEY
or DROP INDEX index_name
or RENAME [TO] new_tbl_name
or table_options
|