COSCUP真的好精彩~
捨不得結束~~
https://dev.mysql.com/downloads/installer/
要登入註冊信箱,不用錢
選擇
可以下載的樣子
開始安裝
點兩下
安裝參考:
https://blog.csdn.net/2302_76384361/article/details/145292413
點Execute開始安裝
顯示NEXT
按NEXT
再按NEXT
按NEXT
帳號自帶Root 密碼:你設定的密碼
按NEXT
選+按NEXT
按Execute
顯示按Finish
輸入密碼>按cehck顯示
按NEXT
選Execute
顯示
自動跳出
點>輸入密碼+V存檔
顯示畫面+點+看到
測試輸入+按apply
顯示有改過去表示 連接成功
匯入表
建立一個資料庫
貼上
-- MySQL dump 10.13 Distrib 5.7.30, for macos10.14 (x86_64) -- -- Host: localhost Database: sample_database -- ------------------------------------------------------ -- Server version 8.0.15 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `sbl_team_data` -- DROP TABLE IF EXISTS `sbl_team_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sbl_team_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `team_id` varchar(45) DEFAULT NULL, `season` varchar(45) DEFAULT NULL, `win` int(11) DEFAULT NULL, `lost` int(11) DEFAULT NULL, `ranking` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=691 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sbl_team_data` -- LOCK TABLES `sbl_team_data` WRITE; /*!40000 ALTER TABLE `sbl_team_data` DISABLE KEYS */; INSERT INTO `sbl_team_data` VALUES (532,'2','S1',5,19,7),(533,'2','S2',9,21,6),(534,'2','S3',15,15,4),(535,'2','S4',4,26,7),(536,'2','S5',6,24,7),(537,'2','S6',5,25,7),(538,'2','S7',4,26,7),(539,'2','S8',11,19,5),(540,'2','S9',7,23,7),(541,'2','S10',10,20,5),(542,'2','S11',6,24,7),(543,'2','S12',13,17,5),(544,'2','S13',12,18,6),(545,'2','S14',7,23,7),(546,'2','S15',10,20,7),(547,'2','S16',8,28,7),(548,'6','S1',12,12,4),(549,'6','S2',18,12,3),(550,'6','S3',13,17,5),(551,'6','S4',21,9,2),(552,'6','S5',9,21,6),(553,'6','S6',9,21,6),(554,'6','S7',15,15,5),(555,'6','S8',11,19,6),(556,'6','S9',13,17,6),(557,'6','S10',18,12,2),(558,'6','S11',21,9,2),(559,'6','S12',19,11,2),(560,'6','S13',13,17,5),(561,'6','S14',17,13,4),(562,'6','S15',15,15,5),(563,'6','S15',24,12,1),(564,'1','S1',9,15,6),(565,'1','S2',16,14,4),(566,'1','S3',20,10,2),(567,'1','S4',19,11,3),(568,'1','S5',12,8,2),(569,'1','S6',20,10,3),(570,'1','S7',17,13,4),(571,'1','S8',22,8,1),(572,'1','S9',17,13,2),(573,'1','S10',8,22,7),(574,'1','S11',16,14,3),(575,'1','S12',15,14,3),(576,'1','S13',20,10,2),(577,'1','S14',14,9,3),(578,'1','S15',12,18,6),(579,'1','S16',21,15,2),(580,'7','S1',12,12,4),(581,'7','S2',16,14,4),(582,'7','S3',11,19,6),(583,'7','S4',15,15,5),(584,'7','S5',19,11,3),(585,'7','S6',13,17,5),(586,'7','S7',14,16,6),(587,'7','S8',10,20,7),(588,'7','S9',14,16,5),(589,'7','S10',9,21,6),(590,'7','S11',12,18,6),(591,'7','S12',11,19,6),(592,'7','S13',4,26,7),(593,'7','S14',9,21,6),(594,'7','S15',16,13,5),(595,'7','S16',18,18,5),(596,'4','S1',19,5,1),(597,'4','S2',25,5,1),(598,'4','S3',24,6,1),(599,'4','S4',22,8,1),(600,'4','S5',23,7,1),(601,'4','S6',21,9,2),(602,'4','S7',19,11,2),(603,'4','S8',15,15,4),(604,'4','S9',16,14,4),(605,'4','S10',16,14,4),(606,'4','S11',13,17,5),(607,'4','S12',14,16,4),(608,'4','S13',17,13,4),(609,'4','S14',19,11,2),(610,'4','S15',19,11,1),(611,'4','S16',18,18,4),(612,'3','S1',13,11,3),(613,'3','S2',18,12,2),(614,'3','S3',19,11,3),(615,'3','S4',17,13,4),(616,'3','S5',13,17,5),(617,'3','S6',23,7,1),(618,'3','S7',19,11,1),(619,'3','S8',17,13,3),(620,'3','S9',16,14,3),(621,'3','S10',17,13,4),(622,'3','S11',13,17,4),(623,'3','S12',10,20,7),(624,'3','S13',18,12,3),(625,'3','S14',21,9,1),(626,'3','S15',15,15,4),(627,'3','S16',17,19,6),(628,'5','S1',14,10,2),(629,'5','S2',3,27,7),(630,'5','S4',7,23,6),(631,'5','S5',15,15,4),(632,'5','S6',14,16,4),(633,'5','S7',17,13,3),(634,'5','S8',19,11,2),(635,'5','S9',22,8,1),(636,'5','S10',21,4,1),(637,'5','S11',22,5,1),(638,'5','S12',23,7,1),(639,'5','S13',21,9,1),(640,'5','S14',14,16,5),(641,'5','S15',18,12,2),(642,'5','S16',20,16,3),(643,'2','S1',5,19,7),(644,'2','S2',9,21,6),(645,'2','S3',15,15,4),(646,'2','S4',4,26,7),(647,'2','S5',6,24,7),(648,'2','S6',5,25,7),(649,'2','S7',4,26,7),(650,'2','S8',11,19,5),(651,'2','S9',7,23,7),(652,'2','S10',10,20,5),(653,'2','S11',6,24,7),(654,'2','S12',13,17,5),(655,'2','S13',12,18,6),(656,'2','S14',7,23,7),(657,'2','S15',10,20,7),(658,'2','S16',8,28,7),(659,'2','S1',5,19,7),(660,'2','S2',9,21,6),(661,'2','S3',15,15,4),(662,'2','S4',4,26,7),(663,'2','S5',6,24,7),(664,'2','S6',5,25,7),(665,'2','S7',4,26,7),(666,'2','S8',11,19,5),(667,'2','S9',7,23,7),(668,'2','S10',10,20,5),(669,'2','S11',6,24,7),(670,'2','S12',13,17,5),(671,'2','S13',12,18,6),(672,'2','S14',7,23,7),(673,'2','S15',10,20,7),(674,'2','S16',8,28,7),(675,'2','S1',5,19,7),(676,'2','S2',9,21,6),(677,'2','S3',15,15,4),(678,'2','S4',4,26,7),(679,'2','S5',6,24,7),(680,'2','S6',5,25,7),(681,'2','S7',4,26,7),(682,'2','S8',11,19,5),(683,'2','S9',7,23,7),(684,'2','S10',10,20,5),(685,'2','S11',6,24,7),(686,'2','S12',13,17,5),(687,'2','S13',12,18,6),(688,'2','S14',7,23,7),(689,'2','S15',10,20,7),(690,'2','S16',8,28,7); /*!40000 ALTER TABLE `sbl_team_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sbl_teams` -- DROP TABLE IF EXISTS `sbl_teams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sbl_teams` ( `id` varchar(45) NOT NULL, `name` varchar(45) DEFAULT NULL, `total_win` int(11) DEFAULT NULL, `total_lost` int(11) DEFAULT NULL, `playoff_count` int(11) DEFAULT NULL, `championships` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sbl_teams` -- LOCK TABLES `sbl_teams` WRITE; /*!40000 ALTER TABLE `sbl_teams` DISABLE KEYS */; INSERT INTO `sbl_teams` VALUES ('1','台灣啤酒籃球隊',270,210,14,4),('2','臺灣銀行籃球隊',133,347,3,0),('3','達欣工程籃球隊',480,266,14,2),('4','裕隆納智捷籃球隊',300,180,15,4),('5','璞園建築籃球隊',260,220,13,5),('6','富邦勇士籃球隊',248,232,10,1),('7','金門酒廠籃球隊',203,277,6,0); /*!40000 ALTER TABLE `sbl_teams` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2020-11-08 0:29:50
顯示
按 板手 圖案 顯示
PK~G的意思
參考: https://blog.csdn.net/qq_40115871/article/details/107162932
Default:表示原來註冊後預設的值,經過修改會變更
大家明天見~