Skip to content

README.md

Latest commit

 

History

History
111 lines (81 loc) · 1.48 KB

README.md

File metadata and controls

111 lines (81 loc) · 1.48 KB

Using MySQL

INSTALLATION

brew install mysql
sudo apt isntall mysql-server

SETUP

mysql_secure_installation

RUN

mysql -u root -p

CREATE DATABASE

CREATE DATABASE mytasks;

Output:

Query OK, 1 row affected (0.01 sec)
USE mytasks;

Output:

Database changed

CREATE TABLE

Table:

id name email
1 Haidar haidar@gmail.com
2 Hanif hanif@gmail.com
3 Impact impact@gmail.com

SQL Create Table:

CREATE TABLE users (
  id INTEGER PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(50),
  email VARCHAR(50)
);
Query OK, 0 rows affected (0.01 sec)

INSERT DATA

INSERT INTO users (name, email)
VALUES
('Haidar', 'haidar@gmail.com'),
('Hanif', 'hanif@gmail.com'),
('Impact', 'impactbyte@gmail.com');

Output:

Query OK, 3 rows affected (0.02 sec)
Records: 3  Duplicates: 0  Warnings: 0

SELECT DATA

SELECT * FROM users;

Output:

+----+--------+----------------------+
| id | name   | email                |
+----+--------+----------------------+
|  1 | Haidar | haidar@gmail.com     |
|  2 | Hanif  | hanif@gmail.com      |
|  3 | Impact | impactbyte@gmail.com |
+----+--------+----------------------+
3 rows in set (0.00 sec)

DUMP DATA

cd examples/mysql
mysqldump -u root -p --databases mytasks > mytasks-dump.sql

Then check the mytasks-dump.sql file.