SQL语法基础----j建波

一,建库

1，创建名称为yuesu的库。

        CREATE DATABASE IF NOT EXISTS yuesu DEFAULT CHARSET utf8;

二，建表

1创建名称为student的表。

        CREATE TABLE IF NOT EXISTS student
        (
            id INT PRIMARY KEY,
            NAME VARCHAR(20)
        );

三，增，删，查，改

1，增：inset into student (id,name)values(1,张三)

2，删，delete from student

3，查 select*from student

4，改 update student set name="张小三" where name="张三"

四，多表关联查询

一、外连接

1.左连接    left join

SQL语句：   select * from student left join score on student.Num=score.Stu_id;

2.右连接 right join 

SQL语句：select * from student right join score on student.Num=score.Stu_id

二、内连接

 inner join

SQL语句：select * from student inner join score on student.Num=score.Stu_id;

此时的语句就相当于：select * from student,score where student.ID=course.ID;
 

五，子查询

  d.*,(
    SELECT
      COUNT(*)
    FROM
      employees e
    WHERE
      e.department_id = d.department_id
  )
FROM departments d