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

VC ODBC Á¬½Ó MYSQL δËì

#include <WinSock2.h>
#include <Windows.h>
#include <tchar.h>

#include <mysql.h>

#include <sql.h>
#include <sqlext.h>
#include <sqltypes.h>

#include <iostream>

using namespace std;

int _tmain(int argc, _TCHAR* argv[])
{
SQLHENV sql_hEvn = 0;
SQLHDBC sql_hDBC = 0;
SQLHSTMT sql_hStmt = 0;

SQLWCHAR szDNS[1024] = {0};
SQLSMALLINT nSize = 0;

SQLRETURN sqlRet = 
SQLAllocHandle(SQL_HANDLE_ENV,
SQL_NULL_HANDLE,
&sql_hEvn);
sqlRet = 
SQLSetEnvAttr(sql_hEvn,
SQL_ATTR_ODBC_VERSION,
(void*)SQL_OV_ODBC3,
0);
sqlRet = 
SQLAllocHandle(SQL_HANDLE_DBC,
sql_hEvn,
&sql_hDBC);

// if 0 - use SQLDriverConnect
// if 1 - use SQLConnect
#if 1
sqlRet = 
SQLConnect(sql_hDBC,
(SQLWCHAR*)"wzdftpd",
14,//SQL_NTS,
(SQLWCHAR*)"root",
8,//SQL_NTS,
(SQLWCHAR*)"root",
8//SQL_NTS
);

#else
sqlRet =
SQLDriverConnect(sql_hDBC,
0,
(SQLWCHAR*)"DSN=wzdftpd;UID=root;PWD=root;",
SQL_NTS,
szDNS,
1024,
&nSize,
SQL_DRIVER_COMPLETE);
#endif

if (


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

MysqlЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

±í
CREATE TABLE `ch1` (
  `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `no` int(10) unsigned DEFAULT NULL,
  `dtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......

MySql Hibernate ²éѯÓï¾äÎÊÌâ - Java / Java EE


hql = "select left('adfsadfasgsadgagsda',2)";
¾ÍÓÃÕâ¾äÓï¾ä ÔÚÊý¾Ý¿âÖÐÖ´ÐР
 µ«ÊÇÔÚjava´úÂëÖÐ ÓÃHibernate Ö´ÐÐ ¾Í²»ÄÜÖ´ÐÐ £¿
  ÕâÊÇʲôÎÊÌ⣡£¡£¡

ÎÒÒѾ­ÖªµÀÁË£¡
&n ......

sqlÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÔõôÑù²éѯÁ¬½Ó2¸ö±íÖ®ºó µÃ³öµÄбí
ÀýÈç A±í£º·¢¼þÈËID Óʼþ±àºÅ ÓʼþÄÚÈÝ ÊÕ¼þÈËID ·¢¼þʱ¼ä
  B±í£ºÊÕ¼þÈËID Óʼþ±àºÅ ÊÕ¼þʱ¼ä
  Ê×ÏÈ×öA BµÄÁ¬½Ó²éѯ ¼´ Óʼþ±àºÅÏàµÈ
  ²é³ö£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ