mysql±à³ÌÖеÄÎÊÌâ¡£¡£¡£¡£¡£¡£¡£¡£
СµÜ³õѧMySQL ±à³Ì ÓÃMySQLÖÐÌṩµÄC API д¸ö¼òµ¥µÄÁ¬½Óµ½mysqlserver µÄÎÊÌâ ´úÂëÊÇ´Ómysql°ïÖúÊÖ²áÀï ÕÒÀ´µÄ
½éÉܵÄmysql_real_connect Õâ¸öº¯ÊýµÄ ´úÂëÈçÏÂ
C/C++ code:
#include <mysql.h>
#include <stdio.h>
int main()
{
MYSQL mysql;
mysql_init(&mysql);
mysql_options(&mysql,MYSQL_READ_DEFAULT_GROUP,"your_prog_name");
if (!mysql_real_connect(&mysql,"host","user","passwd","database",0,NULL,0))
{
fprintf(stderr, "Failed to connect to database: Error: %s\n",mysql_error(&mysql));
}
}
³öÏֵĴíÎó ºÜ¶à ´íÎóÈçÏÂ
mysql server 6.0\include\mysql_com.h(268) : error C2061: syntax error : identifier 'SOCKET'
mysql server 6.0\include\mysql_com.h(304) : error C2059: syntax error : '}'
mysql server 6.0\include\mysql_com.h(418) : error C2143: syntax error : missing ')' before '*'
mysql server 6.0\include\mysql_com.h(418) : error C2143: syntax error : missing '{' before '*'
mysql server 6.0\include\mysql_com.h(418) : error C2371: 'Vio' : redefinition; different basic types
mysql server 6.0\include\mysql_com.h(254) : see declaration of 'Vio'
mysql server 6.0\include\mysql_com
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......