之前Navicat下了,快過期了,於是去網上找找看有沒有補丁
就不發百度雲了(老是被和諧)
這個是西西軟體園的,親測有效
下載點這裡
[Navicat下載](Navicat Premium中文版)
如何使用補丁看這裡
[Navicat註冊機使用](Navicat Premium 12破解啟用 - 優雅轉身 - 部落格園)
如果填寫註冊碼啟用的時候一直顯示紅叉,記得再回去看看選項對不對。
我的就是把Languages換成Simplified Chinese,(最後可能還要換一次,它會重置掉)再重新重新整理註冊碼就行了
sql語句示例:
```c
eX&ypKQlM6W6
eX&ypKQlM6W6
ALTER USER USER() IDENTIFIED BY ‘’;
## 建表
CREATE DATABASE 資料庫系統
use 資料庫系統
create TABLE Student(
Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20),
Ssex CHAR(2),
Sage SMALLINT,
Sdept CHAR(5)
)DEFAULT CHARSET utf8;
drop TABLE Student;
create TABLE Course(
Cno SMALLINT PRIMARY KEY auto_increment,
Cname CHAR(10),
Cpno CHAR(10),
Ccredit Char(10)
)DEFAULT CHARSET utf8 ;
drop TABLE Course;
create TABLE SC(
Sno CHAR(20),
Cno SMALLINT,
Grade INT
)DEFAULT CHARSET utf8;
drop TABLE SC;
## 插入資料
##Student表
INSERT Student VALUES(201215121,‘’,‘’,‘’,‘’)
INSERT Student VALUES(201215121,‘李勇’,‘男’,‘20’,‘CS’);
INSERT Student VALUES(201215122,‘劉晨’,‘女’,‘18’,‘CS’);
INSERT Student VALUES(201215123,‘王敏’,‘女’,‘18’,‘MA’);
INSERT Student VALUES(201215125,‘張立’,‘男’,‘19’,‘IS’);
##Course表
INSERT Course VALUES(null,‘’,‘’,‘’);
INSERT Course VALUES(null,‘資料庫’,‘5’,‘4’);
INSERT Course VALUES(null,‘數學’,‘’,‘2’);
INSERT Course VALUES(null,‘資訊系統’,‘1’,‘4’);
INSERT Course VALUES(null,‘作業系統’,‘6’,‘3’);
INSERT Course VALUES(null,‘資料結構’,‘7’,‘4’);
INSERT Course VALUES(null,‘資料處理’,‘’,‘2’);
INSERT Course VALUES(null,‘PASCAL語言’,‘6’,‘4’);
##SC表
INSERT SC VALUES(201215121,‘’,‘’);
INSERT SC VALUES(201215121,‘1’,‘92’);
INSERT SC VALUES(201215121,‘2’,‘85’);
INSERT SC VALUES(201215121,‘3’,‘88’);
INSERT SC VALUES(201215122,‘2’,‘90’);
INSERT SC VALUES(201215122,‘3’,‘80’);
select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY’,‘’));
## 3。23
select Sname from Student WHERE Sdept=‘CS’;
## 3。24
select sno from sc where Grade<60;
## 3。25
select sname,sdept,sage from student WHERE sage BETWEEN 20 and 23;
## 3。26
select sname,sdept,sage from student WHERE sage not BETWEEN 20 and 23;
##3。27
SELECT sname,ssex FROM student WHERE sdept in(‘cs’,‘ma’,‘is’);
##3。28
SELECT Sname,ssex from student where not sdept in(‘cs’,‘ma’,‘is’);
##3。29
select * from student where sno=‘201215121’;
##3。30
SELECT sname,sno,ssex from student where sname like ‘劉%’
##3。31
SELECT sname,sno,ssex from student where sname like ‘歐陽_’;
##3。32
SELECT sname,sno,ssex from student where sname like ‘_陽%’;
##3。33
SELECT sname,sno,ssex from student where sname not like ‘劉%’
##3。34
SELECT cno,ccredit from course WHERE cname like ‘資料庫’;
##3。39
select sno,grade from sc where cno=‘3’ ORDER BY grade desc
##3。41
select count(*) from student
##3。46
select cno,COUNT(sno) FROM sc GROUP BY cno
initialization-mode: always
schema:
- classpath:sql/department。sql
```