mysql alter

mysql修改表结构alter2008-10-28 01:50ALTER [IGNORE] TABLE tbl_name alter_spec [,
      alter_spec ...]
      alter_specification:
              ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
      or    ADD INDEX [index_name] (index_col_name,...)
      or    ADD PRIMARY KEY (index_col_name,...)
      or    ADD UNIQUE [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 [AS] new_tbl_name
      or    table_options

 

alter table tables modify goodsBatch varchar(80) not null Default '';--修改字段
ALTER TABLE tables drop key  baseID;---去除約束鍵

ALTER TABLE inventoryBase_items add unique baseID(baseId,warehouseCode,goodsBatch);

--添加約束鍵

 

-- add primary key
alter table users add constraints users_id_pk primary key(id);

-- add foreign key
alter table user_infos add constraints user_info_id_fk foreign key(id) refencese users(id);

-- add sequence
drop sequence my_key;
create sequence my_key

TRUNCATE 清除数据