柚子快報(bào)邀請(qǐng)碼778899分享：數(shù)據(jù)庫(kù) MySQL第一次作業(yè)
柚子快報(bào)邀請(qǐng)碼778899分享：數(shù)據(jù)庫(kù) MySQL第一次作業(yè)
一、庫(kù)的建立
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表? （有主鍵，非空，默認(rèn)值的要求）
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表 （有主鍵自增長(zhǎng)，外鍵關(guān)聯(lián)，數(shù)值范圍的要求）
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)
柚子快報(bào)邀請(qǐng)碼778899分享：數(shù)據(jù)庫(kù) MySQL第一次作業(yè)
精彩鏈接
本文內(nèi)容根據(jù)網(wǎng)絡(luò)資料整理，出于傳遞更多信息之目的，不代表金鑰匙跨境贊同其觀點(diǎn)和立場(chǎng)。
轉(zhuǎn)載請(qǐng)注明，如有侵權(quán)，聯(lián)系刪除。
Officeworks辦公坊
