FQe22E9f

1--MySql Commands
2
3--MySql Login
4-h hostname -u username -p password
5
6mysql-ctl cli
7mysql-ctl start
8mysql-ctl stop
9
10SHOW DATABASES;
11-- This list all the databases.
12
13CREATE DATABASE [db_name_to_be_created];
14CREATE DATABASE IF NOT EXISTS `wrong_database_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
15
16DROP DATABASE [database_name_to_be deleted];
17DROP DATABASE IF EXISTS `wrong_database_name`;
18
19USE [database_name]
20
21
22SHOW TABLES;
23--List all the tables in selected database.
24
25DESCRIBE [table_name];
26DROP TABLE [tablename];
27
28CREATE TABLE people
29(
30id INT PRIMARY KEY AUTO_INCREMENT,
31name VARCHAR(255),
32age INT
33);
34
35INSERT INTO
36`people` (`name`, `age`)
37VALUES
38('John', 24),
39('Jane', 22);
40
41SELECT `name`, `age` FROM `people`;
42
43SELECT
44`name`,
45`age`
46FROM
47`people`
48WHERE
49`age` > 22
50LIMIT
511
52
53UPDATE
54`people`
55SET
56`age` = 23
57WHERE
58`name` = 'Jane';
59
60DELETE FROM
61`people`
62WHERE
63`name` = 'Jane';