MySQL数据库高阶SQL语句

橘子超好吃

于 2022-06-16 19:44:44 发布

阅读量342

点赞数

分类专栏：数据库 Linux 文章标签：数据库 sql mysql

本文链接：https://blog.csdn.net/weixin_53246927/article/details/125309081

版权

每日分享：
没有谁天生倔强，只是为了梦想寸步不让。

文章目录

一、SQL高阶语句

create database run;
use run;
##创建表location
create table location (Region char(20),Store_Name char(20));
mysql> insert into location values('East','Boston');
insert into location values('East','New York');
insert into location values('West','Los Angeles');
insert into location values('West','Houston');

##创建表store_info
create table store_info (Store_Name char(20),Sales int(10),Date char(10));
insert into store_info values('Los Angeles','1500','2020-12-05');
insert into store_info values('Houston','250','2020-12-07');
insert into store_info values('Los Angeles','300','2020-12-08');
insert into store_info values('Boston','700','2020-12-08');
insert into store_info values(</