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 ......
int main(int argc, char* argv[])
{
/**//* ************************************************************
Ö¸Õë
**************************************************************/
......
ʹÓÃÕûÊýÊý¾ÝµÄ¾«È·Êý×ÖÊý¾ÝÀàÐÍ¡£
bigint
´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£
int
´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,647) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer¡£
smallin ......
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
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ ......
¡¡¡¡ÊÂÎñÊÇDBMSµÃÖ´Ðе¥Î»¡£ËüÓÉÓÐÏÞµÃÊý¾Ý¿â²Ù×÷ÐòÁÐ×é³ÉµÃ¡£µ«²»ÊÇÈÎÒâµÃÊý¾Ý¿â²Ù×÷ÐòÁж¼ÄܳÉΪÊÂÎñ¡£Ò»°ãÀ´Ëµ£¬ÊÂÎñÊDZØÐëÂú×ã4¸öÌõ¼þ£º£¨ACID£©
¡¡¡¡Ô×ÓÐÔ£¨Autmic£©£ºÊÂÎñÔÚÖ´ÐÐÐÔ£¬Òª×öµ½“Ҫô²»×ö£¬ÒªÃ´È«×ö£¡”£¬¾ÍÊÇ˵²»ÔÊÐíÊÂÎñ²¿·ÖµÃÖ´ÐС£¼´Ê¹ÒòΪ¹ÊÕ϶øʹÊÂÎñ²»ÄÜÍê³É£¬ÔÚrollbackʱҲҪÏû³ý¶ÔÊ ......