/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 vote184 views1 answer
Postgresql update to unique
SQL
0 vote210 views1 answer
Get only structure database mysql
SQL
0 vote166 views1 answer
Sqlite3 now
SQL
0 vote180 views1 answer
Select only one row sql
SQL
0 vote179 views1 answer
Heavy table in mysql
SQL
0 vote230 views2 answers
Mysql select date from datetime
SQL
2 votes193 views3 answers
Sql delete duplicate
SQL
0 vote194 views1 answer
Foreign key multiple columns
SQL
2 votes223 views1 answer
Sql string starts with
SQL
0 vote196 views2 answers
Oracle create tablespace autoextend
SQL