-
Notifications
You must be signed in to change notification settings - Fork 1
/
.mysql_history
70 lines (70 loc) · 2.04 KB
/
.mysql_history
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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
_HiStOrY_V2_
create\040table\040(
;
create\040table\040emails\040(
email_address\040varchar(255)
);
create\040table\040emails\040(\040email_address\040varchar(255)\040);
describe\040tables;
describe\040emails;
drop\040table\040emails
;
create\040table\040emails\040(\040email_address\040varchar(255)\040);
drop\040table\040emails
;
create\040table\040emails\040(\040email_address\040varchar(255)\040unique\040);
describe\040emails;
select\040*\040from\040emails;
quit
select\040*\040from\040emails;
quit
select\040*\040from\040emails;
quit
slelct\040*\040from\040emails;
select\040*\040from\040emails;
quit
select\040*\040from\040emails;
quit
select\040*\040from\040emails;
quit
select\040*\040from\040emails;
describe\040emails;
quit
create\040table\040test\040(
name\040varcar(40),
);
create\040table\040test\040(\040name\040varcar(40),\040);
quit
create\040table\040user\040(
id\040NOT\040NULL\040PRIMARY\040KEY\040AUTO_INCREMENT,
username\040VARCHAR(50)\040NOT\040NULL\040UNIQUE
create\040table\040user\040(
id\040NOT\040NULL\040PRIMARY\040KEY\040AUTO_INCREMENT,
username\040VARCHAR(50)\040NOT\040NULL\040UNIQUE,
email\040VARCHAR(50)\040NOT\040NULL\040UNIQUE
);
show\040tables;
CREATE\040TABLE\040user(
id\040INT\040NOT\040NULL\040PRIMARY\040KEY\040AUTO_INCREMENT,
username\040VARCHAR(50)\040NOT\040NULL\040UNIQUE,\040
passsword\040VARCHAR(50)\040NOT\040NULL\040UNIQUE,
CREATE\040TABLE\040user(
id\040INT\040NOT\040NULL\040PRIMARY\040KEY\040AUTO_INCREMENT,
username\040VARCHAR(50)\040NOT\040NULL\040UNIQUE,
passsword\040VARCHAR(50)\040NOT\040NULL,
email\040VARCHAR(50)\040NOT\040NULL\040UNIQUE
);
CREATE\040TABLE\040user(\040id\040INT\040NOT\040NULL\040PRIMARY\040KEY\040AUTO_INCREMENT,\040username\040VARCHAR(50)\040NOT\040NULL\040UNIQUE,\040passsword\040VARCHAR(50)\040NOT\040NULL,\040email\040VARCHAR(50)\040NOT\040NULL\040UNIQUE\040);
show\040tables
;
insert\040into\040user\040
drop\040table\040user;\040
show\040tables;
insert\040into\040user
select\040*\040from\040user;
exit
show\040tables;
describe\040user;
select\040*\040from\040usewr;
select\040*\040from\040user;
quit