Day 34 (MySQL)

1.除错 MySQL02影片00:01

2.MAD利用命令列进入MySQL

$ % = 终端机

(1)以下是 Mac

% cd /Applications/MAMP/Library/bin
% ./mysql -u root -h 127.0.0.1 -P 3306 -p
...
mysql> show databases;
....
mysql> exit
Bye
% 
// 安装 nmap
% brew install nmap
...
% nmap -v 127.0.0.1

(2)以下是 Windows

搜寻CMD
cd c:\MAMP\bin\mysql\bin
(dir检查有没有进去对的地方)
...> mysql -u root -h 127.0.0.1 -P 3306 -p
密码'root'(昨天设定的)

此时可以执行：(任何在MySQL能做的语法都能做)
(1)mysql> show databases;
(2)mysql> exit; ~~~Bye

3.命令列执行MySQL

(1)mysql> show databases;
(2)mysql> exit;   ~~~Bye
(3)USE northwind(已汇入)
(4)USE northwind(已汇入) > SHOW TABLES;
(5)USE northwind(已汇入) > SELECT 'Hello,World';
(6)USE northwind(已汇入) > SELECT 'Hello,World';
(7)USE northwind(已汇入) > SELECT 10+3;
(8)USE northwind(已汇入) > SELECT 10*3;
(9)USE northwind(已汇入) > SELECT 10/3;
(10)USE northwind(已汇入) > SELECT 10 dIV 3;(整数除)
(11)USE northwind(已汇入) > 
SELECT job_title, first_name, last_name FROM employees

(12)SELECT job_title, first_name, last_name FROM employees ORDER 
BY job_title; 
(排序)

(12)SELECT job_title, first_name, last_name FROM employees ORDER 
BY job_title DESC; 
(排序相反)

SELECT job_title, first_name, last_name FROM employees ORDER 
BY job_title DESC, first_name;
(job_title排序相反 ,first_name排序)

4.语法

(1)新增资料库

CREATE DATABASE `iii`;

(2)新增表格

CREATE TABLE `iii`.`cust` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `cname` VARCHAR(100) NOT NULL , 
`birthday` DATE NOT NULL , `tel` VARCHAR(100) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

介面

(3)新增TABLE内资料

INSERT INTO `cust` (cname,birthday,tel) VALUES('Brad','1999-01-02','0912-123456');

INSERT INTO `cust` (`id`, `cname`, `birthday`, `tel`) VALUES (NULL, 'Peter', '2019-06-04', '0911-222333');

(4)汇入北风资料库

northwind.sql
northwind-data.sql

北风 资料库
northwind mysql github
https://github.com/dalers/mywind

https://github.com/dalers/mywind/blob/master/northwind-erd.pdf
https://github.com/dalers/mywind/blob/master/northwind-data.sql
https://github.com/dalers/mywind/blob/master/northwind.sql

a. northwind.sql

DROP SCHEMA(等同DATABASE) IF EXISTS `northwind` ;  如果有其他北风 删掉
CREATE SCHEMA IF NOT EXISTS `northwind` DEFAULT CHARACTER SET latin1  创一个`northwind`这个资料库
USE `northwind` ; 使用
CREATE TABLE IF NOT EXISTS `northwind`.`customers`  在`northwind`创表`customers`

b. northwind-data.sql

INSERT INTO `customers` 新增`customers`内部资料

5.扫port看通讯埠有没有关防火墙

(请扫自己的不要扫人家的，违法)

// nmap => scan port
% nmap -v 127.0.01

6.甚麽git

Git Server => 程序码服务器 => 程序版本控制服务器