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

MySQLѧϰ

C APIÏà¹Ø
C APIÊý¾ÝÀàÐÍ
 MYSQL
¸Ã½á¹¹´ú±í1¸öÊý¾Ý¿âÁ¬½ÓµÄ¾ä±ú¡£¼¸ºõËùÓеÄMySQLº¯Êý¾ùʹÓÃËü¡£²»Ó¦³¢ÊÔ¿½±´MYSQL½á¹¹¡£²»±£Ö¤ÕâÀ࿽±´½á¹û»áÓÐÓá£
 MYSQL_RES
¸Ã½á¹¹´ú±í·µ»ØÐеIJéѯ½á¹û£¨SELECT, SHOW, DESCRIBE, EXPLAIN£©¡£ÔÚ±¾½ÚµÄÊ£Óಿ·Ö£¬½«²éѯ·µ»ØµÄÐÅÏ¢³ÆÎª“½á¹û¼¯”¡£
 MYSQL_ROW
ÕâÊÇ1ÐÐÊý¾ÝµÄ“ÀàÐͰ²È«”±íʾ¡£ËüĿǰÊǰ´ÕÕ¼ÆÊý×Ö½Ú×Ö·û´®µÄÊý×éʵʩµÄ¡££¨Èç¹û×Ö¶ÎÖµ¿ÉÄܰüº¬¶þ½øÖÆÊý¾Ý£¬²»Äܽ«Æäµ±×÷ÓÉNullÖÕ½áµÄ×Ö·û´®¶Ô´ý£¬ÕâÊÇÒòΪÕâÀàÖµ¿ÉÄÜ»á°üº¬Null×Ö½Ú£©¡£ÐÐÊÇͨ¹ýµ÷ÓÃmysql_fetch_row()»ñµÃµÄ¡£
 MYSQL_FIELD
¸Ã½á¹¹°üº¬¹ØÓÚ×ֶεÄÐÅÏ¢£¬Èç×Ö¶ÎÃû¡¢ÀàÐͺʹóС¡£ÕâÀïÏêϸ½éÉÜÁËÆä³ÉÔ±¡£Í¨¹ýÖØ¸´µ÷ÓÃmysql_fetch_field()£¬¿ÉΪÿ¸ö×ֶλñµÃMYSQL_FIELD½á¹¹¡£×Ö¶ÎÖµ²»ÊǸýṹµÄ×é³É²¿·Ý£¬ËüÃǰüº¬ÔÚMYSQL_ROW½á¹¹ÖС£
 MYSQL_FIELD_OFFSET
ÕâÊÇMySQL×Ö¶ÎÁÐ±íÆ«ÒÆÁ¿µÄ“ÀàÐͰ²È«”±íʾ£¨ÓÉmysql_field_seek()ʹÓã©¡£Æ«ÒÆÁ¿ÊÇÐÐÄÚµÄ×ֶαàºÅ£¬´Ó0¿ªÊ¼¡£
 my_ulonglong
ÓÃÓÚÐÐÊýÒÔ¼°mysql_affected_rows()¡¢mysql_num_rows()ºÍmysql_insert_id()µÄÀàÐÍ¡£¸ÃÀàÐÍÌṩµÄ·¶Î§Îª0¡«1.84e19¡£
ÔÚijЩϵͳÉÏ£¬²»ÄÜ´òÓ¡ÀàÐÍmy_ulonglongµÄÖµ¡£ÒªÏë´òÓ¡ÕâÀàÖµ£¬Ç뽫Æäת»»ÎªÎÞ·ûºÅ³¤ÕûÊýÀàÐͲ¢Ê¹ÓÃ%lu´òÓ¡¸ñʽ£¬ÀýÈ磺
printf ("Number of rows: %lu\n", (unsigned long) mysql_num_rows(result));


Ïà¹ØÎĵµ£º

MysqlÖÐÕÒ²»µ½.mydÎļþµÄÎÊÌâ

WordpressÓÃÁËÕâô³¤Ê±¼ä£¬Å¼¶û»áÏëÆðÀ´±¸·ÝÏÂÊý¾Ý£¬ÉÏ´ÎÊÇÓÃwpµÄxml£¬Õâ´Î°Ñ×Ô¼º»úÆ÷µÄ»·¾³ÅäµÄ¸úÖ÷»úÌṩÉÌ»ù±¾Ò»ÑùÁË£¬ÕýºÃÄDZßÓÐmysqlÊý¾Ý¿â´ò°ü±¸·ÝµÄ·þÎñ£¬¾Í³¢ÊÔÁËһϡ£¿É²»¹ÜÎÒÏÂÔØÄĸöʱ¼äµãµÄ±¸·Ý°ü£¬ÀïÃæ¶¼Ö»ÓÐwp±íµÄ10¸öfrmÎļþ£¬copyµ½ÎÒµÄÊý¾Ý¿âĿ¼ºó·ÃÎÊweb£¬Ã»ÓÐÈκÎÊý¾Ý£¡Ö±½Ó¸ã²»¶®ÁË¡£ÒÔǰ¾õµÃÓÃmysql ......

MYSQLË÷ÒýµÄʹÓÃ

ÔÚÊý¾Ý¿â±íÖУ¬¶Ô×ֶν¨Á¢Ë÷Òý¿ÉÒÔ´ó´óÌá¸ß²éѯËÙ¶È¡£¼ÙÈçÎÒÃÇ´´½¨ÁËÒ»¸ö
mytable
񡜧
CREATE TABLE mytable(
ID INT NOT NULL,
username VARCHAR(16) NOT NULL
);
ÎÒÃÇËæ»úÏòÀïÃæ²åÈëÁË
10000
Ìõ¼Ç¼£¬ÆäÖÐÓÐÒ»Ìõ£º
5555, admin
¡£
ÔÚ²éÕÒ
username="admin"
µÄ¼Ç¼
SELECT * from mytable WH ......

MySQLÊý¾Ý¿â±¸·ÝºÍ»¹Ô­µÄ³£ÓÃÃüÁî


±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ£¬Äܹ»Èøñ¸·Ý¸²¸ÇÒÑÓÐÊý¾Ý¿â¶ø²»ÐèÒªÊÖ¶¯É¾³ýÔ­ÓÐÊý¾Ý¿â¡£
mysqldump -–add-drop-table -uusername -ppassword databasename > bac ......

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ
//Ö÷¼ü549830479
alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);
//Ôö¼ÓÒ»¸öÐÂÁÐ549830479
alter table t2 add d timestamp;
alter table infos add ex tinyint not null default ......

[ת]mysqlÖÐdata_format()

DATE_FORMAT(date,format)
¸ù¾Ýformat×Ö·û´®¸ñʽ»¯dateÖµ¡£ÏÂÁÐÐÞÊηû¿ÉÒÔ±»ÓÃÔÚformat×Ö·û´®ÖУº %M ÔÂÃû×Ö(January……December)
%W ÐÇÆÚÃû×Ö(Sunday……Saturday)
%D ÓÐÓ¢Óïǰ׺µÄÔ·ݵÄÈÕÆÚ(1st, 2nd, 3rd, µÈµÈ¡££©
%Y Äê, Êý×Ö, 4 λ
%y Äê, Êý×Ö, 2 λ
%a ËõдµÄÐÇÆÚÃû×Ö(Sun&h ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ