ʹÓÃMySQL connector/C++Á´½ÓMySQLÊý¾Ý¿â
Ê×ÏÈÈ¥MySQL¹ÙÍøÏÂÔØMySQL connector/C++
http://dev.mysql.com/downloads/connector/cpp/1.0.html
ÏÂÔصڶþ¸ö°ü£¬windows32λ·Ç°²×°°æ£¨¸öÈ˾õµÃÕâ¸ö°ü¸É¾»£©¡£Ä¿Ç°µÄ°æ±¾ÊÇConnector/C++ 1.0.5¡£
Windows (x86, 32-bit), ZIP Archive
(mysql-connector-c++-noinstall-1.0.5-win32.zip)
½«Õû¸ö°ü½âѹµ½ÏîÄ¿Îļþ¼ÐϵĵÄÔ´ÎļþĿ¼¡£Îļþ¼ÐÃû×ÖÌ«³¤£¬½«“mysql-connector-c++-noinstall-1.0.5-win32”¸ÄΪ“mysql”¡£
ÏÂÃæÒªÅäÖÃvs2008µÄ»·¾³¡£
1. ÏîÄ¿ÊôÐÔÒ³->C/C++->General->Additional Include Directories¡£½«mysql\includeĿ¼ºÍmysql\include\cppconnĿ¼Ìí¼Ó½øÈ¥¡£
2. ÏîÄ¿ÊôÐÔÒ³->Linker->General->Additional Library Directories¡£½«mysql\libĿ¼Ìí¼Ó½øÈ¥¡£
3. ÏîÄ¿ÊôÐÔÒ³->Linker->Input->Additional Dependencies¡£Ìí¼ÓÕâÁ½Ïîmysqlcppconn.lib£¬mysqlcppconn-static.lib£¨mysql\libĿ¼ÏµÄÁ½¸ö.libÎļþ£©
4. ½«mysql\libϵÄmysqlcppconn.dllÎļþ¸´ÖƵ½windows\system32Îļþ¼ÐÏ¡£
»·¾³ÅäÖÃÍê±Ï¡£
ÔÚÁ¬½ÓÊý¾Ý¿â֮ǰ£¬ÏȽ¨Á¢Ò»ÕÅ±í¡£
£¨ÆäʵÕâЩ¿ÉÒÔÔÚ´úÂëÖÐÍê³É£¬ÎÒÕâÑùÊÇΪÁËÈòâÊÔ´úÂ뾡¿ÉÄܼòÁ·Òײé´í£©
´ò¿ª¿ØÖÆ̨£¬ÊäÈëmysql -u root -p£¬ÊäÈëÃÜÂë¡£
²é¿´µ±Ç°ÒÑÓеÄÊý¾Ý¿â¡££¨SQLÓï¾äĩβ¼ÓÉÏ';'±íʾÁ¢¼´Ö´Ðе±Ç°Óï¾ä¡££©
mysql> show databases;
´´½¨Êý¾Ý¿â
mysql> create database test;
ʹÓÃÊý¾Ý¿â£¨Õâ¾ä²»Äܼӷֺţ©
mysql> use test
²é¿´ÒÑÓеıí
mysql> show tables;
´´½¨±í
mysql> create table testuser ( id INT, name CHAR(20));
²åÈëÊý¾Ý
mysql> insert into testuser(id, name) values(1001, 'google');
mysql> insert into testuser(id, name) values(1002, 'kingsoft');
mysql> insert into testuser(id, name) values(1003, 'firefox');
ÏÖÔÚÔÚC++ÖвéѯÕâЩÊý¾Ý
#include "stdafx.h"
#include <mysql_connection.h>
#include <mysql_driver.h>
#include <statement.h>
using namespace sql;
using namespace std;
void RunConnectMySQL()
{
mysql::MySQL_Driver *driver;
Connection *con;
Statement *state;
ResultSet *result;
// ³õʼ»¯Çý¶¯
driver = sql::mysql::get_mysql_driver_instance();
// ½¨Á¢Á´½Ó
con = driver->connect("tc
Ïà¹ØÎĵµ£º
mysql error number 2003
Can't connect to MySQL server xxx.xxx.xxx.xxx (10061)
ÔÚubuntu 9.04ÖÐĬÈÏ°²×°ÁËmysql£¬Ä¬ÈÏÖ»Äܱ¾µØ·ÃÎÊ£¬googleÁËһϣº
²ÉÓÃ
µÇ¼µ½MySQL·þÎñÆ÷¶Ë£¬ÔÚmysql¿âÏÂÖ´ÐÐ
grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';
¼´¿É
Èç¹ûÒªÉèÖÃÎ ......
×î½üÏëÔÚ·þÎñÆ÷ÉÏÊÔÊÔMySQL5.1µÄ·ÖÇø£¬ÓÚÊǾÍÏë×Å×°¸öMySQL5.1£¬¾¹ýÍ´¿àµÄÒ»¶Î¾Àúºó£¬ÖÕÓÚÕÒ¸öÏÂÃæ×°¸öºÜºÃµÄ½Ì³Ì£¬ÌûÉÏÀ´±¸Íü¡£
1¡¢MySQLÃâ°²×°°æ/¶þ½øÖÆ°æÈí¼þ£¬²»ÓñàÒ룬ÏÂÔصØÖ·£º
http://dev.mysql.com/downloads/
Îļþ¸ñʽ£ºMYSQL-VERSION-OS.tar.gz
2¡ ......
¹ØÓÚC++0x
Ô¤¼ÆÓÚÃ÷Äêµ×ÍƳöµÄбê×¼C++0x£¬Ëä˵ÒѽӽüÊչٽ׶Σ¬È´ÈÔÓÐÈô¸ÉÓдý½ÓÄɵÄÐÂÌá°¸±»Ìá³ö¡£ÓÈÆäÖµµÃ¹Ø×¢µÄÊÇ£¬Óëlambda±í´ïʽÒÔ¼°¾Ö²¿º¯ÊýÏà¹ØµÄÌá°¸“Unified Function Syntax£¨Í³Ò»µÄº¯ÊýÓï·¨£©”£¬¾¡¹Ü²»Êܱê׼ίԱ»á´ý¼û£¨Á½Äê¼äÀú¾ËÄ´ÎÑÓ³Ù±í¾ö£¬Á½´Î²»Óèͨ¹ý£©£¬ÈÔÈ»“ÍçÇ¿µØ”ÍƳöÁ ......
¡¡ÎÒÃÇ°ÑÏÂÔصÄÈý¸öÈí¼þ°ü·Åµ½/var/localĿ¼Ï£¨ÕâÊDZÊÕ߸öÈ˵ÄÏ°¹ß£©£¬ËüÃǶ¼ÊÇtar.gz°ü£¬¿ÉÒÔÓÃÃüÁîtar -xzpvf °üÃû£¬°ÑËüÃÇÔÚµ±Ç°Ä¿Â¼£¨/var/local/£©Öн⿪£º
cd /var/local
tar -xzpvf mysql-4.0.15.tar.gz
tar -xzpvf php-4.3.3.tar.gz
tar -xzpvf httpd-2.0.47.tar.gz
¡¡¡¡½â°üºó¿ÉÒÔ¿ªÊ¼½øÈëÕýʽ°²×°¡£ ......
mysqlÆô¶¯ºÍ¹Ø±ÕÔ¼ÊøµÄ·½·¨(FOREIGN_KEY_CHECKS)
2009-07-06 16:43
MySQL»¹ÔÊý¾Ý¿â£¬½ûÓúÍÆôÓÃÍâ¼üÔ¼ÊøµÄ·½·¨(FOREIGN_KEY_CHECKS)
ÓÐʱ»¹ÔÊý¾Ý¿âʱ£¬ÒòΪ±íÓÐÔ¼Êøµ¼ÖÂ40014´íÎ󣬿ÉÒÔͨ¹ý¹Ø±ÕÍâ¼üÔ¼Êø£¬»¹Ô³É¹¦Ê±ÔÙÆôÓÃ
½ûÓÃ
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
ÆôÓÃ
S ......