MySQL:
远程连接:
mysql -uroot -p1127 -h192.168.56.1 -P3306
结果:
库表视图展示:
show databases;
结果:
use epoint;
select database();
结果:
show full tables;
结果:
版本查询:
select version();
结果:
列信息:
desc customers;
结果:
表定义:
show create table customers;
结果:
视图定义:
show create view view_cust_totalprice;
结果:
查看连接进程:
show processlist;
结果:
查看所有用户:
select host,user from mysql.user;
结果:
Oracle:
客户端连接数据库:
sqlplus epoint/Gepoint@127.0.0.1:1521/xixi
结果:
查看版本:
SELECT * FROM v$version;
结果:
查看数据库信息:
SELECT * FROM v$database;
结果:
查看实例信息:
SELECT * FROM v$instance;
结果:
所有用户表:
SELECT owner,table_name,tablespace_name FROM dba_tables;
结果:
当前用户表:
SELECT table_name,tablespace_name FROM user_tables;
结果:
查看表空间:
SELECT * FROM dba_tablespaces;
结果:
查看数据文件:
SELECT * FROM dba_data_files;
结果: