/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

2 votes343 views2 answers
Postgres trigger insert into another table
SQL
0 vote329 views2 answers
Jsonb
SQL
8 votes340 views1 answer
Racle create auto increment column
SQL
0 vote338 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
4 votes330 views2 answers
Mysql alter table set column unique
SQL
0 vote342 views1 answer
Oracle locked objects
SQL
1 vote324 views2 answers
Mysql select tables with name like
SQL
3 votes332 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
9 votes351 views4 answers
Mysql set id auto increment
SQL
4 votes311 views3 answers
Count with where
SQL