易截截图软件、单文件、免安装、纯绿色、仅160KB

创建oracle访问mysql的数据链路步骤

(1)登陆到mysql
C:\Documents and Settings\Administrator>mysql -h localhost -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 69
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
(2)创建数据库
mysql> create database oracle;
Query OK, 1 row affected (0.00 sec)
(3)创建被访问的mysql用户
mysql> grant all privileges on oracle.* to 'orauser'@'%' identified by 'orauser'
with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
(4)登陆该用户,并测试
C:\Documents and Settings\Administrator>mysql -h localhost -u orauser -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 70
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use oracle;
Database changed
mysql> create table test(tid integer,tname varchar(20));
Query OK, 0 rows affected (0.06 sec)
mysql> insert into test(tid,tname)values(1,'byf');
Query OK, 1 row affected (0.03 sec)
mysql> insert into test(tid,tname)values(2,'others');
Query OK, 1 row affected (0.02 sec)
mysql> select * from test;
+------+--------+
| tid | tname |
+------+--------+
|    1 | byf    |
|    2 | others |
+------+--------+
2 rows in set (0.00 sec)
mysql>
(5)安装mysql odbc driver 3.51并设置odbc数据源
data source name:mysqlora
server:localhost
user: orauser
password:orauser
database:oracle
(6)配置初始化参数%ORACLE_HOME%/admin/initmysqlora.ora
HS_FDS_CONNECT_INFO =mysqlora
HS_FDS_TRACE_LEVEL = on
(7)配置%ORACLE_HOME%/newtwork/admin/tnsname.ora
mysqlora=
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  &nb


相关文档:

oracle分页

racle分页查询语句
默认分类   2009-12-23 18:17   阅读43   评论0   字号: 大大  中中  小小 Oracle分页查询语句
本文转载自:yangtingkun.itpub.net/post/468/100278
Oracle的分页查询语句基本上可以按照本文给出的格式来进行套用。
分页查询格式:
sql 代码 ......

Oracle 学习知识点(一)

 一 登录SQLPLUS
    sqlplus用户名/密码@数据库实例as登录角色;
如:用户sys(密码为123)以sysdba的角色登录数据库ORACL,我们可以输入:sqlplus sys/123@oracl as sysdba;
    这种登录方式会直接暴露密码,如果想隐藏密码,可以在此省略密码的输入,如:sqlplus sys@oracl as sysdb ......

MySql免安装版的相关配置

   1)、去sun的官网下载一个mysql的压缩包,我下载的是mysql-noinstall-5.5.0-m2-win32.zip。
   2)、把上面下载的压缩包解压到:D:\Program Files\mysql下面。
   3)、在 D:\Program Files\mysql\ 中找 my-large.ini 把它复制成 my.ini。
   4)、在 my.ini 中找 [mysqld] ,添 ......

mysql字符集查看以及修改

mysql字符集查看以及修改
http://blog.csdn.net/cs870101/archive/2009/09/23/4580879.aspx
转自:http://blog.chinaunix.net/u2/85344/showart_2042280.html
Liunx下修改MySQL字符集:
1.查找MySQL的cnf文件的位置
find / -iname '*.cnf' -print
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-la ......

ubuntu下更改mysql默认编码(字符集)

 
安装mysql
sudo apt-get install mysql-server #直接自动获得可用版本
也可以这样写
sudo apt-get install mysql-server-5.0 #安装mysql服务器5.0版本
安装后
/etc/init.d/mysql start (stop) 为启动和停止服务器
/etc/mysql/ 主要配置文件所在位置 my.cnf
/var/lib/mysql/ 放置的是数据库表文件夹,这里的m ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号