SQL Explorer QT4.5 ÅäÖÃMySQL ODBCºÍMySQLÇý¶¯
QT DataBase SQL Explorer
1¡¢°²×°MySQLµ½¹Ù·½ÍøÕ¾ÏÂÔØMySQLÊý¾Ý¿â£¬·Ç°²×°°æ£¬Ö±½ÓÔËÐÐmysqld½ø³Ìǰ̨µÄ
2¡¢Ìí¼Óϵͳ»·¾³±äÁ¿£¬Path+=':\mysql\bin'µÄpath£¬ÔÙÔÚ¿ªÊ¼ÔËÐУ¬CMD->mysql -uroot µÇ¼µ½mySQLÊý¾Ý¿â
Default passwordûÓеģ¬ÓеĻ° mysql -uroot -pÊäÈëÃÜÂ룻ÍøÂçµÇ¼£ºmysql -h ip -u user -p password;
3¡¢´´½¨±í»òÊý¾Ý¿â£¬ÓÃdefault Êý¾Ý¿âtest OR mysql¾ÍÐÐÁË¡£
4. ½¨±íʱҪעÒâÉèÖÃ×Ö·û¼¯£¬GBK,utf8,gb2312µÈ£»ÈçÏÂ:
---------------------------
CREATE TABLE BOOKS
(
bkid int not null auto_increment,
bkname varchar(24) CHARACTER SET gbk,
bkdate datetime,
PRIMARY KEY (bkid) --Ö÷¼ü
);
select * from BOOKS;
insert into BOOKS(bkname, bkdate) values('linux±à³ÌµÚÒ»°æ', '2009-05-25');
ÔÚCmd mysqlÏÂÈç¹ûÏÔʾÂÒÂ룬ÔòÒª ÉèÖà һ¸öµ±Ç°×Ö·û¼¯£¬
-> set names 'gbk';
5¡¢°²×°ODBC for win32,¿ÉÒÔµ½¹Ù·½ÍøÕ¾ÉÏÏÂÔØ·Ç°²×°°æ£¬Ö´ËüµÄInstall.bat°²×°ÏµÍ³ODBCÇý¶¯£¬È»ºóÔËÐÐODBCad32.exe ÅäÖÃÓû§ODBC dns;
-------------------------------------------------
6¡¢´ò¿ªdelphiʹÓÃADOÁ¬½ÓÅäÖúõÄODBC mysql µÄdns£¬Á¬½ÓOK£»
----------------------------------------------------------------
7¡¢QT4.5±È½ÏÂé·³£¬¿ÉÒÔʹmysql Çý¶¯»òODBCÁ¬½ÓMysqlÊý¾Ý¿â¡£
´¦ÀíÖÐÎÄ·½·¨£ºhttp://www.qtcn.org/bbs/read.php?tid=4229
8¡¢QT4.5±àÒëMySQLÇý¶¯
A. ÎÒµÄQT°²×°Ä¿Â¼ÔÚC:\Qt0904\qt¡¢Mysql°²×°ÔÚC:\mysql5140;
B. ´ò¿ªMySQL sqldrivers Çý¶¯²å¼þ¹¤³ÌÎļþÔÚ°²×°µÄQTĿ¼ÀÈçÎÒµÄ C:\Qt0904\qt\src\plugins\sqldrivers\mysqlÕâÀï;
C. Build: »á³öÏÖMysql.hµÄ°üº¬ÎļþÕÒ²»µ½£ºÖ±½Ó¼ÓÈëMysqlµÄincludeĿ¼INCLUDEPATH+=C:\MySQL\includeµ½¹¤³ÌÎļþÖÐ;
»òÖ±½Ó¼Óµ½Ädzö´íµÄÎļþÍ·ÉÏÈ¥: #include <C:\mysql5140\include\mysql.h>
D. ½ÓÏÂÀ´±àÒë»á³öÏÖERROR: cannot find -llibmysql
¼ÓÈ룺LIBS=C:\mysql5140\lib\opt\libmysql.lib Ò²¾ÍÊÇ°²×°Mysql Ŀ¼µÄµØ·½;
E. MYSQL Çý¶¯DLLÊä³öĿ¼£º´ÓC:\Qt0904\qt\s
Ïà¹ØÎĵµ£º
²åÈëÒ»Ìõ¼Ç¼:
mysql> insert into table_name (column_name1,column_name2,.) values (value1,value2,..);
¸üÐÂÒ»Ìõ¼Ç¼£º
mysql> update tbl_name
s ......
MySql »ù±¾²Ù×÷
Ò»¡¢»ù´¡
1£º µÇ½£ºmysql –u username –p <»Ø³µ¡· È»ºóÊäÈëÃÜÂë
2£º²é¿´Êý¾Ý¿â£ºshow databases£»
3£ºÊ¹ÓÃÊý¾Ý¿âuse databasename;
4: ³£¿´Êý¾Ý¿â±í show tables£» µ«ÊÇÇ°ÌáÊÇÄãÒѾʹÓÃÁËuse ÃüÁÈç¹ûûÓÐ µÄ»°¿ÉÒÔʹÓà show tables from databasename £»
5£º ²é¿´Êý ......
ÔÚPL/SQL³ÌÐòÉè¼ÆÖУ¬ÓÐÈýÖÖ¶¨Òå¼Ç¼ÀàÐ͵ķ½·¨£ºÒ»ÖÖÊÇʹÓÃ%ROWTYPEÊôÐÔ£»ÁíÒ»ÖÖÊÇÔÚPL/SQL³ÌÐòµÄÉùÃ÷²¿·ÖÏÔʾ¶¨Òå¼Ç¼ÀàÐÍ£»×îºóÒ»ÖÖ·½·¨Êǽ«¼Ç¼ÀàÐͶ¨ÒåΪÊý¾Ý¿â½á¹¹»ò¶ÔÏóÀàÐÍ¡£
ÎÒÏȼòµ¥µÄ½éÉÜÒ»¸öÏÂÃæÒªÓõ½µÄ±íµÄ½á¹¹£¨ºÚÌå±êÃ÷µÄ×Ö¶ÎΪÖ÷¼ü£©£º
INDIVIDUALS±í
INDIVIDUAL ID
FIRST NAME
MIDDLE_INITI ......
ORACLE 10GµÄ¼¯ºÏAPI
¼¯ºÏAPI·½·¨×îÔçÊÇÔÚORACLE 8IÖÐÒýÈëµÄ¡£¼¯ºÏAPIÌṩÁ˼ò»¯·ÃÎʼ¯ºÏµÄ·½·¨¡£ÔÚORACLE 10GÒÔÇ°£¬ÕâЩ·½·¨È·Êµ¼ò»¯Á˶Լ¯ºÏµÄ·ÃÎÊ¡£µ«ÊÇ£¬²¢²»ÊÇ·ÇÒªÇóÕÆÎÕÕâЩ·½·¨²»¿É¡£´ÓORACLE 9IµÄINDEX-BY±íµ½ORACLE 10GµÄÁªºÏÊý×éµÄת»»£¬Ê¹ËüÃdzÉΪ±ØÐëÕÆÎյķ½·¨¡£
ÏÂÃæÊÇÎÒ´ÓÊéÉÏժ¼ÏµÄһР......