/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

5 votes285 views1 answer
Oracle nls instance
SQL
0 vote240 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
5 votes288 views1 answer
Oracle list functions
SQL
0 vote284 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote284 views1 answer
Postgres statistics
SQL
2 votes297 views2 answers
How to add not null constraint in sql
SQL
9 votes303 views2 answers
Nosql databases
SQL
0 vote298 views1 answer
Mysql random number between 1 and 100
SQL
16 votes272 views4 answers
Mysql import from sql file
SQL
2 votes266 views1 answer
How to select first row of database sql
SQL