MS SQL:
CREATE DATABASE db_books
ON ( NAME=db_books1,FILENAME=’c:\user\data\bookdat1.mdf’, SIZE=100MB, MAXSIZE=200, FILEGROWTH=20)
LOG ON
(NAME=booklog1, FILENAME=’c:\user\data\booklog1.ldf’,SIZE=100MB, MAXSIZE=200,FILEGROWTH=20);
USE db_books;

MySQL:
CREATE DATABASE db_books;
USE db_books;

MySQL:
CREATE TABLE tbl_topic (
topic_id tinyint NOT NULL UNSIGNED AUTO_INCREMENT PRIMARY KEY,
topic_name varchar (100))

MySQL:
CREATE TABLE tbl_books (
b_id char(10) NOT NULL PRIMARY KEY,
b_name varchar (255) NOT NULL,
b_author varchar(255),
b_topic smallint,
price decimal (8,2),
FOREIGN KEY (b_topic) REFERENCES tbl_topic(topic_id) ON DELETE NO ACTION ON UPDATE CASCADE)
TYPE= InnoDB;

MS SQL:
ALTER TABLE tbl_topic ALTER COLUMN topic_id smallint NOT NULL IDENTITY;

MySQL:
ALTER TABLE tbl_topic MODIFY topic_id smallint NOT NULL AUTO_INCREMENT;

SQL:
INSERT INTO tbl_books VALUES
("978-1-873671-00-9","Красный террор в Россiи 1918-1923","Мельгунов С.П", 3, 250),
("978-1-873645-76-9","Моревизор уходит в плавание","Надеждина Н.А.", 2, 85),
("978-1-345645-01-9","И расцвел цветок","Егоров Валерий", 3, 185);