![]() You can view long-running jobs with SHOW JOBS. ![]() This schema change statement is registered as a job. ![]() Adding/changing the table's PRIMARY KEY is not supported through ALTER TABLE it can only be specified during table creation. Adding/changing a DEFAULT constraint is done through ALTER COLUMN. The CHECK, foreign key, UNIQUE constraint you want to add. The name of the constraint, which must be unique to its table and follow these identifier rules. The name of the table containing the column you want to constrain. The user must have the CREATE privilege on the table. ALTER TABLE IF EXISTS table_name ADD CONSTRAINT constraint_name constraint_elem opt_validate_behavior Required privileges
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |