/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 vote207 views1 answer
Primary key start from number
SQL
0 vote215 views1 answer
Add new column in sql with foreign key
SQL
0 vote192 views1 answer
Display first three characters sql
SQL
1 vote171 views1 answer
Error code 1055
SQL
4 votes179 views2 answers
Oracle last day of month
SQL
4 votes187 views1 answer
Data types in sql
SQL
1 vote200 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote155 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote187 views1 answer
Postgresql not in alternative
SQL
3 votes248 views2 answers
How to open postgresql in windows
SQL