CREATE DATABASE `db1` DEFAULT CHARACTER SET `utf8`;
CREATE DATABASE `test dbase` DEFAULT CHARACTER SET `utf8`;
CREATE DATABASE `супербаза` DEFAULT CHARACTER SET `utf8`;
CREATE TABLE tb1
(
id INT,
name VARCHAR(100) NOT NULL,
email VARCHAR(255) NOT NULL
)
CREATE TABLE tb2
SELECT user, host, password
FROM mysql.user;
CREATE TABLE tb3 LIKE tb1;
CREATE TEMPORARY TABLE tmp
SELECT user,host,password
FROM mysql.user;
CREATE TABLE table1
(
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100) NOT NULL,
email VARCHAR(255) NOT NULL
)
DROP DATABASE `test dbase`;
DROP DATABASE `супербаза`;
USE `bookshop`;
CREATE TABLE tb1
(
id INT,
name VARCHAR(100) NOT NULL,
email VARCHAR(255) NOT NULL
)
CREATE TABLE tb2
SELECT user, host, password
FROM mysql.user;
CREATE TABLE tb3 LIKE tb1;
CREATE TEMPORARY TABLE tmp
SELECT user,host,password
FROM mysql.user;