/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 vote193 views2 answers
Plsql function that return a table
SQL
0 vote217 views1 answer
Sql sum if
SQL
0 vote190 views1 answer
Compare if is null sql
SQL
0 vote180 views1 answer
How to update random rows in sql
SQL
0 vote186 views1 answer
Sql get table last modified time
SQL
18 votes185 views3 answers
Mysql query add column with default string value
SQL
1 vote198 views3 answers
Postgresql connect to database
SQL
12 votes185 views2 answers
Delete all data in neo4j
SQL
3 votes188 views1 answer
Oracle list invalid password ORA-01017
SQL
5 votes242 views1 answer
Oracle ora-00054 find
SQL