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> exitBye% // 安装 nmap% brew install nmap...% nmap -v 127.0.0.1

(2)以下是 Windows

搜寻CMDcd 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 => 程式码伺服器 => 程式版本控制伺服器