Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ö÷Á÷Êý¾Ý¿â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Æô¶¯Óë»ù±¾ÅäÖÃ

MySQLÆô¶¯Óë»ù±¾ÅäÖÃ
MySQLÊÇÒ»¸öСÐ͹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ¡£¿ª·¢ÕßΪÈðµäMySQLAB¹«Ë¾£¬ÔÚ2008Äê1ÔÂ16ºÅ±»Sun¹«Ë¾10ÒÚÃÀÔªÊÕ¹º¡£MySQL±»¹ã·ºµØÓ¦ÓÃÔÚInternetµÄÖÐСÐÍÍøÕ¾ÖУ¬ÓÉÓÚÆäÌå»ýС¡¢Ëٶȿ졢×ÜÌåÓµÓгɱ¾µÍ£¬ÓÈÆäÊÇ¿ª·ÅÔ´ÂëÕâÒ»ÌØµã£¬Ðí¶àÖÐСÐÍÍøÕ¾ÎªÁ˽µµÍÍøÕ¾×ÜÌåÓµÓгɱ¾¶øÑ¡ÔñÁËMySQL×÷ÎªÍøÕ¾Êý¾Ý¿â¡£
MySQL ......

MySQL NDB 6.3.20¼¯Èº°²×°

 
MySQL¼¯ÈºÊÇÒ»ÖÖÔÚÎÞ¹²Ïí¼Ü¹¹ÏµÍ³ÀïÓ¦ÓÃÄÚ´æÊý¾Ý¿â¼¯ÈºµÄ¼¼Êõ¡£ÕâÖÖÎÞ¹²ÏíµÄ¼Ü¹¹¿ÉÒÔʹµÃϵͳʹÓ÷dz£±ãÒ˵IJ¢ÇÒÊÇ×îСÅäÖõÄÓ²¼þ¡£
MySQL¼¯ÈºÊÇÒ»ÖÖ·Ö²¼Ê½Éè¼Æ£¬Ä¿±êÊÇÒª´ïµ½Ã»ÓÐÈκε¥µã¹ÊÕϵ㡣Òò´Ë£¬ÈκÎ×é³É²¿·Ö¶¼Ó¦¸ÃÓµÓÐ×Ô¼ºµÄÄÚ´æºÍ´ÅÅÌ¡£Èκι²Ïí´æ´¢·½°¸ÈçÍøÂç¹²Ïí£¬ÍøÂçÎļþϵͳºÍSANÉ豸ÊDz»ÍƼö»ò²»Ö ......

Ò»¸öMYSQLµÄСÎÊÌâ

Ò»ÏÂÊÇÒ»¸öSQLµÄСÎÊÌ⣬À§ÈÅÁË3·ÖÖÓ£¬Ð´ÏÂÀ´¼Ç¼һÏ¡£
Êý¾Ý¿âÊÇMYSQL 5, ±íµÄ½á¹¹ºÜ¼òµ¥, ¾ÍÒ»¸ö×Ö¶ÎÊÇabc£¬ÕûÐÍ¡£
Ò»ÏÂÓï¾äÔËÐеĽá¹ûÊÇÒ»ÑùµÄ¡£×Ô¼º²»ÁôÉñ£¬µ¼ÖÂÀ§ÈÅÁË3·ÖÖÓ¡£
select * from table1 from abc = '123'
select * from table1 from abc = '123_1'
ÒÔÉÏÓï¾äÔ­À´ÊDzéÕÒÊÇ·ñÊý¾Ý´æÔÚ£¬½á¹û123_1ºÍ1 ......

¹ØÓÚmysql¹Ø¼ü×Ö

×òÌìΪһ¸öÏîÄ¿×öÊý¾Ý¿â£¬ÏîÄ¿Éæ¼°µ½¶©µ¥£¬ÔÚÉè¼ÆÊý¾Ý¿â×ÖµäµÄʱºò ¾Í°ÑÕâ¸ö±íÃû¶¨ÎªÁËorder£¬½¨±íµÄʱºòÔõô½¨¶¼²»¶Ô£¬ÌáʾÊDZíÃû¸½½ü³öÏÖÎÊÌ⣬µ±Ê±¾õµÃ²»¿ÉÄܰ¡ Ò²ÐíÊÇ×Ö¶ÎÀàÐÍÄĶù³öÁËÎÊÌ⣬²éÁ˺þã¬ÊÔÁ˺ü¸´Î£¬»¹ÊDz»ÐУ¬ºóÀ´Í»È»»ÐÈ»´óÎò£¬order byÊÇÅÅÐòÓï¾ä£¬order¿Ï¶¨ÊDZ£Áô×Ö£¬Ôõô¿ÉÄÜ×ö±íÃûÄØ¡£¡£¡£Á¢¼´°Ñ±í ......

MySQLÉúƧ×ÖÎÞ·¨ÏÔʾ½â¾ö·½·¨

µÚÒ»´Î²ÉÓÃMySQL×÷ΪҵÎñÓ¦ÓõÄÊý¾Ý¿â£¬ÓÉÓÚ¾­Ñé²»¹»·á¸»£¬ÔÚ°²×°Êý¾Ý¿âµÄʱºòÑ¡ÔñÁËGB2312±àÂë¡£
ÆðÏÈÓõÄÒ²ËãµÃÐÄÓ¦ÊÖ£¬È»¶øºóÐø·¢ÏÖÁËÉúƧ×Ö²»ÄÜÏÔʾµÄÇé¿ö£¬°ÑÎÒ¸ãµÃ½¹Í·Àö¾­¹ýºÃ¼¸ÌìµÄÃþË÷¡¢
ѧϰ£¬ÖÕÓÚ°ÑÎÊÌâ½â¾öÁË¡£¼ÇϽâ¾ö²½Ö裬Óë¸úÎÒÒ»ÑùµÄÐÂÊÖ·ÖÏí¡£
²½ÖèÒ»£º ·ÖÎö³öÏÖÂÒÂëµÄÔ­Òò
ÓÉÓÚGB2312×Ö·û¼¯Ö»ÊÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ