/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

16 votes142 views1 answer
Mysql mediumint max value
SQL
0 vote195 views1 answer
Sql declare variable single line
SQL
0 vote169 views1 answer
Sql log file inof
SQL
2 votes192 views2 answers
Null column to 0 in mysql
SQL
0 vote184 views1 answer
Wordpress make wp user in db
SQL
0 vote138 views1 answer
Add column to table with default value plsql
SQL
0 vote140 views1 answer
Mysql select all table that have field names
SQL
3 votes136 views1 answer
Start mysql server linux terminal
SQL
2 votes114 views1 answer
Latest record in sql
SQL
0 vote148 views1 answer
Basic structure of sql expression having clause
SQL