Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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³£ÓÃÃüÁî


1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°ÈÕÆÚ
s ......

mysqlÊý¾Ý¿âÉè¼Æ

ÒýÑÔ
¡¡¡¡Êý¾Ý¿âµÄÉè¼Æ·¶Ê½ÊÇÊý¾Ý¿âÉè¼ÆËùÐèÒªÂú×ãµÄ¹æ·¶£¬Âú×ãÕâЩ¹æ·¶µÄÊý¾Ý¿âÊǼò½àµÄ¡¢½á¹¹Ã÷ÎúµÄ£¬Í¬Ê±£¬²»»á·¢Éú²åÈ루insert£©¡¢É¾³ý£¨delete£©ºÍ¸üУ¨update£©²Ù×÷Òì³£¡£·´Ö®ÔòÊÇÂÒÆß°ËÔ㣬²»½ö¸øÊý¾Ý¿âµÄ±à³ÌÈËÔ±ÖÆÔìÂé·³£¬¶øÇÒÃæÄ¿¿ÉÔ÷£¬¿ÉÄÜ´æ´¢ÁË´óÁ¿²»ÐèÒªµÄÈßÓàÐÅÏ¢¡£
¡¡¡¡Éè¼Æ·¶Ê½ÊDz»ÊǺÜÄѶ®ÄØ£¿·ÇÒ² ......

¶ÔmysqlµÄorder by¼°limitÓÅ»¯ÒªÊÊÊý¾ÝÇé¿ö¶ø¶¨

ÒÔÏÂÕâÆªÎÄÕÂÂÛÊöÉÏÔÚʲôÇé¿öÏÂ×Ó²éѯ±ÈÒ»°ãµÄÄÚÁ¬½Ó²éѯ¸ü¼Ó¿ìËÙ
http://www.mysqlperformanceblog.com/2010/03/18/when-the-subselect-runs-faster/
ÒÔÏÂÊÇÎÒ¶ÔmysqlµÄorder byºÍlimitÓÅ»¯µÄ½¨Ò飬ҪÊʱíµÄÊý¾ÝÁ¿ºÍÓÃÀ´¹ýÂËÁеÄΨһֵµÄ¸öÊý¶ø¶¨
£¨1£©where×Ó¾äÖÐÓÃÀ´¹ýÂ˽á¹ûµÄÁÐËùÔÚË÷ÒýµÄcadinalityºÜС£¬¼´ÓÃÏà¹Ø ......

windows7ϰ²×°apache+php+mysqlÎÊÌâ¼Ç¼

×î½üÐÂÂòÁ˸öµçÄÔ£¬ÏµÍ³ÊÇwindows7£¬window7ÔÚ½çÃæ£¬¹¦ÄÜ·½Ã涼ͦÈÃÈËÂúÒâµÄ£¬¸Ð¾õºÜˬ£¬²»Ë¬µÄÊÇÓÖÒªÖØÐ°²×°»·¾³ÁË¡£
ËùÓÐÈí¼þ¾ù°²×°ÔÚF:\server\ÏÂ
apacheĿ¼£ºF:\server\apache2.2
phpĿ¼£ºF:\server\php
msyqlĿ¼£ºF:\server\mysql
Ò»¡¢°²×°apache
°²×°apacheµÄ°æ±¾ÊÇ£ºhttpd-2.2.15-win32-x86-no_ssl.msi
° ......

£Ûת£ÝmysqlÐ޸ıí½á¹¹alter


 
£Ûת×Ô£Ýhttp://waryist.javaeye.com/blog/104739
ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]
alter_specification:
        ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
  or    ADD ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ