MySQL第一次作业
创始人
2025-01-07 21:05:57
0

一、库的建立

mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | mydb2_stuinfo      | | mydb3_employee     | | mydb4_product      | | mydbl_test         | | mysql              | | performance_schema | | sys                | | temp2              | +--------------------+ 9 rows in set (0.00 sec)  mysql> create database mydb6_product; Query OK, 1 row affected (0.01 sec)  mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | mydb2_stuinfo      | | mydb3_employee     | | mydb4_product      | | mydb6_product      | | mydbl_test         | | mysql              | | performance_schema | | sys                | | temp2              | +--------------------+ 10 rows in set (0.00 sec)

二、建立employees表  (有主键,非空,默认值的要求)

mysql> create table employees(     -> id int primary key,     -> name varchar(50) not null,     -> age int,     -> gender varchar(10) not null default 'unknown',     -> salary float); Query OK, 0 rows affected (0.03 sec)  mysql> desc employees; +--------+-------------+------+-----+---------+-------+ | Field  | Type        | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ | id     | int         | NO   | PRI | NULL    |       | | name   | varchar(50) | NO   |     | NULL    |       | | age    | int         | YES  |     | NULL    |       | | gender | varchar(10) | NO   |     | unknown |       | | salary | float       | YES  |     | NULL    |       | +--------+-------------+------+-----+---------+-------+ 5 rows in set (0.00 sec)

三、建立 orders表 (有主键和非空的要求)

​ mysql> create table orders(     -> id int primary key,     -> name varchar(100) not null,     -> price float,     -> quantity int,     -> category varchar(50)); Query OK, 0 rows affected (0.03 sec)  mysql> desc orders; +----------+--------------+------+-----+---------+-------+ | Field    | Type         | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | id       | int          | NO   | PRI | NULL    |       | | name     | varchar(100) | NO   |     | NULL    |       | | price    | float        | YES  |     | NULL    |       | | quantity | int          | YES  |     | NULL    |       | | category | varchar(50)  | YES  |     | NULL    |       | +----------+--------------+------+-----+---------+-------+ 5 rows in set (0.00 sec)  ​

四、建立invoices表 (有主键自增长,外键关联,数值范围的要求)

mysql> create table invoices(     -> number int primary key,     -> order_id int,foreign key (order_id) references orders(id),     -> in_date date,     -> total_amount float ,check(total_amount>0)); Query OK, 0 rows affected (0.04 sec)  mysql> alter table invoices modify number int auto_increment; Query OK, 0 rows affected (0.06 sec) Records: 0  Duplicates: 0  Warnings: 0  mysql> desc invoices; +--------------+-------+------+-----+---------+----------------+ | Field        | Type  | Null | Key | Default | Extra          | +--------------+-------+------+-----+---------+----------------+ | number       | int   | NO   | PRI | NULL    | auto_increment | | order_id     | int   | YES  | MUL | NULL    |                | | in_date      | date  | YES  |     | NULL    |                | | total_amount | float | YES  |     | NULL    |                | +--------------+-------+------+-----+---------+----------------+ 4 rows in set (0.00 sec)

相关内容

热门资讯

透视能赢"wepok... 透视能赢"wepoker私人局俱乐部辅助(底牌透视脚本)wepoker软件靠谱么"都是有挂;wepo...
透视ai!wpk俱乐部是真的吗... 透视ai!wpk俱乐部是真的吗,(wPk真的有挂)辅助器(本来有挂)1、wpk俱乐部是真的吗系统规律...
透视系统!wepoker手机版... 透视系统!wepoker手机版透视脚本,(WePoKer方法)都是是真的有挂(详细黑侠破解)亲,关键...
透视挂透视!wpk俱乐部辅助器... 透视挂透视!wpk俱乐部辅助器,(WPk插件)插件辅助(一直是有挂)1、wpk俱乐部辅助器ai机器人...
透视新版"wepok... 透视新版"wepoker透视脚本免费使用视频(底牌透视脚本)we-poker有人玩吗"其实存在有挂;...
透视脚本!aapoker透视脚... 透视脚本!aapoker透视脚本,aapoker辅助软件合法吗,技巧教程(好像是有挂)1、aapok...
透视软件!淘宝买wepoker... 透视软件!淘宝买wepoker透视有用吗,wepoker私人局透视教程(透视果然是有挂);1)淘宝买...
透视辅助!wpk俱乐部是做什么... 透视辅助!wpk俱乐部是做什么的,(wpK透视)其实有挂(详细辅助);1、下载好wpk俱乐部是做什么...
透视ai代打!wepoker作... 透视ai代打!wepoker作弊辅助(WePoKer辅助器)破解辅助插件(真是存在有挂)1、不需要A...
透视脚本!aapoker ai... 透视脚本!aapoker ai插件,aapoker怎么提高中牌率,黑科技教程(都是真的有挂)1、实时...