/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 votes288 views2 answers
Sql strip non alphanumeric characters
SQL
1 vote243 views1 answer
Mssql string length
SQL
8 votes290 views2 answers
Select table column name in sql
SQL
1 vote277 views2 answers
Populate sql table with random data
SQL
15 votes295 views7 answers
MYSQL
SQL
0 vote242 views1 answer
Mysql find foreign key references
SQL
1 vote316 views1 answer
T-sql disable system versioning
SQL
0 vote268 views2 answers
Mysql slave status
SQL
3 votes309 views4 answers
Ubuntu stop mysql
SQL
0 vote274 views1 answer
Can we rollback deleted data in sql
SQL