¡¾×ª¡¿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
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......
ÏÈ×¼±¸ºÃÈí¼þ£º
·Ö±ðÔÚApache¹Ù·½¡¢php¹Ù·½¡¢mysql¹Ù·½ÏÂÔØ×îлòÎȶ¨°æ±¾
Ò»¡¢°²×°Apache£¬ÅäÖóɹ¦Ò»¸öÆÕÍ¨ÍøÕ¾·þÎñÆ÷
ÔËÐÐÏÂÔØºÃµÄ“apache_2.0.55-win32-x86-no_ssl.msi”£¬³öÏÖÈçϽçÃæ£º
³öÏÖApache HTTP Server 2.0.55µÄ°²×°Ïòµ¼½çÃæ£¬µã“Next”¼ÌÐø
È·È ......
½ñÌìµ½mysqlÍøÕ¾¿´¿´·¢ÏÖûÓÐÁËsun LOGO£¬Ò²ÕÒ²»µ½mysql downloadsÏÂÔØÁ´½Ó
ÒªÊÖ¹¤´òÈëhttp://dev.mysql.com²ÅÐУ¬²»½ûÉÁ¹ýһ˿Á¹Ò⣬ÒÔǰ¼á³ÖʹÓÃmysqlÏÖÔÚ»¹Òª¼á³ÖÂð£¬
ÒÔǰÐÄÀïÒ»Ö±ÔÚÏëÒ»Ö±»áʹÓÃmysqlµÄ£¬µ«ÊÇÏÖÔڸоõµ½ºÜʧÍû£¬´ìÕÛ£¬½¹ÂÇ£¬²»ÖªÒÔºó»áÔõôÑù
×Ô¼º¼¸ÄêÀ´Ò»Ö±Ê¹ÓÃLAMP×éºÏ£¬ÖªÊ¶¶¼ÊÇÊÇÎ§ÈÆ×ÅÕâ¸ö×éºÏ ......
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:
......