mysql查询表找不到

SELECT * FROM your_table_name;

USE your_database_name;

SHOW TABLES;

CREATE TABLE your_table_name (
    column1 datatype,
    column2 datatype,
    ...
);

SHOW GRANTS FOR 'your_username'@'your_host';

GRANT SELECT, INSERT, UPDATE, DELETE ON your_database_name.your_table_name TO 'your_username'@'your_host';

-- 检查当前数据库
USE your_database_name;

-- 查看所有表
SHOW TABLES;

-- 如果表不存在，创建表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

-- 查询表
SELECT * FROM users;