MySQL Intro - General Commands

 

1, mysql -u root -p

 

2. use testdb;

show databases;

use testdb;

 

3. create table etc

show tables;

 

create table customer (
customerId INT(32) NOT NULL AUTO_INCREMENT,
customerName varchar(45) not NULL,
country varchar(16) default NULL,
createdDate date default NULL,
updateDate date default NULL,
PRIMARY KEY (customerId)
) ENGINE=InnoDB;

grant all privileges on customer.* to test identified by 'test123';

create table employee (
employeeId INT(32) NOT NULL AUTO_INCREMENT,
email varchar(45) default NULL,
firstName varchar(45) NOT NULL,
lastName varchar(16) default NULL,
designation varchar(64) default NULL,
projectName varchar(64) default NULL,
PRIMARY KEY (employeeId)
) ENGINE=InnoDB;

grant all privileges on employee.* to test identified by 'test123';

 

insert into employee(email, firstName, lastName) values('tomy@appmagics.com', 'tomy', 'M');

 

CREATE TABLE `student` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `firstname` varchar(20) NOT NULL,

  `age` int(2) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

 

 

CREATE TABLE IF NOT EXISTS tasks (
    task_id INT(11) AUTO_INCREMENT,
    subject VARCHAR(45) DEFAULT NULL,
    start_date DATE DEFAULT NULL,
    end_date DATE DEFAULT NULL,
    description VARCHAR(200) DEFAULT NULL,
    PRIMARY KEY (task_id)
);