Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

create table mysql

CREATE TABLE IF NOT EXISTS tasks (
    task_id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    start_date DATE,
    due_date DATE,
    status TINYINT NOT NULL,
    priority TINYINT NOT NULL,
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)  ENGINE=INNODB;
Source by www.tutorialspoint.com #
 
PREVIOUS NEXT
Tagged: #create #table #mysql
ADD COMMENT
Topic
Name
4+8 =