12 lines
219 B
SQL
12 lines
219 B
SQL
-- 检查banner表是否存在
|
|
SHOW TABLES LIKE 'banner';
|
|
|
|
-- 查看banner表结构
|
|
DESC banner;
|
|
|
|
-- 查询banner表数据
|
|
SELECT * FROM banner;
|
|
|
|
-- 查询启用状态的轮播图
|
|
SELECT * FROM banner WHERE status = 1;
|