/SQL/Create table mysql integer NOT null

Create table mysql integer NOT null

Set column to not null mysql

ALTER TABLE Person MODIFY P_Id INT(11) NOT NULL;

Source: stackoverflow.com

Create table mysql integer NOT null

CREATE TABLE IF NOT EXISTS checklists (
    todo_id INT AUTO_INCREMENT,
    task_id INT,
    todo VARCHAR(255) NOT NULL,
    is_completed BOOLEAN NOT NULL DEFAULT FALSE,
    PRIMARY KEY (todo_id , task_id),
    FOREIGN KEY (task_id)
        REFERENCES tasks (task_id)
        ON UPDATE RESTRICT ON DELETE CASCADE
);
Code language: SQL (Structured Query Language) (sql)

Source: mysqltutorial.org

Similar codes

12 votes195 views1 answer
How to change the value of a table in sql
SQL
0 vote287 views1 answer
Contraint default SQL
SQL
5 votes180 views1 answer
Mysql get last day of month
SQL
-1 vote227 views1 answer
Create view in mysql workbench
SQL
0 vote190 views1 answer
We are intrested to work with your organization
SQL
3 votes217 views1 answer
What is having
SQL
3 votes199 views1 answer
Sql replace character in string in all records
SQL
-1 vote257 views4 answers
Full outer join in sql
SQL
16 votes213 views1 answer
Mssql int max value
SQL
0 vote193 views1 answer
T sql return on letters only
SQL