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
Ïà¹ØÎĵµ£º
½¨±í
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ÖУ¬Êý¾Ý¶¨ÒåÓïÑÔDDL£¨ÓÃÀ´½¨Á¢¼°¶¨ÒåÊý¾Ý±í¡¢×Ö¶ÎÒÔ¼°Ë÷ÒýµÈÊý¾Ý¿â½á¹¹£©°üº¬µÄÃüÁîÓÐCREATE¡¢DROP¡¢ALTER£»Êý¾Ý²Ù×ÝÓïÑÔDML£¨ÓÃÀ´ÌṩÊý¾ÝµÄ²éѯ¡¢ÅÅÐòÒÔ¼°É¸Ñ¡Êý¾ÝµÈ¹¦ÄÜ£©°üº¬µÄÃüÁîÓÐSELECT¡¢INSERT¡¢UPDATE¡¢DELETE¡£
Ò»¡¢SQLÓï¾ä
£¨1£©Select ²éѯÓï¾ä
Óï ......
¶þ¡¢ÒÔÐβεÄÐÎʽ¶¨ÒåºÍʹÓüǼ¡¢¶ÔÏóÀàÐÍ
ÔÚÓÃ×÷ÐÎʽ²ÎÊýʱ£¬¼Ç¼ÀàÐͺͶÔÏóÀàÐÍÓкܶàÏà֮ͬ´¦¡£ÔÚ½«ËüÃÇ×÷ΪÓαꡢº¯Êý»ò¹ý³ÌµÄÐÎʽ²ÎÊýÒÔÇ°£¬ÊÂÏȶ¼±ØÐ붨ÒåÒ»¸ö¼Ç¼ÀàÐÍ»òÕ߶ÔÏóÀàÐÍ¡£
ÈçÏÂÀýËùʾ£º
¼Ç¼
DECLARE
-- Define a record type.
TYPE individual_record IS RECORD
(individual_id ......
Èý¡¢Ç¶Ì×±íµÄʹÓ÷½·¨
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ËÙ²éÊֲᡷ£¬²»Áߴͽ̣¡
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾ ......