CREATE DATABASE db1 DEFAULT CHARACTER SET utf8 CREATE DATABASE test db

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
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;