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

oracle ¶ÔÓ¦µÄMySQLÓï¾ä

orcle Óï¾ä create table book1(name, price) as select book_name, price form book;
¶ÔÓ¦µÄMySQLµÄÓï¾äÊÇʲô

create table book1 as select book_name, price form book; ÕâÑùÔÚMySQLÀï¿ÉÒÔ£¬µ«ÊÇÈ´²»ÄܸÃÊôÐÔµÄÃû×Ö¡£
ÍêÈ«·¢´í°æÁË

ÔΣ¬Ò»¸öÊý¾Ý¿â¶¼²»°¤×Å¡£MySQl²»»á

ÎÒÒ²ÔÎÁË
µÚÒ»´ÎÌáÎÊ


BS ACMAIN_CHM


Ïà¹ØÎÊ´ð£º

mysql:´´½¨Ë÷Òý³ö´í

´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º

create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;

±£´æÎªindex ......

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

CÓïÑÔ Mysql ÒÉÎÊ

if(mysql_init(&mysql)==NULL)
{
sprintf(ErrMsg,"We are outof Memory");
return(false);
}

if(!mysql_real_connect(&mysql,"localhost","test" ......

MySQL´´½¨´æ´¢¹ý³Ì³ö´í

ÔÚMySQL5.0Öд¬½¢´æ´¢¹ý³Ìͨ²»¹ý£¬Ìáʾ£º
[Err] 1064 - 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 '' ......

WindowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼ ʧ°Ü

ϵͳµÄʼþ²é¿´Æ÷ÖпÉÒÔ¿´µ½Å¶

ÔØ£ºTable 'mysql.host' doesn't existµÄ´íÎó
»¹ÊDz»Äܽâ¾öÎÊÌâ

²Î¿¼ÈçÏÂ
indowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼
2009-04-04 08:49:20
¡¡± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ