/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

1 vote131 views1 answer
Psql connect to another database
SQL
1 vote123 views1 answer
Oracle user last connection date
SQL
0 vote113 views1 answer
Array aggre distinct postgres
SQL
2 votes125 views1 answer
How to get non distinct values in sql
SQL
0 vote144 views2 answers
How to take recent row without limit in mysql
SQL
1 vote123 views1 answer
Search for replace in mysql
SQL
0 vote67 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote128 views1 answer
Group by max date
SQL
2 votes140 views1 answer
Oracle kill session by sql_id
SQL
1 vote124 views1 answer
Table valued functions in sql
SQL