ÄÄλÓкõÄÍÆ¼ö£¿
Qt?
QT¿ÉÒÔ£¬mysql×Ô´øµÄC¿âÒ²²»´í
mysql×Ô´øµÄlibmysql×ÔÈ»ÊÇÔÉú£¬µ«ÊÇÓÐÒ»¸ö·â×°ºÃµÄC++¿â¸üºÃ¡£
mysql++;
OTL;
ÕâÁ½ÌìÕýÔÚÑо¿Õâ¶«Î÷¡£
¶¼ÊDz»´íµÄ¶«Î÷¡£
¿É¿çƽ̨¡£
µ«ÊÇotl¶ÔmysqlµÄ´æ´¢¹ý³ÌÖ§³ÖµÄ²»ÊǺܺá£
ÄÄλÈÊÐÖÓÐmysql C APIµÄÏêϸ×ÊÁÏ£¿¹²ÏíһϰÉ
ÍøÉÏ ......
Ìáʾ´´½¨±äÁ¿µÄʱºòÓдíÎó
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
......
±íÈçÏÂ
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,#¹À¼Æ ......
±ÈÈçÏÂÃæµÄ´úÂë
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 ADO ·ÃÎÊ Êý¾Ý¿â
¹Ø×¢£¬
²»Ï²»¶ÉèÖÃÊý¾ÝÔ´£¬Âé·³£¬
¶øÇÒÈí¼þ°²×°ÔÚ±ðµÄ»ú×ÓµÄʱºò£¬ÊDz»ÊÇÒ²µÃÔÚÄÇ̨»ú×ÓÉÏÉèÖÃÊý¾ÝÔ´°¡£¬
ÒªÊÇÕâÑùµÄ»°£¬ÎÒÃÇÒªÈçºÎʵÏÖ×Ô¶¯ÉèÖÃÊý¾ÝÔ´£¬
Èç¹û²»Êǵϰ£¬ÓиÃÈ ......
SQL2000Á¬½ÓMySQL£¬´úÂëÈçÏ£º
-- 2¡¢½¨Á¢Á´½ÓÊý¾Ý¿â
EXEC sp_addlinkedserver @server = 'MySQLTest3 ', @srvproduct= 'MySQL ', @provider = 'MSDASQL', @datasrc = 'myTest2 '
GO
EX ......