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

»ñÈ¡ mysql ·þÎñÆ÷µÄʱ¼ä£¬·µ»Ø¿Õ£¿

<?php

  $conn=.............

  function GetNowTime(){
    $rvt=mysql_query("select now() as svTime",$conn);
    $rt=mysql_fetch_object($rvt);
    return $rt->svTime;
    mysql_free_result($rvt);
    mysql_close($conn);
  }


  echo GetNowTime()  //²»ÄÜ»ñÈ¡mysql ·þÎñÆ÷µÄµ±Ç°Ê±¼ä£¬Õâ¸ö·½·¨¶ÔÂð£¿
?>
mysqlµÄµ±Ç°Ê±¼äº¯ÊýΪnow();
phpµÄµ±Ç°Ê±¼äº¯ÊýΪdate();

ÏëÓà php »ñÈ¡ mysql ·þÎñÆ÷µÄʱ¼ä£¬¶ø²»ÊÇ php ËùÔÚ·þÎñÆ÷µÄʱ¼ä¡£


»ñÈ¡²»ÁËʱ¼ä ÊDz»ÊÇ ¸ú·þÎñÆ÷Óйأ¿

ÒýÓÃ
»ñÈ¡²»ÁËʱ¼ä ÊDz»ÊÇ ¸ú·þÎñÆ÷Óйأ¿


ÄãдµÄº¯ÊýÀïÃæµÄ $conn ÊǸö¿Õ±äÁ¿£¬ËùÒÔº¯ÊýûÓÐÁ¬½ÓÉÏÊý¾Ý¿â£¬µ¼ÖÂÈ¡²»µ½Öµ

Äã¿ÉÒÔÔÚº¯ÊýÀïÃæ global $conn; ¾Í¿ÉÒÔÁË // $conn ÔÚº¯ÊýÍâ´´½¨µÄÊý¾Ý¿âÁ¬½Ó


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......

vc++ ÓÃmysql¹Ù·½ connector ³ö´í - VC/MFC / Êý¾Ý¿â

try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......

ÈçºÎÔÚC#ÀïʵÏÖMYSQL±¸·Ý¹¦ÄܵÄÖ÷´ÓÇл»£¨Ò»Ö÷Ò»´Ó£©

ÈçÌâ
²¹³äÏ£º
  ÎÞ³ÌÐò£¬¸øË¼Â·Ò²ÐУ»


1. ÏÈÅжÏ֮ǰµÄͬ²½ÊÇ·ñÍê³ÉÁË¡£ ###ÈçºÎÅжϣ¿
2. ½øÐÐCHANGE MASTER TO ²Ù×÷¡£###ÎÒÖªµÀ¿ÉÒÔÇл»³É±¸·Ý»ú£¬µ«ÊDz»ÖªµÀÈçºÎÇл»»ØÖ÷·þÎñÆ÷£¬
ÎÒµÄÓÊÏäÊÇdo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ