Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

ÍÆ¼öһϲÙ×÷mysqlÊý¾Ý¿âµÄC++¿â

ÄÄλÓкõÄÍÆ¼ö£¿
Qt?

QT¿ÉÒÔ£¬mysql×Ô´øµÄC¿âÒ²²»´í

mysql×Ô´øµÄlibmysql×ÔÈ»ÊÇÔ­Éú£¬µ«ÊÇÓÐÒ»¸ö·â×°ºÃµÄC++¿â¸üºÃ¡£

mysql++;
OTL;
ÕâÁ½ÌìÕýÔÚÑо¿Õâ¶«Î÷¡£
¶¼ÊDz»´íµÄ¶«Î÷¡£
¿É¿çƽ̨¡£

µ«ÊÇotl¶ÔmysqlµÄ´æ´¢¹ý³ÌÖ§³ÖµÄ²»ÊǺܺá£

ÄÄλÈÊÐÖÓÐmysql C APIµÄÏêϸ×ÊÁÏ£¿¹²ÏíһϰÉ

ÍøÉÏ ......

MYSQL´´½¨´æ´¢¹ý³ÌµÄÎÊÌâ(¼±~~~)

Ìáʾ´´½¨±äÁ¿µÄʱºòÓдíÎó
SQL code:

drop procedure if exists proc_novelSearch;
create procedure proc_novelSearch(
in searchType varchar(20), -- ËÑË÷ÀàÐÍ
in searchValue varchar(40), -- ËÑË÷Öµ
in pageItem int, -- Ò³Ïî
in pageIndex int -- Ò³Âë
)
begin
......

mysqlÈçºÎ»ñÈ¡±íÖеÄ×Ô¶¯µÝÔö×ֶεÄÖµ

±íÈçÏÂ

create table goods (
id int primary key auto_increment,
categoryid int references category(id),
username varchar(40) references user(username),
gname varchar(40),#ÉÌÆ·Ãû³Æ
gdegree varchar(10),#¼¸³ÉУ¬10´ú±íȫУ¬9´ú±í¾Å³ÉУ¬ÒÔ´ËÀàÍÆ£¬0´ú±í·ÏÆ·
gprice int,#¹À¼Æ ......

Ïëд¸ömysqlµÄÅú´¦ÀíÎļþ°ï¿´¿´Ôõôд

±ÈÈçÏÂÃæµÄ´úÂë
d:
mysql -u zhongda -p
show slave status\G;
±£´æ³É.batµÄÎļþ
ÔËÐкó Ò»ÊäÈëÃÜÂë¾Í²»Ö´ÐÐ
show slave status\G;
ÎÒÏëÊäÍêÃÜÂëºó¼ÌÐøÖ´ÐÐ
show slave status\G;

ÒªÔõôд

cmd주
D:\>mysql -u zhongda -p -e "show slave status\G" > e:\test.ba ......

vc++Á¬½ÓMYSQLÊý¾Ý¿â£¬Ê¹ÓÃADO·½·¨

vc++Á¬½ÓMYSQLÊý¾Ý¿â£¬ÓÃADO·½·¨ÓÐûÓÐÒ»ÖÖ·½·¨²»ÓÃÉèÖÃÊý¾ÝÔ´£¿ÔõôŪ£¿Ð»Ð»¸÷λÁË
ÍøÉϽ̳̣¬ºÜ¶àµÄ £¬
VC ADO ·ÃÎÊ Êý¾Ý¿â

¹Ø×¢£¬
²»Ï²»¶ÉèÖÃÊý¾ÝÔ´£¬Âé·³£¬
¶øÇÒÈí¼þ°²×°ÔÚ±ðµÄ»ú×ÓµÄʱºò£¬ÊDz»ÊÇÒ²µÃÔÚÄÇ̨»ú×ÓÉÏÉèÖÃÊý¾ÝÔ´°¡£¬
ÒªÊÇÕâÑùµÄ»°£¬ÎÒÃÇÒªÈçºÎʵÏÖ×Ô¶¯ÉèÖÃÊý¾ÝÔ´£¬
Èç¹û²»Êǵϰ£¬ÓиÃÈ ......

SQL2000Á¬½Óµ½MySQLµÄÎÊÌ⣬¼±£¡

SQL2000Á¬½ÓMySQL£¬´úÂëÈçÏ£º
-- 2¡¢½¨Á¢Á´½ÓÊý¾Ý¿â
EXEC  sp_addlinkedserver    @server  =  'MySQLTest3 ',  @srvproduct= 'MySQL ',  @provider  =  'MSDASQL',  @datasrc  =  'myTest2 '
GO
EX ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [3661] [3662] [3663] [3664] 3665 [3666] [3667] [3668] [3669] [3670]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ