Ubuntu create database and tables in mysql
1.Check status
sudo systemctl mysql status;
2.If not started mysql service
sudo service mysql start; sudo service mysql status;
3.Then log in mysql via below command
sudo mysql -u root -p
And enter password.
4.
create database if not exists myDB;
5.
create table if not exist mt(BookIndex int not null,BookId bigint not null,BookName varchar(100) not null,BookTitle varchar(100) not null,primary key(BookIndex));
6