k1qRaUuK

1Default port: 3306
2
3cmd> mysql -u root -p
4
5>show databases;
6>create database database_name;
7>use database_name;
8>show tables;
9>desc table_name;
10
11create table if not exists student(
12id int not null auto_increment,
13name varchar(255) not null,
14sid int not null,
15primary key(id),
16foreign key(sid) references team(sid)
17);
18
19>drop table students;
20
21select count(fc.film_id) from film_category fc join category c on fc.category_id = c.category_id where c.name like('Action');
22
23//Executing query from .sql file -
24> source path_to_file