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

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Ôöɾ¸Ä²é

 ²åÈëÒ»Ìõ¼Ç¼: 
          mysql> insert into table_name (column_name1,column_name2,.) values (value1,value2,..); 
¸üÐÂÒ»Ìõ¼Ç¼£º 
          mysql> update tbl_name 
s ......

¼òµ¥MysqlÃüÁî

MySql »ù±¾²Ù×÷
Ò»¡¢»ù´¡
1£º µÇ½£ºmysql –u  username –p <»Ø³µ¡· È»ºóÊäÈëÃÜÂë
2£º²é¿´Êý¾Ý¿â£ºshow databases£»
3£ºÊ¹ÓÃÊý¾Ý¿âuse databasename;
4:  ³£¿´Êý¾Ý¿â±í show tables£» µ«ÊÇÇ°ÌáÊÇÄãÒѾ­Ê¹ÓÃÁËuse ÃüÁÈç¹ûûÓÐ µÄ»°¿ÉÒÔʹÓà show tables from databasename £»
5£º ²é¿´Êý ......

ORACLE PL/SQL ¼Ç¼(Record)ѧϰ±Ê¼Ç(Ò»)

ÔÚPL/SQL³ÌÐòÉè¼ÆÖУ¬ÓÐÈýÖÖ¶¨Òå¼Ç¼ÀàÐ͵ķ½·¨£ºÒ»ÖÖÊÇʹÓÃ%ROWTYPEÊôÐÔ£»ÁíÒ»ÖÖÊÇÔÚPL/SQL³ÌÐòµÄÉùÃ÷²¿·ÖÏÔʾ¶¨Òå¼Ç¼ÀàÐÍ£»×îºóÒ»ÖÖ·½·¨Êǽ«¼Ç¼ÀàÐͶ¨ÒåΪÊý¾Ý¿â½á¹¹»ò¶ÔÏóÀàÐÍ¡£
ÎÒÏȼòµ¥µÄ½éÉÜÒ»¸öÏÂÃæÒªÓõ½µÄ±íµÄ½á¹¹£¨ºÚÌå±êÃ÷µÄ×Ö¶ÎΪÖ÷¼ü£©£º
INDIVIDUALS±í
 
INDIVIDUAL ID
FIRST NAME
MIDDLE_INITI ......

ORACLE PL/SQL ¼¯ºÏAPI ×ܽá

ORACLE 10GµÄ¼¯ºÏAPI
 
¼¯ºÏAPI·½·¨×îÔçÊÇÔÚORACLE 8IÖÐÒýÈëµÄ¡£¼¯ºÏAPIÌṩÁ˼ò»¯·ÃÎʼ¯ºÏµÄ·½·¨¡£ÔÚORACLE 10GÒÔÇ°£¬ÕâЩ·½·¨È·Êµ¼ò»¯Á˶Լ¯ºÏµÄ·ÃÎÊ¡£µ«ÊÇ£¬²¢²»ÊÇ·ÇÒªÇóÕÆÎÕÕâЩ·½·¨²»¿É¡£´ÓORACLE 9IµÄINDEX-BY±íµ½ORACLE 10GµÄÁªºÏÊý×éµÄת»»£¬Ê¹ËüÃdzÉΪ±ØÐëÕÆÎյķ½·¨¡£
 
ÏÂÃæÊÇÎÒ´ÓÊéÉÏժ¼ÏµÄһР......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ