1.Navicate安装包下载

Navicat 中国 | 支持 MySQL、Redis、MariaDB、MongoDB、SQL Server、SQLite、Oracle 和 PostgreSQL 的数据库管理

2.安装

3.连接数据库

4.建表和四个基本的增删改查语句

CREATE DATABASE `ckk_school20250216`;

USE `ckk_school20250216`;

CREATE TABLE `student` (
  `stu_id` INT(10) NOT NULL AUTO_INCREMENT,
  `stu_name` VARCHAR(20) COLLATE utf8_bin DEFAULT NULL,
  `stu_id_card` VARCHAR(18) COLLATE utf8_bin DEFAULT NULL,
  `stu_pwd` VARCHAR(32) COLLATE utf8_bin DEFAULT NULL,
  `stu_mobile` VARCHAR(11) COLLATE utf8_bin DEFAULT NULL,
  `stu_gender` INT(1) DEFAULT NULL,
  `enrollment_date` DATE DEFAULT NULL,
  `remark` VARCHAR(200) COLLATE utf8_bin DEFAULT NULL,
  `del_mark` INT(1) DEFAULT '1',
  PRIMARY KEY (`stu_id`)
) ENGINE=INNODB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO `student`(`stu_id`,`stu_name`,`stu_id_card`,`stu_pwd`,`stu_mobile`,`stu_gender`,`enrollment_date`,`remark`,`del_mark`) 
VALUES (1,'小明','610123200210202345','pwd123','13500001111',1,'2025-02-16','stu测试',1);

DELETE FROM student WHERE stu_id = 1;

UPDATE student SET stu_name = '蔡坤坤' WHERE stu_id = 1 AND stu_name = '小明';

SELECT * FROM student;