mysql´óСдÎÊÌâ
ÎÒ
insert into Users (account) values ("test"); ¿ÉÒÔ¡£
È»ºóÔÙÖ´ÐÐ
insert into Users (account) values ("Test");
¾Í±¨´íDuplicate entry 'Test' for key x
linux»·¾³£¬ ÇëÎÊÈçºÎÈÃmysql Àïvarchar ×Ö¶ÎÖ§³Ö´ó²»Ð´Çø·Ö£¿
²Î¿¼ÏÂÌùÖÐÓйØ×Ö·û¼¯µÄ½éÉÜ¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
ллÀÏ´ó¡£
¹þ ËäÈ»ÎÒÒ²ÊDzËÄñ µ«ÎÒÒ²ÈÏΪÊÇ×Ö·û¼¯µÄÎÊÌâ..
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
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 ......
ÔÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......
ÔÚmysqlµÄ½Å±¾Ä£Ê½Ï£¬-t±íʾÒÔ±í¸ñµÄÐÎʽÊä³ö½á¹û£¬Èç¹ûÐèÒªÖÆ±í·û¶¨½çµÄÊä³ö¿ÉÒÔÊ¡ÂÔ´ËÑ¡Ïî¡£ ÕâÑùµÄÊä³öÊǾßÓбí¸ñÐÎʽµÄÊä³ö£¬
Õâ¸öÊÇÊéÉÏ˵µÄ£¬Õâ¾ä»°ÊDz»ÊÇÓÐʲôÎÊÌ⣿
ÊDz»ÊÇÖÆ±í·ûºÍ±í¸ñÐÎʽ£¬²»ÊÇÒ»»ØÊ ......