/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 vote204 views1 answer
Sql offfset
SQL
0 vote215 views2 answers
How to start postgresql laravel
SQL
18 votes232 views3 answers
Get the list of all tables in sql server
SQL
-1 vote213 views1 answer
Io
SQL
0 vote202 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote225 views1 answer
Select all columns except one sql
SQL
1 vote162 views1 answer
Convert money to varchar sql server
SQL
0 vote247 views1 answer
How to fetch data from database in sql
SQL
3 votes245 views5 answers
Sql select
SQL
3 votes208 views1 answer
Oracle failed login attempts
SQL