mysql c ½Ó¿Ú´óÈ«
MYSQLÔÚ C API ÖпÉÓõĺ¯Êý£º
mysql_affected_rows()
·µ»Ø±»×îеÄUPDATE, DELETE»òINSERT²éѯӰÏìµÄÐÐÊý¡£
mysql_close()
¹Ø±ÕÒ»¸ö·þÎñÆ÷Á¬½Ó¡£
mysql_connect()
Á¬½ÓÒ»¸öMySQL·þÎñÆ÷¡£¸Ãº¯Êý²»ÍƼö£»Ê¹ÓÃmysql_real_connect()´úÌæ¡£
mysql_change_user()
¸Ä±äÔÚÒ»¸ö´ò¿ªµÄÁ¬½ÓÉϵÄÓû§ºÍÊý¾Ý¿â¡£
mysql_create_db()
´´½¨Ò»¸öÊý¾Ý¿â¡£¸Ãº¯Êý²»ÍƼö£»¶øÊ¹ÓÃSQLÃüÁîCREATE DATABASE¡£
mysql_data_seek()
ÔÚÒ»¸ö²éѯ½á¹û¼¯ºÏÖÐËÑѰһÈÎÒâÐС£
mysql_debug()
Óøø¶¨×Ö·û´®×öÒ»¸öDBUG_PUSH¡£
mysql_drop_db()
ÅׯúÒ»¸öÊý¾Ý¿â¡£¸Ãº¯Êý²»ÍƼö£»¶øÊ¹ÓÃSQLÃüÁîDROP DATABASE¡£
mysql_dump_debug_info()
È÷þÎñÆ÷½«µ÷ÊÔÐÅϢдÈëÈÕÖ¾Îļþ¡£
mysql_eof()
È·¶¨ÊÇ·ñÒѾ¶Áµ½Ò»¸ö½á¹û¼¯ºÏµÄ×îºóÒ»ÐС£Õ⹦Äܱ»·´¶Ô; mysql_errno()»òmysql_error()¿ÉÒÔÏà·´±»Ê¹Óá£
mysql_errno()
·µ»Ø×î½ü±»µ÷ÓõÄMySQLº¯ÊýµÄ³ö´í±àºÅ¡£
mysql_error()
·µ»Ø×î½ü±»µ÷ÓõÄMySQLº¯ÊýµÄ³ö´íÏûÏ¢¡£
mysql_escape_string()
ÓÃÔÚSQLÓï¾äÖеÄ×Ö·û´®µÄתÒåÌØÊâ×Ö·û¡£
mysql_fetch_field()
·µ»ØÏÂÒ»¸ö±í×ֶεÄÀàÐÍ¡£
mysql_fetch_field_direct ()
·µ»ØÒ»¸ö±í×ֶεÄÀàÐÍ£¬¸ø³öÒ»¸ö×ֶαàºÅ¡£
mysql_fetch_fields()
·µ»ØÒ»¸öËùÓÐ×ֶνṹµÄÊý×é¡£
mysql_fetch_lengths()
·µ»Øµ±Ç°ÐÐÖÐËùÓÐÁеij¤¶È¡£
mysql_fetch_row()
´Ó½á¹û¼¯ºÏÖÐÈ¡µÃÏÂÒ»ÐС£
mysql_field_seek()
°ÑÁйâ±ê·ÅÔÚÒ»¸öÖ¸¶¨µÄÁÐÉÏ¡£
mysql_field_count()
·µ»Ø×î½ü²éѯµÄ½á¹ûÁеÄÊýÁ¿¡£
mysql_field_tell()
·µ»ØÓÃÓÚ×îºóÒ»¸ömysql_fetch_field()µÄ×ֶιâ±êµÄλÖá£
mysql_free_result()
ÊÍ·ÅÒ»¸ö½á¹û¼¯ºÏʹÓõÄÄÚ´æ¡£
mysql_get_client_info()
·µ»Ø¿Í»§°æ±¾ÐÅÏ¢¡£
mysql_get_host_info()
·µ»ØÒ»¸öÃèÊöÁ¬½ÓµÄ×Ö·û´®¡£
mysql_get_proto_info()
·µ»ØÁ¬½ÓʹÓõÄÐÒé°æ±¾¡£
mysql_get_server_info()
·µ»Ø·þÎñÆ÷°æ±¾ºÅ¡£
mysql_info()
·µ»Ø¹ØÓÚ×î½üÖ´ÐеòéѯµÄÐÅÏ¢¡£
mysql_init()
»ñµÃ»ò³õʼ»¯Ò»¸öMYSQL½á¹¹¡£
mysql_insert_id()
·µ»ØÓÐǰһ¸ö²éѯΪһ¸öAUTO_INCREMENTÁÐÉú³ÉµÄID¡£
mysql_kill()
ɱËÀÒ»¸ö¸ø¶¨µÄÏ̡߳£
mysql_list_dbs()
·µ»ØÆ¥ÅäÒ»¸ö¼òµ¥µÄÕýÔò±í´ïʽµÄÊý¾Ý¿âÃû¡£
mysql_list_fields()
·µ»ØÆ¥ÅäÒ»¸ö¼òµ¥µÄÕýÔò±í´ïʽµÄÁÐÃû¡£
mysql_list_processes()
·µ»Øµ±Ç°·þÎñÆ÷Ï̵߳ÄÒ»ÕÅ±í¡£
mysql_list_tables()
·µ»ØÆ¥ÅäÒ»¸ö¼òµ¥µÄÕýÔò±í´ïʽ
Ïà¹ØÎĵµ£º
Boss˵£¬Òª¿´OpenGL£¬¿´ÁË¿ìÒ»¸öÔ£¬×ÜËã³öÁ˸öÏñÑùµÄ¶«Î÷£¬ÓÃCдÁ˸ö3DÃÔ¹¬£¬
ËäȻֻÓÐ350ÐÐ
´úÂ룬²»¹ý±ßѧ±ßд£¬×ã×ãдÁËÒ»ÖÜʱ¼ä£¬»¹ÊÇСÓгɾ͸е쬻î»î»î£¡
&n ......
Linux ²Ù×÷ϵͳ C ÓïÑÔ±à³ÌÈëÃÅ
Ŀ ¼
µÚÒ»Õ »ù´¡ÖªÊ¶ ……………………………………………………………4
µÚ¶þÕÂ ......
Î塢ʼþµ÷¶ÈÆ÷²âÊÔ
5.1¡¢²âÊÔÄ¿µÄ
5.1.1 ÅäÖ÷½·¨
5.1.2 ÊÇ·ñÕý³£¹¤×÷
5.1.3 ÈÕ³£µÄά»¤
5.2¡¢Ê¼þµ÷¶ÈÆ÷½éÉÜ
×ÔMySQL5.1.6Æð£¬Ôö¼ÓÁËÒ»¸ö·Ç³£ÓÐÌØÉ«µÄ¹¦ÄÜ
–ʼþµ÷¶ÈÆ÷(Event Scheduler)£¬¿ÉÒÔÓÃ×ö¶¨Ê±Ö´ÐÐÄ³Ð©ÌØ¶¨ÈÎÎñ£¨ÀýÈ磺ɾ³ý
¼Ç¼¡¢¶ÔÊý¾Ý
½øÐлã×ܵȵȣ©£¬À´È¡´ ......
http://hi.baidu.com/qk618/blog/item/f61e5830f2125d93a9018e0c.html
½â¾öÔ¶³ÌÁ¬½Ómysql´íÎó1130´úÂëµÄ·½·¨
½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ ......
#include <unistd.h>
#include <stdlib.h>
#include <stdio.h>
#include <string.h>
#define err(msg) perror(msg)
static void mkdirs(const char *dir)
{
char tmp[1024];
char *p;
&nbs ......