15 lines
200 B
MySQL
15 lines
200 B
MySQL
|
-- 查看sys_menu表的结构
|
||
|
|
DESCRIBE sys_menu;
|
||
|
|
|
||
|
|
-- 或者使用这个
|
||
|
|
SHOW COLUMNS FROM sys_menu;
|
||
|
|
|
||
|
|
-- 查看一条现有记录的所有字段
|
||
|
|
SELECT * FROM sys_menu WHERE menu_id = 1 LIMIT 1;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|