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)

相关内容

热门资讯

WPK作弊开挂,AApoker... WPK作弊开挂,AApoker好牌,微扑克一贯有开挂工具1)AApoker好牌免费钻石:进一步探索A...
WPK四人透视,拱趴大菠萝挂怎... WPK四人透视,拱趴大菠萝挂怎么安装,德州扑克一直真的有透视app1、进入到拱趴大菠萝挂怎么安装是否...
WPK官网透视挂,拱趴大菠萝有... WPK官网透视挂,拱趴大菠萝有挂吗,aapoker切实存在有透视挂神器拱趴大菠萝有挂吗透视方法中分为...
WPK安卓辅助,大菠萝辅助器,... WPK安卓辅助,大菠萝辅助器,微扑克一贯真的是有辅助技巧大菠萝辅助器能透视中分为三种模型:大菠萝辅助...
WPK工具透视挂,AApoke... WPK工具透视挂,AApoker底牌,AApoker一直真的有透视挂攻略1、让任何用户在无需AApo...
WPK模拟器辅助器,扑克之星辅... WPK模拟器辅助器,扑克之星辅助,菠萝智星德州一贯有辅助器神器1、用户打开应用后不用登录就可以直接使...
WPK多开透视挂,AApoke... WPK多开透视挂,AApoker安装包,德州扑克切实有透视挂脚本1、AApoker安装包辅助器安装包...
WPK真假辅助器,拱趴大菠萝挂... WPK真假辅助器,拱趴大菠萝挂,德扑之星竟然是真的有辅助器攻略WPK真假辅助器,拱趴大菠萝挂,德扑之...
WPK辅助器透视,AApoke... WPK辅助器透视,AApoker插件,wpk本来有透视app1、任何AApoker插件透视是真的假的...
WPK真假开挂,wpk软件是真... WPK真假开挂,wpk软件是真的吗,红龙PoKer一直存在有开挂插件1、每一步都需要思考,不同水平的...