/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 vote125 views1 answer
How to get inserted id in sql server
SQL
8 votes116 views1 answer
How to remove tables from postgresql
SQL
51 votes223 views6 answers
Change column name sql
SQL
1 vote149 views1 answer
How to select random rows from a table
SQL
1 vote344 views1 answer
How to make a select in sql
SQL
-1 vote138 views1 answer
Adding a new table psql
SQL
0 vote89 views1 answer
Expose db in virtualbox
SQL
0 vote118 views1 answer
Oracle activate program
SQL
0 vote124 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote140 views1 answer
Sql server create constraint
SQL