1 创建数据表
-- 方式一,如果存在则该表则不创建,不存在才会创建
CREATE TABLE IF NOT EXISTS test1(
id int,
username VARCHAR(20)
);
-- 方式二:基于现有的表,造一张新表,字段的与查询结果一致,同时导入数据
CREATE TABLE test2 AS SELECT
employee_id,
last_name,
salary
FROM
employees;
CREATE TABLE test3 AS SELECT
employee_id,
last_name,
salary,
department_name
FROM
employees e
JOIN departments d ON e.department_id = d.department_id;
desc test3;
2 练习
-- 练习1:创建一个表employees_copy,实现对employees表的复制,包括表数据
CREATE TABLE employees_copy AS SELECT
*
FROM
employees;
-- 练习2:创建一个表employees_blanck,实现对employees表的复制,不包括表数据
CREATE TABLE employees_blanck AS SELECT
*
FROM
employees
WHERE
1 = 0;-- 用一个不成立的条件筛选掉数据
employees;