MYSQL判断database、table是否存在

-- 判断是否存在SAMPLEDB，若存在则DROP，否则CREATE
drop database if exists SAMPLEDB;
create database SAMPLEDB;
use SAMPLEDB;
-- 判断是否存在表CUSTOMERS、ORDERS，若存在则DROP，否则CREATE
drop table if exists CUSTOMERS;
drop table if exists ORDERS;

create table CUSTOMERS (
 ID bigint not null,
 NAME varchar(15),
 primary key(ID)
);
create table ORDERS (
 ID bigint not null,
 ORDER_NUMBER varchar(15),
 PRICE double precision,
 CUSTOMER_ID bigint,
 primary key (ID)
);
-- 给ORDERS表添加索引
alter table ORDERS add index IDX_CUSTOMER(CUSTOMER_ID), 
-- 给ORDERS表添加foreigh key约束
add constraint FK_CUSTOMER foreign key (CUSTOMER_ID) references CUSTOMERS (ID);