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

¡¾×ª¡¿mysqlÏÂÈçºÎÖ´ÐÐsql½Å±¾

Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆÎªmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼´¿É.
1.±àдsql½Å±¾,¼ÙÉèÄÚÈÝÈçÏÂ:
  create database dearabao;
 
use dearabao;
  create table niuzi (name varchar(20));
  ±£´æ½Å±¾Îļþ,¼ÙÉèÎÒ°ÑËü±£´æÔÚFÅ̵Ähello
worldĿ¼ÏÂ,ÓÚÊǸÃÎļþµÄ·¾¶Îª:F:\hello world\niuzi.sql
2.Ö´ÐÐsql½Å±¾,¿ÉÒÔÓÐ2ÖÖ·½·¨:
 
µÚÒ»ÖÖ·½·¨:
 ÔÚÃüÁîÐÐÏÂ(δÁ¬½ÓÊý¾Ý¿â),ÊäÈë mysql -h localhost -u root -p123456 <
F:\hello world\niuzi.sql (×¢Òâ·¾¶²»ÓüÓÒýºÅµÄ!!) »Ø³µ¼´¿É.
  µÚ¶þÖÖ·½·¨:
 ÔÚÃüÁîÐÐÏÂ(ÒÑÁ¬½ÓÊý
¾Ý¿â,´ËʱµÄÌáʾ·ûΪ mysql> ),ÊäÈë source F:\hello world\niuzi.sql (×¢Òâ·¾¶²»ÓüÓÒýºÅµÄ)
»òÕß \. F:\hello world\niuzi.sql (×¢Òâ·¾¶²»ÓüÓÒýºÅµÄ) »Ø³µ¼´¿É
Ô­ÎĵØÖ·£ºhttp://www.cppblog.com/true/archive/2007/07/17/28174.html


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

Apache+php+mysqlÔÚwindowsϵݲװÓëÅäÖÃͼ½â

ÏÈ×¼±¸ºÃÈí¼þ£º
·Ö±ðÔÚApache¹Ù·½¡¢php¹Ù·½¡¢mysql¹Ù·½ÏÂÔØ×îлòÎȶ¨°æ±¾
Ò»¡¢°²×°Apache£¬ÅäÖóɹ¦Ò»¸öÆÕÍ¨ÍøÕ¾·þÎñÆ÷
ÔËÐÐÏÂÔØºÃµÄ“apache_2.0.55-win32-x86-no_ssl.msi”£¬³öÏÖÈçϽçÃæ£º
 
 
³öÏÖApache HTTP Server 2.0.55µÄ°²×°Ïòµ¼½çÃæ£¬µã“Next”¼ÌÐø
 
 
È·È ......

mysqlÍøÕ¾ÇÄÈ»¸Ä°æ£¬sun½«³ÉΪһ´úÈ˵ļÇÒä¡£

½ñÌìµ½mysqlÍøÕ¾¿´¿´·¢ÏÖûÓÐÁËsun LOGO£¬Ò²ÕÒ²»µ½mysql downloadsÏÂÔØÁ´½Ó
ÒªÊÖ¹¤´òÈëhttp://dev.mysql.com²ÅÐУ¬²»½ûÉÁ¹ýһ˿Á¹Ò⣬ÒÔǰ¼á³ÖʹÓÃmysqlÏÖÔÚ»¹Òª¼á³ÖÂð£¬
ÒÔǰÐÄÀïÒ»Ö±ÔÚÏëÒ»Ö±»áʹÓÃmysqlµÄ£¬µ«ÊÇÏÖÔڸоõµ½ºÜʧÍû£¬´ìÕÛ£¬½¹ÂÇ£¬²»ÖªÒÔºó»áÔõôÑù
×Ô¼º¼¸ÄêÀ´Ò»Ö±Ê¹ÓÃLAMP×éºÏ£¬ÖªÊ¶¶¼ÊÇÊÇÎ§ÈÆ×ÅÕâ¸ö×éºÏ ......

Oracle SQLʵÀý

1¡£select * from a where a.rowid=(select min(b.rowid) from b where a.id=b.id);
create test1(
nflowid number primary key, 
ndocid number,
drecvdate date);
insert into test1 values (1, 12301, sysdate) ;
insert into test1 values (2, 12301, sysdate);
select * from test1 order by drecvdate:
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ