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)

相关内容

热门资讯

交流学习经验辅助器!毛豆娱乐辅... 交流学习经验辅助器!毛豆娱乐辅助器多功能AI脚本,毛豆娱乐一贯是有辅助器脚本1、毛豆娱乐辅助软件下载...
玩家必备教程辅助!九游互娱辅助... 玩家必备教程辅助!九游互娱辅助多功能AI攻略,九游互娱本来真的是有辅助攻略1、在九游互娱插件功能辅助...
玩家必备科普外挂!新天地外挂多... 玩家必备科普外挂!新天地外挂多功能AI技巧,新天地本来真的有外挂技巧1、起透看视 新天地辅助软件价格...
揭秘真相作弊器!长盈互娱作弊器... 揭秘真相作弊器!长盈互娱作弊器多功能AI软件,长盈互娱一贯是真的有作弊器软件1、任何长盈互娱透视是真...
教学盘点辅助!四通娱乐3辅助多... 教学盘点辅助!四通娱乐3辅助多功能AIapp,四通娱乐3本来有辅助app亲,关键说明,四通娱乐3透视...
必备攻略外挂!千秋互娱外挂多功... 必备攻略外挂!千秋互娱外挂多功能AI工具,千秋互娱一直真的是有外挂工具1、玩家可以在千秋互娱透视最简...
推荐攻略开挂!七天娱乐开挂多功... 推荐攻略开挂!七天娱乐开挂多功能AIapp,七天娱乐真是存在有开挂app1、推荐攻略开挂!七天娱乐开...
记者发布透视挂!大大娱乐透视挂... 记者发布透视挂!大大娱乐透视挂多功能AI方法,大大娱乐切实真的是有透视挂方法1、玩家可以在大大娱乐透...
一分钟了解透视器!新九五透视器... 一分钟了解透视器!新九五透视器多功能AI脚本,新九五都是存在有透视器脚本进入游戏-大厅左侧-新手福利...
总算了解外挂!嘻嘻娱乐外挂多功... 总算了解外挂!嘻嘻娱乐外挂多功能AI脚本,嘻嘻娱乐一贯是有外挂脚本1、每一步都需要思考,不同水平的挑...