MYSQL ɾ³ýÖ÷¼ü³öÏÖ´íÎó£¡
mysql> select * from a;
+----+------+----------+
| id | name | password |
+----+------+----------+
| 1 | a | NULL |
| 2 | a | NULL |
| 3 | a | NULL |
| 4 | a | NULL |
+----+------+----------+
4 rows in set (0.00 sec)
mysql> alter table a drop primary key(id);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '(id)'
at line 1
mysql>
ʲôÔÒò°¡£¿£¿£¿£¿
µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£º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("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
mysql¶¨Ê±±¸·Ý ÔÚwindowsÉÏ
¿ÉÒÔÏÂÔØÒ»¸ö Navicat for MySQL£¬ÀïÃæÓиö¶¨Ê±±¸·Ý¹¦ÄÜ£¬·Ç³£ºÃÓá£
дһ¸öphpµÄ±¸·Ýº¯Êý.È»ºóÀûÓÃwindowsµÄ¼Æ»®ÈÎÎñÖ´Ðб¸·Ý³ÌÐò!
Navicat¡£¡£ÀïÃæ¿ÉÒÔд±¸·Ý¼Æ»®µÈ
ÊDz»ÊÇÓà ......