Revision [2183]
Last edited on 2009-02-02 21:27:47 by WikiAdminAdditions:
==Add foreign key constraint==
ALTER TABLE vsusers ADD FOREIGN KEY (sitenum)
ALTER TABLE vsusers ADD FOREIGN KEY (sitenum)
Deletions:
ALTER TABLE htaccess ADD FOREIGN KEY (sitenum)
Revision [2182]
Edited on 2009-02-02 21:27:33 by WikiAdminAdditions:
==-Add foreign key constraint==
ALTER TABLE htaccess ADD FOREIGN KEY (sitenum)
REFERENCES vsites (sitenum)
ON UPDATE CASCADE ON DELETE RESTRICT;
ALTER TABLE htaccess ADD FOREIGN KEY (sitenum)
REFERENCES vsites (sitenum)
ON UPDATE CASCADE ON DELETE RESTRICT;
Revision [1570]
Edited on 2008-03-27 01:47:26 by WikiAdminAdditions:
alter table XXX change COLNAME COLNAME varchar(50) not null;
Deletions:
Revision [1569]
Edited on 2008-03-27 01:47:03 by WikiAdminAdditions:
{{parent page="MySQL"}}
==Change a column's definition==
%%(sql)
alter table XXX change password password varchar(50)
%%
==Change a column's definition==
%%(sql)
alter table XXX change password password varchar(50)
%%
