附件——数据库高级对应sql建表语句

最新推荐文章于 2022-08-17 22:41:32 发布
最新推荐文章于 2022-08-17 22:41:32 发布
阅读量507 收藏 1
点赞数
分类专栏： J2EE学习 # 第五章数据库 文章标签： mysql sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43372836/article/details/107815785
版权

目录

1. 表连接查询

2. SQL进阶练习题原码

3.sql进阶面试题建表语句

1.大于80分的学员

2.比昨天温度高的ID

3.查询每个主播的最⼤level以及对应的最⼩gap

(注意:不是每个主播的最⼤level和最⼩gap

4.课程数据行转列

创建千万测试数据

1. 表连接查询

/*
 Navicat Premium Data Transfer

 Source Server         : Mysql
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : chuange

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 04/06/2020 10:52:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for customers
-- ----------------------------
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `cust_id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_name` char(50) NOT NULL,
  `cust_address` char(50) DEFAULT NULL,
  `cust_city` char(50) DEFAULT NULL,
  `cust_state` char(5) DEFAULT NULL,
  `cust_zip` char(10) DEFAULT NULL,
  `cust_country` char(50) DEFAULT NULL,
  `cust_contact` char(50) DEFAULT NULL,
  `cust_email` char(255) DEFAULT NULL,
  PRIMARY KEY (`cust_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10006 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of customers
-- ----------------------------
BEGIN;
INSERT INTO `customers` VALUES (10001, 'Coyote Inc.', '200 Maple Lane', 'Detroit', 'MI', '44444', 'USA', 'Y Lee', 'ylee@coyote.com');
INSERT INTO `customers` VALUES (10002, 'Mouse House', '333 Fromage Lane', 'Columbus', 'OH', '43333', 'USA', 'Jerry Mouse', NULL);
INSERT INTO `customers` VALUES (10003, 'Wascals', '1 Sunny Place', 'Muncie', 'IN', '42222', 'USA', 'Jim Jones', 'rabbit@wascally.com');
INSERT INTO `customers` VALUES (10004, 'Yosemite Place', '829 Riverside Drive', 'Phoenix', 'AZ', '88888', 'USA', 'Y Sam', 'sam@yosemite.com');
INSERT INTO `customers` VALUES (10005, 'E Fudd', '4545 53rd Street', 'Chicago', 'IL', '54545', 'USA', 'E Fudd', NULL);
COMMIT;

-- ----------------------------
-- Table structure for orderitems
-- ----------------------------
DROP TABLE IF EXISTS `orderitems`;
CREATE TABLE `orderitems` (
  `order_num` int(11) NOT NULL,
  `order_item` int(11) NOT NULL,
  `prod_id` char(10) NOT NULL,
  `quantity` int(11) NOT NULL,
  `item_price` decimal(8,2) NOT NULL,
  PRIMARY KEY (`order_num`,`order_item`) USING BTREE,
  KEY `fk_orderitems_products` (`prod_id`) USING BTREE,
  CONSTRAINT `fk_orderitems_orders` FOREIGN KEY (`order_num`) REFERENCES `orders` (`order_num`),
  CONSTRAINT `fk_orderitems_products` FOREIGN KEY (`prod_id`) REFERENCES `products` (`prod_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of orderitems
-- ----------------------------
BEGIN;
INSERT INTO `orderitems` VALUES (20005, 1, 'ANV01', 10, 5.99);
INSERT INTO `orderitems` VALUES (20005, 2, 'ANV02', 3, 9.99);
INSERT INTO `orderitems` VALUES (20005, 3, 'TNT2', 5, 10.00);
INSERT INTO `orderitems` VALUES (20005, 4, 'FB', 1, 10.00);
INSERT INTO `orderitems` VALUES (20006, 1, 'JP2000', 1, 55.00);
INSERT INTO `orderitems` VALUES (20007, 1, 'TNT2', 100, 10.00);
INSERT INTO `orderitems` VALUES (20008, 1, 'FC', 50, 2.50);
INSERT INTO `orderitems` VALUES (20009, 1, 'FB', 1, 10.00);
INSERT INTO `orderitems` VALUES (20009, 2, 'OL1', 1, 8.99);
INSERT INTO `orderitems` VALUES (20009, 3, 'SLING', 1, 4.49);
INSERT INTO `orderitems` VALUES (20009, 4, 'ANV03', 1, 14.99);
COMMIT;

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `order_num` int(11) NOT NULL AUTO_INCREMENT,
  `order_date` datetime DEFAULT NULL,
  `cust_id` int(11) NOT NULL,
  PRIMARY KEY (`order_num`) USING BTREE,
  KEY `fk_orders_customers` (`cust_id`) USING BTREE,
  CONSTRAINT `fk_orders_customers` FOREIGN KEY (`cust_id`) REFERENCES `customers` (`cust_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20010 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of orders
-- ----------------------------
BEGIN;
INSERT INTO `orders` VALUES (20005, '2005-09-01 00:00:00', 10001);
INSERT INTO `orders` VALUES (20006, '2005-09-12 00:00:00', 10003);
INSERT INTO `orders` VALUES (20007, '2005-09-30 00:00:00', 10004);
INSERT INTO `orders` VALUES (20008, '2005-10-03 00:00:00', 10005);
INSERT INTO `orders` VALUES (20009, '2005-10-08 00:00:00', 10001);
COMMIT;

-- ----------------------------
-- Table structure for productnotes
-- ----------------------------
DROP TABLE IF EXISTS `productnotes`;
CREATE TABLE `productnotes` (
  `note_id` int(11) NOT NULL AUTO_INCREMENT,
  `prod_id` char(10) NOT NULL,
  `note_date` datetime DEFAULT NULL,
  `note_text` text,
  PRIMARY KEY (`note_id`) USING BTREE,
  FULLTEXT KEY `note_text` (`note_text`)
) ENGINE=MyISAM AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of productnotes
-- ----------------------------
BEGIN;
INSERT INTO `productnotes` VALUES (101, 'TNT2', '2005-08-17 00:00:00', 'Customer complaint:\r\nSticks not individually wrapped, too easy to mistakenly detonate all at once.\r\nRecommend individual wrapping.');
INSERT INTO `productnotes` VALUES (102, 'OL1', '2005-08-18 00:00:00', 'Can shipped full, refills not available.\r\nNeed to order new can if refill needed.');
INSERT INTO `productnotes` VALUES (103, 'SAFE', '2005-08-18 00:00:00', 'Safe is combination locked, combination not provided with safe.\r\nThis is rarely a problem as safes are typically blown up or dropped by customers.');
INSERT INTO `productnotes` VALUES (104, 'FC', '2005-08-19 00:00:00', 'Quantity varies, sold by the sack load.\r\nAll guaranteed to be bright and orange, and suitable for use as rabbit bait.');
INSERT INTO `productnotes` VALUES (105, 'TNT2', '2005-08-20 00:00:00', 'Included fuses are short and have been known to detonate too quickly for some customers.\r\nLonger fuses are available (item FU1) and should be recommended.');
INSERT INTO `productnotes` VALUES (106, 'TNT2', '2005-08-22 00:00:00', 'Matches not included, recommend purchase of matches or detonator (item DTNTR).');
INSERT INTO `productnotes` VALUES (107, 'SAFE', '2005-08-23 00:00:00', 'Please note that no returns will be accepted if safe opened using explosives.');
INSERT INTO `productnotes` VALUES (108, 'ANV01', '2005-08-25 00:00:00', 'Multiple customer returns, anvils failing to drop fast enough or falling backwards on purchaser. Recommend that customer considers using heavier anvils.');
INSERT INTO `productnotes` VALUES (109, 'ANV03', '2005-09-01 00:00:00', 'Item is extremely heavy. Designed for dropping, not recommended for use with slings, ropes, pulleys, or tightropes.');
INSERT INTO `productnotes` VALUES (110, 'FC', '2005-09-01 00:00:00', 'Customer complaint: rabbit has been able to detect trap, food apparently less effective now.');
INSERT INTO `productnotes` VALUES (111, 'SLING', '2005-09-02 00:00:00', 'Shipped unassembled, requires common tools (including oversized hammer).');
INSERT INTO `productnotes` VALUES (112, 'SAFE', '2005-09-02 00:00:00', 'Customer complaint:\r\nCircular hole in safe floor can apparently be easily cut with handsaw.');
INSERT INTO `productnotes` VALUES (113, 'ANV01', '2005-09-05 00:00:00', 'Customer complaint:\r\nNot heavy enough to generate flying stars around head of victim. If being purchased for dropping, recommend ANV02 or ANV03 instead.');
INSERT INTO `productnotes` VALUES (114, 'SAFE', '2005-09-07 00:00:00', 'Call from individual trapped in safe plummeting to the ground, suggests an escape hatch be added.\r\nComment forwarded to vendor.');
COMMIT;

-- ----------------------------
-- Table structure for products
-- ----------------------------
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `prod_id` char(10) NOT NULL,
  `vend_id` int(11) NOT NULL,
  `prod_name` char(255) NOT NULL,
  `prod_price` decimal(8,2) NOT NULL,
  `prod_desc` text,
  PRIMARY KEY (`prod_id`) USING BTREE,
  KEY `fk_products_vendors` (`vend_id`) USING BTREE,
  CONSTRAINT `fk_products_vendors` FOREIGN KEY (`vend_id`) REFERENCES `vendors` (`vend_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of products
-- ----------------------------
BEGIN;
INSERT INTO `products` VALUES ('ANV01', 1001, '.5 ton anvil', 5.99, '.5 ton anvil, black, complete with handy hook');
INSERT INTO `products` VALUES ('ANV02', 1001, '1 ton anvil', 9.99, '1 ton anvil, black, complete with handy hook and carrying case');
INSERT INTO `products` VALUES ('ANV03', 1001, '2 ton anvil', 14.99, '2 ton anvil, black, complete with handy hook and carrying case');
INSERT INTO `products` VALUES ('DTNTR', 1003, 'Detonator', 13.00, 'Detonator (plunger powered), fuses not included');
INSERT INTO `products` VALUES ('FB', 1003, 'Bird seed', 10.00, 'Large bag (suitable for road runners)');
INSERT INTO `products` VALUES ('FC', 1003, 'Carrots', 2.50, 'Carrots (rabbit hunting season only)');
INSERT INTO `products` VALUES ('FU1', 1002, 'Fuses', 3.42, '1 dozen, extra long');
INSERT INTO `products` VALUES ('JP1000', 1005, 'JetPack 1000', 35.00, 'JetPack 1000, intended for single use');
INSERT INTO `products` VALUES ('JP2000', 1005, 'JetPack 2000', 55.00, 'JetPack 2000, multi-use');
INSERT INTO `products` VALUES ('OL1', 1002, 'Oil can', 8.99, 'Oil can, red');
INSERT INTO `products` VALUES ('SAFE', 1003, 'Safe', 50.00, 'Safe with combination lock');
INSERT INTO `products` VALUES ('SLING', 1003, 'Sling', 4.49, 'Sling, one size fits all');
INSERT INTO `products` VALUES ('TNT1', 1003, 'TNT (1 stick)', 2.50, 'TNT, red, single stick');
INSERT INTO `products` VALUES ('TNT2', 1003, 'TNT (5 sticks)', 10.00, 'TNT, red, pack of 10 sticks');
COMMIT;

-- ----------------------------
-- Table structure for vendors
-- ----------------------------
DROP TABLE IF EXISTS `vendors`;
CREATE TABLE `vendors` (
  `vend_id` int(11) NOT NULL AUTO_INCREMENT,
  `vend_name` char(50) NOT NULL,
  `vend_address` char(50) DEFAULT NULL,
  `vend_city` char(50) DEFAULT NULL,
  `vend_state` char(5) DEFAULT NULL,
  `vend_zip` char(10) DEFAULT NULL,
  `vend_country` char(50) DEFAULT NULL,
  PRIMARY KEY (`vend_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1007 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of vendors
-- ----------------------------
BEGIN;
INSERT INTO `vendors` VALUES (1001, 'Anvils R Us', '123 Main Street', 'Southfield', 'MI', '48075', 'USA');
INSERT INTO `vendors` VALUES (1002, 'LT Supplies', '500 Park Street', 'Anytown', 'OH', '44333', 'USA');
INSERT INTO `vendors` VALUES (1003, 'ACME', '555 High Street', 'Los Angeles', 'CA', '90046', 'USA');
INSERT INTO `vendors` VALUES (1004, 'Furball Inc.', '1000 5th Avenue', 'New York', 'NY', '11111', 'USA');
INSERT INTO `vendors` VALUES (1005, 'Jet Set', '42 Galaxy Road', 'London', NULL, 'N16 6PS', 'England');
INSERT INTO `vendors` VALUES (1006, 'Jouets Et Ours', '1 Rue Amusement', 'Paris', NULL, '45678', 'France');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

2. SQL进阶练习题原码

-- 数据SQL
-- 学⽣表 Student
create table Student(SId varchar(10),Sname varchar(10),Sage datetime,Ssex
varchar(10));
insert into Student values('01' , '赵雷' , '1990-01-01' , '男');
insert into Student values('02' , '钱电' , '1990-12-21' , '男');
insert into Student values('03' , '孙⻛' , '1990-12-20' , '男');
insert into Student values('04' , '李云' , '1990-12-06' , '男');
insert into Student values('05' , '周梅' , '1991-12-01' , '⼥');
insert into Student values('06' , '吴兰' , '1992-01-01' , '⼥');
insert into Student values('07' , '郑⽵' , '1989-01-01' , '⼥');
insert into Student values('09' , '张三' , '2017-12-20' , '⼥');
insert into Student values('10' , '李四' , '2017-12-25' , '⼥');
insert into Student values('11' , '李四' , '2012-06-06' , '⼥');
insert into Student values('12' , '赵六' , '2013-06-13' , '⼥');
insert into Student values('13' , '孙七' , '2014-06-01' , '⼥');
-- 科⽬表 Course
create table Course(CId varchar(10),Cname nvarchar(10),TId varchar(10));
insert into Course values('01' , '语⽂' , '02');
insert into Course values('02' , '数学' , '01');
insert into Course values('03' , '英语' , '03');
-- 教师表 Teacher
create table Teacher(TId varchar(10),Tname varchar(10));
insert into Teacher values('01' , '张三');
insert into Teacher values('02' , '李四');
insert into Teacher values('03' , '王五');
-- 成绩表 SC
create table SC(SId varchar(10),CId varchar(10),score decimal(18,1));
insert into SC values('01' , '01' , 80);
insert into SC values('01' , '02' , 90);
insert into SC values('01' , '03' , 99);
insert into SC values('02' , '01' , 70);
insert into SC values('02' , '02' , 60);
insert into SC values('02' , '03' , 80);
insert into SC values('03' , '01' , 80);
insert into SC values('03' , '02' , 80);
insert into SC values('03' , '03' , 80);
insert into SC values('04' , '01' , 50);
insert into SC values('04' , '02' , 30);
insert into SC values('04' , '03' , 20);
insert into SC values('05' , '01' , 76);
insert into SC values('05' , '02' , 87);
insert into SC values('06' , '01' , 31);
insert into SC values('06' , '03' , 34);
insert into SC values('07' , '02' , 89);
insert into SC values('07' , '03' , 98);

3.sql进阶面试题建表语句

1.大于80分的学员

-- 建表语句
CREATE TABLE `mst_stu` (
 `name` varchar(255) DEFAULT NULL,
 `course` varchar(255) DEFAULT NULL,
 `score` int(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- 数据
INSERT INTO `mst_stu` VALUES ('张三', '语⽂', 81);
INSERT INTO `mst_stu` VALUES ('张三', '数学', 75);
INSERT INTO `mst_stu` VALUES ('李四', '语⽂', 76);
INSERT INTO `mst_stu` VALUES ('李四', '数学', 90);
INSERT INTO `mst_stu` VALUES ('王五', '语⽂', 81);
INSERT INTO `mst_stu` VALUES ('王五', '数学', 100);
INSERT INTO `mst_stu` VALUES ('王五', '英语', 90);

2.比昨天温度高的ID

-- mst_Weather
CREATE TABLE `mst_weather` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `date` date DEFAULT NULL,
 `temperature` int(255) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
INSERT INTO `mst_weather` VALUES (1, '2022-04-01', 20);
INSERT INTO `mst_weather` VALUES (2, '2022-04-02', 25);
INSERT INTO `mst_weather` VALUES (3, '2022-04-03', 21);
INSERT INTO `mst_weather` VALUES (4, '2022-04-04', 24);

3.查询每个主播的最⼤level以及对应的最⼩gap

(注意:不是每个主播的最⼤level和最⼩gap

CREATE TABLE `mst_zhubo` (
 `zhubo_id` int(11) NOT NULL,
 `level` int(255) DEFAULT NULL,
 `gap` int(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `mst_zhubo` VALUES (123, 8, 20);
INSERT INTO `mst_zhubo` VALUES (123, 9, 40);
INSERT INTO `mst_zhubo` VALUES (123, 9, 30);
INSERT INTO `mst_zhubo` VALUES (246, 6, 30);
INSERT INTO `mst_zhubo` VALUES (246, 6, 20);

4.课程数据行转列

CREATE TABLE `mst_class` (
 `class_id` varchar(255) NOT NULL,
 `grade` varchar(255) DEFAULT NULL,
 `rate` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `mst_class` VALUES ('abc123', 'primary', '70%');
INSERT INTO `mst_class` VALUES ('abc123', 'middle', '65%');
INSERT INTO `mst_class` VALUES ('abc123', 'high', '72%');
INSERT INTO `mst_class` VALUES ('hjkk86', 'primary', '69%');
INSERT INTO `mst_class` VALUES ('hjkk86', 'middle', '63%');
INSERT INTO `mst_class` VALUES ('hjkk86', 'high', '74%');

扩展：

CREATE TABLE `mst_year` (
 `year` int,`month` int,`amount` int
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `mst_year` VALUES (1991, 1, 1);
INSERT INTO `mst_year` VALUES (1991, 2, 2);
INSERT INTO `mst_year` VALUES (1991, 3, 3);
INSERT INTO `mst_year` VALUES (1991, 4, 4);
INSERT INTO `mst_year` VALUES (1992, 1, 1);
INSERT INTO `mst_year` VALUES (1992, 2, 2);
INSERT INTO `mst_year` VALUES (1992, 3, 3);
INSERT INTO `mst_year` VALUES (1992, 4, 4);

创建千万测试数据

-- 创建表
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `email` varchar(30) DEFAULT NULL,
  `phone` char(11) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `sex` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4;

-- 创建存储过程，插入1000万条数据
\d //
create procedure p1()
begin
set @i=1;
while @i<=10000000 do
insert into users values(
    null,
    concat('user:',@i),
    concat('user:',@i,'@qq.com'),
    concat('13701',FLOOR(RAND()*500000 + 500000)),
    floor(rand()*100),
    if(floor(rand() * 2) = 1 , '男' , '女')
    );
set @i=@i+1;
end while;
end;
//
\d ;

-- 调用存储过程，完成数据插入
call p1();


-- mysql> call p1();
-- Query OK, 0 rows affected (20 min 53.16 sec)


-- 查看数据
select count(id) from users;
-- +-----------+
-- | count(id) |
-- +-----------+
-- |  10000000 |
-- +-----------+
-- 1 row in set (2.18 sec)


-- 修改部分数据
 update users set name = 'zhangsan',email = 'zhangsan@qq.com',phone='13701383017',age=25 where id = 1000001;
 update users set name = 'lisi',email = 'lisi@qq.com',phone='17610195200',age=21 where id = 2000001;
 update users set name = 'wangwu',email = 'wangwu@qq.com',phone='17610195211',age=28 where id = 3000001;
 update users set name = 'zhaoliu',email = 'zhaoliu@qq.com',phone='17610195222',age=21 where id = 4000001;

-- 修改部分数据后进行查询
select * from users where name = 'zhangsan';
+---------+----------+-----------------+-------------+------+------+
| id      | name     | email           | phone       | age  | sex  |
+---------+----------+-----------------+-------------+------+------+
| 1000001 | zhangsan | zhangsan@qq.com | 13701383017 |   25 | 女   |
+---------+----------+-----------------+-------------+------+------+
1 row in set (3.73 sec)

-- 打开慢查询日志

 

 

 

 

 

 

 

 

 

 

以喻九州
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
web开发之附件数据库设计
Jahnng的专栏
03-03 6785
web开发中，经常会遇到附件的上传功能，这里针对web应用的附件的数据库设计发表自己的看法。 假设开发一个类似于新浪微博一样的社交网络，其中的模块分为微博模块，活动模块，博客模块； 微博模块里面，用户发表微博时，可以上传图片，而且可以上传多张图片； 活动模块里面，用户发布活动时，可以上传活动图片，而且可以上传多张图片； 博客模块，用户发表博客的时候，可以上传图片，而且可以上传多张图
达梦数据库建表操作SQL语句大全.pdf
07-19
达梦数据库建表操作SQL语句大全.pdf
⭐️MySQL高级之建表SQL⭐️
Cocowwy的博客
06-07 2万+
B站尚硅谷MySQL周阳老师的建表语句如下： P13 CREATE TABLE `tbl_emp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, `deptId` int(11) DEFAULT NULL, PRIMARY KEY (`id`) , KEY `fk_dept_id`(`deptId`) )ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = ut
高级数据库,建库,建表,建约束
while(True): print('adorable')
08-19 184
use master --建库，dbtime，名称time create database dbtime on primary ( name = 'Time.mdf', fileName = 'E:\Time.mdf', size = 4mb,maxsize = 20mb,filegrowth = 2mb ) log on ( name = 'Time_log.ldf', filenam...
MySQL高级篇（高阳）建表sql语句大全
qq_42826747的博客
06-10 7962
一、单表 CREATE TABLE IF NOT EXISTS `article`( `id` INT(10) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, `author_id` INT(10) UNSIGNED NOT NULL, `category_id` INT(10) UNSIGNED NOT NULL, `views` INT(10) UNSIGNED NOT NULL, `comments` INT(10) UNSIGNED NOT NULL, `
SqlServer附加数据库 的 SQL语句
jxrsgjs的博客
04-25 4071
USE master GO CREATE DATABASE 数据库 ON (FILENAME = 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\数据库.mdf'), (FILENAME = 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSS...
python自动生成sql建表语句
03-19
首先，从标题"python自动生成sql建表语句"我们可以了解到，我们要讨论的是如何用Python编写程序，以读取某种数据源（例如Excel文件），然后根据数据结构自动生成适用于不同数据库系统的SQL创建表的语句，如Oracle、...
excel生成SQl建表工具
05-19
excel生成SQl建表工具，excel生成SQl建表工具，excel生成SQl建表工具，excel生成SQl建表工具，excel生成SQl建表工具，excel生成SQl建表工具，excel生成SQl建表工具，excel生成SQl建表工具，excel生成SQl建表工具，...
gmall商城SQL建表语句
最新发布
03-22
以下是对GMALL商城SQL建表语句的补充说明: 1. 用户表(user_info) 用于存储用户的基本信息,如用户id、用户名、密码、手机号、邮箱等。用户是电商系统的核心,涉及到账号注册、登录、购物、支付等多个环节。 2. 商品...
Excel根据表格，批量生成sqlserver语句 ，生成建表语句，自行到数据库中执行
05-08
在日常工作中，有时我们需要根据结构化的数据表来创建对应的数据库表结构，这时，如果能批量生成SQL Server的建表语句，无疑会大大提高工作效率。Excel作为一种功能丰富的电子表格工具，可以通过启用宏来实现自动化...
MySQL 对比数据库的表结构-附件资源
03-02
MySQL 对比数据库的表结构-附件资源
SQL 数据库生成创建表语句
09-20
输入对应的数据库，执行命令，生成创建整个数据库表的创建语句。全部表，注意，是全部表，整个数据库的全部表。
BD通用的系统附件保存表设计
w13966597931的博客
08-17 737
有了这张表，就可以把项目中需要用到图片，视频，音频，文件，表格.....各种附件上传的时候，都可以调用统一的接口，把文件上传单独抽取出来，形成一个公共的接口，每次需要的时候直接调用，反后返回一个路径保存倒数据库。了解具体场景如何使用，联系作者。.........
mysql 数据库文件 表文件_Mysql数据库表格文件目录
weixin_31265041的博客
02-18 335
首先，表格数据存放路径和安装路径不一定是在同一个路径下的，因为安装的时候这两个路径可以分别选择，很多用户安装的时候虽然选了路径，但是忽略了其作用。数据库安装完成后，如何查看数据表格采存放的路径呢？可以在命令行下通过以下命令查看：show variables like 'datadir'; 这个‘datadir’表示的就是数据库存放路径，在配置文件里面存在对应的参数。然后我们可以根据这个路径找到my...
Sql server 2005系统表详细说明
weixin_30271335的博客
03-26 156
sysaltfiles主数据库保存数据库的文件syscharsets主数据库字符集与排序顺序sysconfigures主数据库配置选项syscurconfigs主数据库当前配置选项sysdatabases主数据库服务器中的数据库syslanguages主数据库语言syslogins主数据库登陆帐号信息sysoledbusers主数据库链接服务器登陆信息syspro...
MySQL_MySQL俩表索引优化实例
u013185175的博客
02-13 789
1.引入 我们呢，在上一节课的时候优化了一张单一的数据库表。那么接下来呢。我们一起优化一下俩张数据库表的索引。 2.创建操作的数据库 创建用户表：admin,并添加数据 -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABL...
mysql专项练习----菜鸟水平提升第一道题
无名小辈
08-03 588
按照上回老哥的代码进行一次练习 创建数据库 插入字段 SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `Teacher` -- ---------------------------- DROP TABLE IF EXISTS `Teacher`; CREATE TABLE...
MySQL学习笔记（四）
qq_45740503的博客
03-16 616
MySQL学习笔记（四）4.1 基本的select查询语句4.2 列的别名4.3 去除重复行4.4 空值参与运算4.5 着重号 `order表`4.6 查询常数4.7 显示表结构4.8 过滤数据 `where关键字使用`4.9 基本的SELECT语句练习 /* SQLyog Ultimate v12.08 (64 bit) MySQL - 5.7.28-log : Database - testdb ****************************************************
mybatis框架学习（完整）
热门推荐
wei_li_2015的博客
06-27 3万+
  目录   总结jdbc出现的问题 mybatis介绍 mybatis入门程序 占位符#{}与字符串拼接符${}区别 mybatis框架的原理 别名配置与映射文件加载方式 mybatis与hibernate的比较   一、总结jdbc出现的问题     1、准备数据库，执行mysql语句。 -- ---------------------------- -- Tab...
"SQL Server 2021 数据库—创建、建表、查询语句优质资料
本文介绍了如何在SQL Server 2021数据库中创建、建表和查询语句。首先介绍了利用对象资源管理器和T-SQL语句创建用户数据库的方法。在对象资源管理器中，可以通过打开SQL Server Management Studio，使用Windows身份...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值