操作库
* 增 create database [if not exists] my db ;
* 删 drop database [if exists] mtdb ;
* 查 show databases ;
* 改 alter database mydb character set utf-8 ;
查看前面创建的数据库的定义信息:show...
net start mysql
mysql -uroot -p
show databases
use 数据库名
how tables
--------------------------------------------------------------------------
select goods_id ,goods_name ,shop_price+1,market_p...
Question:gg only config to replicate dml, when source has some ddl changes, how to handle in source and target?
Answer:
GoldenGate capture the dml changes only by default,if you have made any changes...
dbms_metadata包中的get_ddl函数
--GET_DDL: Return the metadata for a single object as DDL.
-- This interface is meant for casual browsing (e.g., from SQLPlus)
-- vs. the programmatic OPEN / FETCH /...