mac用什么mysql数据库_Mac OS安装与使用H2与MySql数据库

1、H2数据库

1.1 命令行操作

通过java运行h2 shell，除了URL要填写并指向数据库的文件夹，其他帐号与密码可以配置为空，直接回车。

>> java -cp /Users/xxx/Works/env/jars/h2-1.4.200.jar org.h2.tools.Shell

Welcome to H2 Shell 1.4.200 (2019-10-14)

Exit with Ctrl+C

[Enter] jdbc:h2:~/test

URL jdbc:h2:/Users/xxx/Works/env/database/test_h2/data.h2;AUTO_SERVER=TRUE;MODE=MySQL;DATABASE_TO_LOWER=TRUE;

[Enter] org.h2.Driver

Driver

[Enter]

User

Password

Connected

Commands are case insensitive; SQL statements end with ';'

help or ? Display this help

list Toggle result list / stack trace mode

maxwidth Set maximum column width (default is 100)

autocommit Enable or disable autocommit

history Show the last 20 statements

quit or exit Close the connection and exit

sql>

URL