¹ØÓÚmysqlµÄÒ»¸öÎÊÌ⣬лл
ÇëÎÊÕâÀïµÄquestionsÊÇʲôÒâ˼°¡£¬»¹ÓÐopens,´ò¿ªÊ²Ã´±íÄØ,лл
mysqladmin statusÃüÁîµÄ½á¹ûÏÔʾÏÂÃæµÄÖµ
Questions
·þÎñÆ÷Æô¶¯ÒÔÀ´¿Í»§µÄÎÊÌâ(²éѯ)ÊýÄ¿
Opens
·þÎñÆ÷ÒѾ´ò¿ªµÄÊý¾Ý¿â±íµÄÊýÁ¿
Flush tables
·þÎñÆ÷ÒѾִÐеÄflush ...¡¢refreshºÍreloadÃüÁîµÄÊýÁ¿¡£
ѧϰ¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......