mysql Ôõôɾ³ýÎ¨Ò»Ô¼Êø£¿
±íÃû nnn ÁÐÃû myname£¨¿ÉÒÔΪ¿Õ£©
Ïëɾ³ýÎ¨Ò»Ô¼Êø
MYSQLÓÐÇëСÁº
GoogleÕÒÁ˰ëÌ죬ºÜÎÞÁ¦¡«¡«£¬Ö»ÕÒµ½´´½¨£¬Ã»ÕÒµ½É¾³ý
ÕæÊÇÖ»¹Ü½á»é²»¹ÜÉúº¢×Ó¡«¡«¡«¡«
mysql> show create table nnn;
+-------+------------------------------------------
---------------------------------------------------
-------------------------------------------+
| Table | Create Table
|
+-------+------------------------------------------
---------------------------------------------------
-------------------------------------------+
| nnn | CREATE TABLE `nnn` (
`id` int(11) NOT NULL auto_increment,
`myname` varchar(20) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `myname` (`myname`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 |
+-------+------------------------------------------
---------------------------------------------------
-------------------------------------------+
1 row in set (0.00 sec)
´ó¸ç£¬ÎÒÕÒÄãºÃ¾ÃÁË
SQL code
Code highlighting produced by Actipro CodeHighlighter
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......