mysql-alter

mysql-alert, mysql-utf8
A

alter table PURCHASE_HEADER_BAK MODIFY COLUMN TIMESTAMP timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

alter table SALES_ORDER_HEAD ADD PRIMARY KEY(RECORDID);

alter table SUPPLIER_INVOICE_HEADER alter  INV_DATE set DEFAULT '1753/01/01';


ALTER TABLE tbl_name AUTO_INCREMENT = N to reset the AUTO_INCREMENT value

alter table ITEM  alter comment set DEFAULT '';

alter table companyProfile modify calcmode char(10)  ## change column width

alert table ir56b modify nameinchinese nchar(50); ## change column unicode

alter table holiday change recoridid recordid numeric(10);  ## change column name

ALTER TABLE SALES_HEADER ALTER PCARD_SUBMITTED_TIME SET DEFAULT '00:00';

alter table PURCHASE_HEADER MODIFY COLUMN REMARK MEDIUMTEXT;

alter table companyProfile add column inclusiveDate date; ## add column date



ALTER TABLE employee CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

alter table ir56b add column status char(1); ## add column char(1)
alter table CUSTOMER ADD COLUMN COMMENT MEDIUMTEXT default'';


ALTER DATABASE hr charset=utf8;  ## alter database

alter table tablename  modify column RECORDID int(4) auto_increment not null primary key;

alter table PURCHASE_HEADER_BAK MODIFY COLUMN TIMESTAMP timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

alter table ir56b drop foreign key employee2ir56b;

d
d