Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DDL 使用问题 #18

Open
processdatatech opened this issue Jan 16, 2024 · 2 comments
Open

DDL 使用问题 #18

processdatatech opened this issue Jan 16, 2024 · 2 comments

Comments

@processdatatech
Copy link

processdatatech commented Jan 16, 2024

create database test 之后 use test 报数据库not found ,而且提示的库名 为大写TEST

@codefollower
Copy link
Member

如果你用的是 lealone 的客户端访问数据库, use 语句是用来切换 schema,不是切换 database。

用 mysql 的客户端执行 create database test 和 create schema test 是一个意思,因为要兼容 mysql,所以 database 和 schema 是一样的,此时执行 use 语句就是切换 database。

@processdatatech
Copy link
Author

DDL 、DML 相关的文档可以丰富下

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants