Navicate数据库连接工具的下载与安装，附带使用（连接MySQL，建表、增删改查）

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;