CREATE DATABASE db1 DEFAULT CHARACTER SET utf8 CREATE DATABASE test db

  • Anonymous
  • MySQL
  • 04 Apr 2015 
 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;
← newer dump
older dump →