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

MySQLÖн¨Á¢Íâ¼üÎÊÌâ

        ÄÄλ¸ßÊÖÄܸø·¢Ò»Ð©ÓйØMySQLÖн¨Á¢Íâ¼üÔ¼ÊøµÄÏêϸ½éÉÜ×ÊÁÏ£¬±¾ÈËÔÚtableÖн¨Á¢Íâ¼üÔ¼ÊøÊ±×ÜÊÇÌáʾͬһ¸ö´íÎó¡°ERROR 1005 (HY000): Can't create table 'xxx' (errno: 121)¡±£¬²»Öª¸ÃÈçºÎ½â¾ö£¬Òò´ËÔÚ½¨tableʱ£¬²»¸Ò¼ÓÍâ¼üÔ¼Êø£¬ÔÚÍøÉÏÊÕÁ˺ܾö¼Ã»ÕÒµ½ÓйصÄÏê½â£¬ºÜÊÇ¿àÄÕ¡£
          »¹Çë¸÷λ¸ßÈ˸øÓèÖ¸½Ì£¡
ÄãµÄMYSQL°æ±¾ÊǶàÉÙ£¿
ÓõÄʲô´æ´¢ÒýÇæ£¿

SQL code:
mysql> create table t1 (
-> id int primary key,
-> col int
-> )engine=innodb;
Query OK, 0 rows affected (0.09 sec)

mysql> create table t2 (
-> id int primary key,
-> tid int,
-> FOREIGN KEY (tid) REFERENCES t1(id)
-> )engine=innodb;
Query OK, 0 rows affected (0.09 sec)

mysql> insert into t2 values (2,1);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint f
ails (`csdn`.`t2`, CONSTRAINT `t2_ibfk_1` FOREIGN KEY (`tid`) REFERENCES `t1` (`
id`))
mysql> insert into t2 values (1,null);
Query OK, 1 row affected (0.05 sec)

mysql> insert into t1 values (1,91);
Query OK, 1 row affected (0.06 sec)

mysql> insert into t2 values (2,1);
Query OK, 1 row affected (0.03 sec)

mysql> select * from t2;
+----+------+
| id | tid |
+----+------+
| 1 | NULL |
| 2 | 1 |
+----+------+
2 rows in set (0.00 sec)


Ïà¹ØÎÊ´ð£º

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

MYSQL Êý¾Ý½ØÈ¡

MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);

¶¥£¬Ñ§Ï°

SQL code: ......

MysqlÁ¬½Óoracle

ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì,
·ÃÎÊoracleµÄÊý¾Ý.
Ŀǰ²»ÄÜ

oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó

ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬

ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý ......

Web¹¤³Ì³öÏÖ´íÎómysql´íÎó

ÎÒ·ÅÁËÒ»¸öJavaµÄWeb¹¤³Ìµ½Ò»¸öÃÀ¹úµÄÖ÷»ú£¬Êý¾Ý¿âÓõÄÊÇmysql£¬µ«ÓÐʱºò³öÏÖ·ÃÎÊ´íÎó
ÏÂÃæÊǺǫ́ÈÕÖ¾
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ