/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

0 vote339 views1 answer
Is numeric in sql
SQL
-3 votes338 views1 answer
Remove spaces sql 2008
SQL
0 vote389 views1 answer
How to move a columns location in mysql
SQL
7 votes334 views4 answers
How to reset the identity column in sql server
SQL
0 vote356 views1 answer
Sql server manager close connection
SQL
9 votes359 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote344 views1 answer
Mysql begin statement
SQL
2 votes434 views3 answers
Mysql unix timestamp to date
SQL
6 votes352 views1 answer
Update left join mysql
SQL
1 vote398 views2 answers
Maximum number of tables in mysql
SQL