MySQL数据库建库表查询以及Vue项目创建npm命令一览-----MySQL

旧约Alatus

已于 2024-02-03 01:54:15 修改

阅读量845

点赞数 20

分类专栏：数据库 # MySQL 文章标签：数据库 sql mysql database 后端 vue vue.js

于 2024-02-01 11:34:25 首次发布

本文链接：https://blog.csdn.net/2201_75960169/article/details/135939997

版权

数据库同时被 2 个专栏收录

67 篇文章 0 订阅

订阅专栏

MySQL

12 篇文章 0 订阅

订阅专栏

SELECT * FROM employees WHERE hire_date = (SELECT  DISTINCT hire_date FROM employees  ORDER BY hire_date DESC LIMIT 1 OFFSET 2);
select * from employees order by hire_date desc limit 1;
SELECT s.emp_no,s.salary,s.from_date,s.to_date,d.dept_no FROM salaries AS s JOIN dept_manager AS d ON s.emp_no = d.emp_no ORDER BY s.emp_no asc
SELECT e.last_name,e.first_name,d.dept_no FROM employees AS e JOIN dept_emp AS d ON e.emp_no = d.emp_no
SELECT e.last_name,e.first_name,d.dept_no FROM employees AS e JOIN dept_emp AS d ON e.emp_no = d.emp_no
SELECT * FROM employees WHERE hire_date = (SELECT DISTINCT hire_date FROM employees ORDER BY hire_date DESC LIMIT 1 OFFSET 2);
select * from employees order by hire_date desc limit 1;
SELECT s.emp_no,s.salary,s.from_date,s.to_date,d.dept_no FROM salaries AS s JOIN dept_manager AS d ON s.emp_no = d.emp_no ORDER BY s.emp_no asc
SELECT e.last_name,e.first_name,d.dept_no FROM employees AS e JOIN dept_emp AS d ON e.emp_no = d.emp_no
SELECT e.last_name,e.first_name,d.dept_no FROM employees AS e JOIN dept_emp AS d ON e.emp_no = d.emp_no

DROP TABLE IF EXISTS `BWL-230426-0032`;
CREATE TABLE `BWL-230426-0032`(
  id PRIMARY KEY AUTO_INCREMENT INT COMMENT '车辆ID',
  brand_name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车型',
  statue BOOLEAN DEFAULT FALSE COMMENT '运营状态:true运营中 false未在运营',
  car_health VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆健康信息',
  driver VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆运营人',
  buy_date DATE NULL DEFAULT '1980-10-12' COMMENT '车辆购入时间',
  car_number VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车牌信息',
  price DOUBLE NULL DEFAULT 1 COMMENT '购入价格',
  id USING BTREE
) ENGINE = INNODB AUTO_INCREMENT = 392 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '出租车辆监管信息系统'

CREATE TABLE `BWL-230426-0032`(id INT AUTO_INCREMENT PRIMARY KEY COMMENT '车辆ID',
brand_name VARCHAR(255) COMMENT '车型',statue BOOLEAN COMMENT '运营状态:true运营中 false未在运营',
car_health VARCHAR(255) COMMENT '车辆健康信息',driver VARCHAR(255) COMMENT '车辆运营人',
buy_date DATE COMMENT '车辆购入时间',car_number VARCHAR(255) COMMENT '车牌信息',
price DOUBLE COMMENT '购入价格')

INSERT INTO `BWL-230426-0032`(id,brand_name,statue,car_health,driver,buy_date,car_number,price) VALUES
(NULL,'丰田雷凌',FALSE,'正常','欧','2018-06-12','粤B123456',11.6),
(NULL,'比亚迪E5',TRUE,'正常','刘','2018-06-12','粤B112356',15.6),
(NULL,'丰田卡罗拉',FALSE,'维修中','钟','2018-06-12','粤Bcz3456',12.6),
(NULL,'日产轩逸',FALSE,'正常','蔡','2018-06-12','粤B1d4asd',14.6);
DROP TABLE IF EXISTS `BWL-230426-0032`;
CREATE TABLE `BWL-230426-0032`(
  id PRIMARY KEY AUTO_INCREMENT INT COMMENT '车辆ID',
  brand_name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车型',
  statue BOOLEAN DEFAULT FALSE COMMENT '运营状态:true运营中 false未在运营',
  car_health VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆健康信息',
  driver VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆运营人',
  buy_date DATE NULL DEFAULT '1980-10-12' COMMENT '车辆购入时间',
  car_number VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车牌信息',
price DOUBLE NULL DEFAULT 1 COMMENT '购入价格',
id USING BTREE
) ENGINE = INNODB AUTO_INCREMENT = 392 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '出租车辆监管信息系统'

CREATE TABLE `BWL-230426-0032`(id INT AUTO_INCREMENT PRIMARY KEY COMMENT '车辆ID',
brand_name VARCHAR(255) COMMENT '车型',statue BOOLEAN COMMENT '运营状态:true运营中 false未在运营',
car_health VARCHAR(255) COMMENT '车辆健康信息',driver VARCHAR(255) COMMENT '车辆运营人',
buy_date DATE COMMENT '车辆购入时间',car_number VARCHAR(255) COMMENT '车牌信息',
price DOUBLE COMMENT '购入价格')

INSERT INTO `BWL-230426-0032`(id,brand_name,statue,car_health,driver,buy_date,car_number,price) VALUES
(NULL,'丰田雷凌',FALSE,'正常','欧','2018-06-12','粤B123456',11.6),
(NULL,'比亚迪E5',TRUE,'正常','刘','2018-06-12','粤B112356',15.6),
(NULL,'丰田卡罗拉',FALSE,'维修中','钟','2018-06-12','粤Bcz3456',12.6),
(NULL,'日产轩逸',FALSE,'正常','蔡','2018-06-12','粤B1d4asd',14.6);

安装脚手架:npm install -g @vue/cli
检查版本:vue --version
创建项目:vue create 项目名
基于Vite创建方法如下
安装create vue脚手架自动创建vue3工程:npm init vue@latest
构建完成CD进去:cd vue3-project
安装npm:npm install
启动应用:npm run dev
安装脚手架:npm install -g @vue/cli
检查版本:vue --version
创建项目:vue create 项目名
基于Vite创建方法如下
安装create vue脚手架自动创建vue3工程:npm init vue@latest
构建完成CD进去:cd vue3-project
安装npm:npm install
启动应用:npm run dev