CREATE DATABASE java2103;
USE java2103;
SHOW DATABASES;
DROP DATABASE java2103;
SHOW DATABASES;
SHOW TABLES LIKE '%new%';
SHOW TABLES LIKE '%gg%';
SHOW TABLES;
CREATE TABLE new_goods(
id INT COMMENT '编号',
good_nam VARCHAR(32) COMMENT'名字',
price FLOAT COMMENT '价格',
description VARCHAR(255) COMMENT '商品描述');
SHOW TABLE STATUS FROM java2103 LIKE '%new%';
ALTER TABLE new_goods RENAME my_goods;

DESCRIBE my_goods;
SHOW CREATE TABLE my_goods;
SHOW FULL COLUMNS FROM my_goods;
ALTER TABLE my_goods MODIFY des CHAR(255);