mysql set default on delete code example
Example 1: how to remove default in mysql
ALTER TABLE "table_name" ALTER COLUMN "name_column" DROP DEFAULT;
Example 2: create table mysql with foreign key
CREATE TABLE Orders (
OrderID int NOT NULL,
OrderNumber int NOT NULL,
PersonID int,
PRIMARY KEY (OrderID),
FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
);