linux下mysql的基本使用

1.启动mysql

[root@localhost ~]# service mysqld start

2.登陆mysql

[root@localhost ~]# mysql -u root -p

3.查看数据库

mysql> show databases;

4.创建数据库

mysql> mysql> create database hutest;

5.使用数据库

mysql> use hutest;

6.查看表结构

mysql> show tables;

7.创建表

mysql> create table tb_test(id int primary key auto_increment, name varchar(18),sex varchar(18),age varchar(18));

8.插入表数据

mysql> insert into tb_test(name,sex,age) values ('michelle','girl',18);

9.查询表数据

mysql> select name from tb_test;

10.删除表

mysql> drop table tb_test;

11.添加外键
创建classes表，并为department_id属性创建外键关联

create table classes(
    id int primary key,
    name varchar(50) unique,
    department_id int,
    constraint classes_fk foreign key(department_id) references department(id)
)

notes:classes_fk：约束名
department(id)：classes表所关联的表department的主键