/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

13 votes290 views4 answers
Mysql remove foreign key constraint
SQL
0 vote277 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote251 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote296 views2 answers
Impala rename column name
SQL
0 vote282 views1 answer
How to check database engine in mysql
SQL
0 vote266 views1 answer
Sql values not in another table
SQL
0 vote273 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
1 vote272 views1 answer
Mysql check string don't have number
SQL
0 vote279 views1 answer
Openquery update linked server
SQL
0 vote284 views1 answer
Load data infile mariadb slow
SQL