¹ØÓÚʹÓÃÊÓͼȡ²»µ½¼Ç¼(Êý¾Ý¿âʹÓÃmysql)
ÔÚphpadminÖн¨Á¢ºÃÁËÒ»¸öÊÓͼroute1,È»ºóµã»÷SQL£¬ÊäÈëÓï¾ä£º
select * from route1 where startstop='¾ÅÁú' and endstop='8753²¿¶Ó';
ÔËÐÐͨ¹ý£¬·µ»ØÒ»Ìõ¼Ç¼¡£
ÏÖÔÚÎÒÏëÓô«²ÎÊýµÄ·½Ê½£¬ÔÚÒ³Ãæ±àдʼþʵÏÖ¶¯Ì¬²éѯ£¬ÎÊÌâÊǼ´±ãÓõÄÊǾ²Ì¬²éѯ·½Ê½£¬»¹ÊÇÈ¡²»µ½¼Ç¼£¡
ÈçÏ£º
mysql_connect("localhost","root","");
mysql_select_db("yangzheng");
mysql_query("set names utf8");
$re=mysql_query("select * from route1 where startstop='¾ÅÁú' and endstop='8753²¿¶Ó' ");
while($row=mysql_fetch_array($re, MYSQL_ASSOC)) {
echo("
" . $row["linename"] . "
");
}
Õâ¸öÊÂÇéÕæ¹îÒ죬»¹Íû¸ßÈËÖ¸µã¡£¡£¡£
ËäÈ»Õâ¸öÎÊÌâÎÒÒѾÊÂÏÈ×Ô¼º½â¾öÁË£¬µ«»¹ÊÇÒª½áÌù¸ø·Ö¡£ÖÁÉÙר¼ÒûÓÐ˵´í£¬ÎÒ¾ÍÊǸ͝ mysql_query("set names utf8"); ÕâÒ»¾äΪ mysql_query("set names gbk");Ö®ºóÔËÐÐͨ¹ýµÄ¡£
Ïòhelloyonu0Ö¾´¡£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......