Skip to content

Commit a9e0d77

Browse files
committed
Wrap examples in backticks
1 parent 3f0c455 commit a9e0d77

1 file changed

Lines changed: 60 additions & 16 deletions

File tree

Lines changed: 60 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -1,48 +1,92 @@
11
### CHANGE A USER’S PASSWORD
22

3-
mysql -u root;
4-
use mysql;
5-
update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='USER';
6-
flush privileges;
3+
```bash
4+
mysql -u root;
5+
use mysql;
6+
update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='USER';
7+
flush privileges;
8+
```
9+
10+
---
711

812
### SHOW WARNINGS FROM A QUERY THAT GENERATED ONE OR MORE WARNINGS
913

10-
show warnings;
14+
```bash
15+
show warnings;
16+
```
17+
18+
---
1119

1220
### LOGGING IN AS ROOT [http://www.youtube.com/watch?v=9NCbFHC7xDc](http://www.youtube.com/watch?v=9NCbFHC7xDc)
1321

14-
mysql -u root -p
22+
```bash
23+
mysql -u root -p
24+
```
25+
26+
---
1527

1628
### SELECTING A DATABASE, ONCE LOGGED IN
1729

18-
use <database_name>;
30+
```bash
31+
use <database_name>;
32+
```
33+
34+
---
1935

2036
### CHECK THE STATUS OF MYSQL, INCLUDING THINGS LIKE CURRENT CHARACTER SET SETTINGS, MYSQL VERSION, CURRENT DATABASE BEING USED, UNIX SOCKET
2137

22-
status;
38+
```bash
39+
status;
40+
```
41+
42+
---
2343

2444
### DETERMINE WHICH DATABASE IS BEING USED
2545

26-
select database();
46+
```bash
47+
select database();
48+
```
49+
50+
---
2751
2852
### SHOW THE TABLES IN A CERTAIN DATABASE
2953
30-
show tables;
54+
```bash
55+
show tables;
56+
```
57+
58+
---
3159
3260
### THREE WAYS TO DESCRIBE A TABLE IN A CERTAIN DATABASE
3361
34-
show columns from <table_name>;
35-
desc <table_name>;
36-
describe <table_name>;
62+
```bash
63+
show columns from <table_name>;
64+
desc <table_name>;
65+
describe <table_name>;
66+
```
67+
68+
---
3769
3870
### SELECT EVERYTHING FROM A CERTAIN TABLE
3971
40-
select * from <table_name>;
72+
```bash
73+
select * from <table_name>;
74+
```
75+
76+
---
4177
4278
### SELECT A CERTAIN COLUMN FROM A CERTAIN TABLE
4379
44-
select <column_name> from <table_name>;
80+
```bash
81+
select <column_name> from <table_name>;
82+
```
83+
84+
---
4585
4686
### SELECT TWO COLUMNS FROM A CERTAIN TABLE
4787
48-
select <column_1>, <column_2> from <table_name>;
88+
```bash
89+
select <column_1>, <column_2> from <table_name>;
90+
```
91+
92+
---

0 commit comments

Comments
 (0)