xxxxxxxxxx
CREATE TABLE IF NOT EXISTS `user_profiles` (
`id` int(11) NOT NULL,
`loginid` varchar(10) NOT NULL,
`fullname` varchar(255) NOT NULL,
`phone` varchar(15) NOT NULL,
`email` varchar(50) NOT NULL,
`res_data` text NOT NULL,
`date_on` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
xxxxxxxxxx
create table tutorials_tbl(
tutorial_id INT NOT NULL AUTO_INCREMENT,
tutorial_title VARCHAR(100) NOT NULL,
tutorial_author VARCHAR(40) NOT NULL,
submission_date DATE,
student_name VARCHAR (255),
sex varchar (6),
contact int (10)
PRIMARY KEY ( tutorial_id )
);
create table mysql query
xxxxxxxxxx
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;
CREATE TABLE IN MYSQL
xxxxxxxxxx
CREATE TABLE CARS (
CARID INT,
NAME VARCHAR(20),
OWNER VARCHAR(20),
SALESDATE DATE,
PRIMARY KEY (CARID)
);
xxxxxxxxxx
# updated dec 2020
# Creates a Simple User table
# Uses an auto-incrementing primary key as userId
CREATE TABLE user (
userId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(100),
password VARCHAR(100)
) ENGINE=InnoDB;
xxxxxxxxxx
-- 'CREATE TABLE' followed by the name of the table.
-- In round brackets, define the columns.
CREATE TABLE `test_table`
(
id INT(10) PRIMARY KEY,
username VARCHAR(50) NOT NULL
);
xxxxxxxxxx
CREATE TABLE users(
id INT AUTO_INCREMENT,
first_name VARCHAR(100),
last_name VARCHAR(100),
email VARCHAR(50),
password VARCHAR(20),
location VARCHAR(100),
dept VARCHAR(100),
is_admin TINYINT(1),
register_date DATETIME,
PRIMARY KEY(id)
);
xxxxxxxxxx
CREATE TABLE student (
student_id int PRIMARY KEY,
student_name VARCHAR (255),
level int (10),
sex varchar (6),
contact int (10) );
xxxxxxxxxx
create table tutorials_tbl(
tutorial_id INT NOT NULL AUTO_INCREMENT,
tutorial_title VARCHAR(100) NOT NULL,
tutorial_author VARCHAR(40) NOT NULL,
submission_date DATE,
PRIMARY KEY ( tutorial_id )
);
xxxxxxxxxx
create table users (
id int unsigned auto_increment not null,
first_name varchar(32) not null,
last_name varchar(32) not null,
date_created timestamp default now(),
is_admin boolean,
num_points int,
primary key (id)
);