1、下载
下载地址:
安装包:IRIS_Community-2024.1.0.267.2-win_x64.exe
2、安装
3、启动
点击管理门户,浏览器自动打开地址:: http://localhost:52773/iris/csp/sys/UtilHome.csp
输入账号:_SYSTEM
密码:123456
登录成功
点击管理门户,浏览器自动打开地址:: http://localhost:52773/iris/csp/sys/UtilHome.csp
输入账号:Admin
密码:123456
点击管理门户,浏览器自动打开地址:: http://localhost:52773/iris/csp/sys/UtilHome.csp
输入账号:SuperUser
密码:123456
点击管理门户,浏览器自动打开地址:: http://localhost:52773/iris/csp/sys/UtilHome.csp
输入账号:CSPSystem
密码:123456
4、新建命名空间
5、自带的studio连接
右键点击,出现一个弹窗
6、dbeaver连接
下载
sql建表
SELECT 1
SELECT $ZVERSION
CREATE TABLE MyApp.Person (
ID INT PRIMARY KEY,
Name VARCHAR(100) NOT NULL,
Age INT,
Gender CHAR(1)
);
CREATE TABLE MyApp.Person2 (
ID INT PRIMARY KEY,
Name VARCHAR(100) NOT NULL,
Age INT,
Gender CHAR(1)
);
SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES WHERE Table_Schema = 'MyApp';
INSERT INTO MyApp.Person (ID, Name, Age, Gender) VALUES (1, 'John Doe', 30, 'M');
INSERT INTO MyApp.Person (ID, Name, Age, Gender) VALUES (2, 'John Doe', 30, 'M');
INSERT INTO MyApp.Person (ID, Name, Age, Gender) VALUES (3, 'John Doe', 30, 'M');
select * from MyApp.Person