Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë
/******************************************************************************/
/*
Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë
½Å±¾ÈÎÎñ:½¨Á¢4¸ö±í,Ìí¼ÓÖ÷¼ü,Íâ¼ü£¬²åÈëÊý¾Ý,½¨Á¢ÊÓͼ
ÔËÐл·¾³1:microsoft sqlserver 2000 ²éѯ·ÖÎöÆ÷
ÔËÐл·¾³2:mysql5.0 phpMyAdminÍøÒ³½çÃæ
ÔËÐл·¾³3:oracle 9i SQL*PLUSÃüÁîÐнçÃæ
author£ºchinayaosir
blog: http://blog.csdn.net/chinayaosir/
QQ: 44633197
ÉùÃ÷£ºÑϽûÆäËüÍøÕ¾²»¾¹ý×÷ÕßchinayaosirͬÒâÈÎÒâ×ªÔØ
*/
/******************************************************************************/
/*script test ok with microsoft sqlserver 2000 ²éѯ·ÖÎöÆ÷ */
/******************************************************************************/
/*DB:MSSQL2000 SCRIPT*/
/*0.drop table list*/
drop table Employee;
drop table Department;
drop table Post;
drop table Account;
/*********************************************************/
/*DB:MSSQL2000 SCRIPT*/
/*1.create all table*/
create table Account(
oid int not null,
username varchar(30) not null,
password varchar(10) null,
invalid varchar(1) null
);
create table bab.Post(
/*oid int identity(1,1) not null primary key,*/
oid int not null,
postName varchar(30) not null
);
create table Department(
oid int not null,
deptName varchar(30) not null,
parentid int null,
manager varchar(30) null,
email varchar(30) null
);
create table Employee(
oid int&nb
Ïà¹ØÎĵµ£º
¹ýÂËÆ÷Ìõ¼þ
mysql.query contains "SELECT"
..
..
..
..
MySQL Protocol
Packet Length: 168
Packet Number: 0
Command
Command: Query (3)
State ......
/******************************************************************************/
/*
Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë
½Å±¾ÈÎÎñ:½¨Á¢4¸ö±í,Ìí¼ÓÖ÷¼ü,Íâ¼ü£¬²åÈëÊý¾Ý,½¨Á¢ÊÓͼ
ÔËÐл·¾³1:microsoft sqlserver 2000 ²éѯ·ÖÎöÆ÷
ÔËÐл·¾³2:mysql5.0 phpMyAdminÍøÒ³½çÃæ
ÔËÐл·¾³3:oracle 9i SQL*P ......
MySQL¼¯ÈºÊÇÒ»ÖÖÔÚÎÞ¹²Ïí¼Ü¹¹ÏµÍ³ÀïÓ¦ÓÃÄÚ´æÊý¾Ý¿â¼¯ÈºµÄ¼¼Êõ¡£ÕâÖÖÎÞ¹²ÏíµÄ¼Ü¹¹¿ÉÒÔʹµÃϵͳʹÓ÷dz£±ãÒ˵IJ¢ÇÒÊÇ×îСÅäÖõÄÓ²¼þ¡£
MySQL¼¯ÈºÊÇÒ»ÖÖ·Ö²¼Ê½Éè¼Æ£¬Ä¿±êÊÇÒª´ïµ½Ã»ÓÐÈκε¥µã¹ÊÕϵ㡣Òò´Ë£¬ÈκÎ×é³É²¿·Ö¶¼Ó¦¸ÃÓµÓÐ×Ô¼ºµÄÄÚ´æºÍ´ÅÅÌ¡£Èκι²Ïí´æ´¢·½°¸ÈçÍøÂç¹²Ïí£¬ÍøÂçÎļþϵͳºÍSANÉ豸ÊDz»ÍƼö»ò²»Ö ......
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£±¾ÎÄÖ÷Òª¶ÔMyISAM±í×ö±¸·Ý»Ö¸´¡£
±¸·Ý²ßÂÔÒ»£ºÖ±½Ó¿½±´Êý¾Ý¿âÎļþ£¨²»ÍƼö£©
±¸·Ý²ßÂÔ¶þ£ºÊ¹ÓÃmysqlhotcopy±¸·ÝÊý¾Ý¿â£¨ÍêÈ«±¸·Ý£¬ÊʺÏСÐÍÊý¾Ý¿â±¸·Ý£©
±¸·Ý²ßÂÔ ......