Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

Oracle³£ÓÃSQLÓï¾ä(PL/SQL developer¹¤¾ßϵÄ)

 ½¨±í
create table users(
id number(4) primary key,
username varchar2(10),
password varchar2(10)
)
²éѯ±í²¢½âËø±í(¼´¿ÉÒÔµã»÷ÊäÈë¿òÏÂÃæµÄ"Ëø"ͼ±ê¹¤¾ß, ¼´"Edit data")
select * from users for update
ɾ³ý±íÖжàÓàµÄÁÐ
alter table mobilephone drop column mobiletype
תÔØ
------------------- ......

SQLÓï¾ä´ó·¨

 SQLÓïÑÔÓÉÃüÁî¡¢×Ӿ䡢ÔËËãºÍ¼¯ºÏº¯ÊýµÈ¹¹³É¡£ÔÚSQLÖУ¬Êý¾Ý¶¨ÒåÓïÑÔDDL£¨ÓÃÀ´½¨Á¢¼°¶¨ÒåÊý¾Ý±í¡¢×Ö¶ÎÒÔ¼°Ë÷ÒýµÈÊý¾Ý¿â½á¹¹£©°üº¬µÄÃüÁîÓÐCREATE¡¢DROP¡¢ALTER£»Êý¾Ý²Ù×ÝÓïÑÔDML£¨ÓÃÀ´ÌṩÊý¾ÝµÄ²éѯ¡¢ÅÅÐòÒÔ¼°É¸Ñ¡Êý¾ÝµÈ¹¦ÄÜ£©°üº¬µÄÃüÁîÓÐSELECT¡¢INSERT¡¢UPDATE¡¢DELETE¡£
Ò»¡¢SQLÓï¾ä
£¨1£©Select ²éѯÓï¾ä
Óï ......

ORACLE PL/SQL ¼Ç¼(Record)ѧϰ±Ê¼Ç(¶þ)

¶þ¡¢ÒÔÐβεÄÐÎʽ¶¨ÒåºÍʹÓüǼ¡¢¶ÔÏóÀàÐÍ
ÔÚÓÃ×÷ÐÎʽ²ÎÊýʱ£¬¼Ç¼ÀàÐͺͶÔÏóÀàÐÍÓкܶàÏà֮ͬ´¦¡£ÔÚ½«ËüÃÇ×÷ΪÓαꡢº¯Êý»ò¹ý³ÌµÄÐÎʽ²ÎÊýÒÔÇ°£¬ÊÂÏȶ¼±ØÐ붨ÒåÒ»¸ö¼Ç¼ÀàÐÍ»òÕ߶ÔÏóÀàÐÍ¡£
ÈçÏÂÀýËùʾ£º
 
¼Ç¼
DECLARE

-- Define a record type.
TYPE individual_record IS RECORD
(individual_id ......

ORACLE PL/SQL ¼¯ºÏѧϰ±Ê¼Ç(¶þ)

Èý¡¢Ç¶Ì×±íµÄʹÓ÷½·¨
 
1¡¢½«Ç¶Ì×±í¶¨ÒåΪPL/SQLµÄ³ÌÐò¹¹Ôì¿é
 
TYPE type_name IS TABLE OF element_type[NOT NULL];
 
ÈçÏÂÀýËùʾ£º
DECLARE

-- Define a nested table of variable length strings.
TYPE card_table IS TABLE OF VARCHAR2(5 CHAR);

-- Declare and initialize a n ......

¾«ÃîSQLÓï¾äÊÕ¼¯

SQLÓï¾äÏÈǰдµÄʱºò£¬ºÜÈÝÒ×°ÑһЩÌØÊâµÄÓ÷¨Íü¼Ç£¬ÎÒÌØ´ËÕûÀíÁËÒ»ÏÂSQLÓï¾ä²Ù×÷£¬·½±ã×Ô¼ºÐ´SQLʱ·½±ãÒ»µã£¬ÏëÌùÉÏÀ´£¬Ò»Æð¿´¿´£¬Í¬Ê±Ï£Íû´ó¼ÒÄܹ²Í¬¶à¶àÌáÒâ¼û£¬Ò²¸øÎÒÁôһЩ¸üºÃµÄ¼Ñ¾ä£¬ÕûÀíÒ»·Ý¡¶¾«ÃîSQLËÙ²éÊֲᡷ£¬²»Áߴͽ̣¡
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ